}
{[i].BackColor = Color.IndianRed;[i].Text = "Reserved";
}
}
}
{(int i = 0; i < 42; i++)
{= newSqlCommand("SELECT [ID_Grup] FROM [Grup] WHERE [Grup_Name] LIKE '" + dataGridView_Info.SelectedRows[0].Cells[0].Value.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}
= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_Grup] = " + IDC.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}(TUTU)
{= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE '" + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}= newSqlCommand("SELECT [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher] =" + IDG.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();.Add(newTSS((int)r[0]));
}(int j = 0; j < Arg.Count; j++)
{= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_Grup] = " + Arg[i].IDTS.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}
}
}(TUTU)
{[i].BackColor = Color.Green;[i].Text = "Свободнаяжопка";
}
{[i].BackColor = Color.IndianRed;[i].Text = "Reserved";
}
}
}
}.Close();
}
}
rb_Teacher_CheckedChanged_1(object sender, EventArgs e)
{.Open();_Select.Items.Clear();= newSqlCommand("SELECT [Surname] FROM [Teacher]", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_Select.Items.Add((string)r[0]);
}
}.Close();
}rb_Group_CheckedChanged_1(object sender, EventArgs e)
{.Open();_Select.Items.Clear();= newSqlCommand("SELECT [Group_Name] FROM [Grup]", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_Select.Items.Add((string)r[0]);
}
}.Close();
}
rb_cabinet_CheckedChanged_1(object sender, EventArgs e)
{.Open();_Select.Items.Clear();= newSqlCommand("SELECT [Number] FROM [Cabinet]", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_Select.Items.Add((int)r[0]);
}
}.Close();
}