{(r.Read())
{= (int)r[0];
}
}
= newSqlCommand(@"SELECT [Number], [Itog], [Surname], [Name_subject], [Grup_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Grup_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name](SELECT [ID_Grup], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect]INNER JOIN [Teacher_Subject] on [Connect].ID_Teacher_Subject=Teacher_Subject.ID_Teacher_Subject[Connect].[ID_Grup]=" + IDt2.ToString() + @") AS t1 INNER JOIN [Grup]t1.ID_Grup=Grup.ID_Grup) AS t2 ON t2.ID_Cabinet=Cabinet.ID_cabinet) as t3 ON Subject.ID_subject=t3.ID_Subject) AS t4 ON Teacher.ID_Teacher=t4.ID_Teacher", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConnect((string)r[2], (string)r[3], (string)r[4], (int)r[0], (int)r[1]));
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].teach;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].cabinet.ToString();
}awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
{= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] =" + listBox_Select.SelectedItem.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}
= newSqlCommand(@"SELECT [Number], [Itog], [Surname], [Name_subject], [Grup_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Grup_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name](SELECT [ID_Grup], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect]INNER JOIN [Teacher_Subject] on Connect.ID_Teacher_Subject=Teacher_Subject.ID_Teacher_Subject[Connect].[ID_Teacher_Subject]=" + IDt1.ToString() + @") AS t1 INNER JOIN [Grup] ON t1.ID_Grup=Grup.ID_Grup) AS t2t2.ID_Cabinet=Cabinet.ID_cabinet) as t3 ON Subject.ID_subject=t3.ID_Subject) AS t4 ON Teacher.ID_Teacher=t4.ID_Teacher", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConnect((string)r[2], (string)r[3], (string)r[4], (int)r[0], (int)r[1]));
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].grup;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].teach;
}
awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
}.Close();
}<TSS> Arg = newList<TSS>();
dataGridView_Info_SelectionChanged(object sender, EventArgs e)
{(dataGridView_Info.SelectedRows.Count > 0)
{(int i = 0; i < Butts.Count; i++)
{[i].BackColor = Color.LightGray;[i].Text = "Выбрать";
}
{.Open();
}
{.Close();.Open();
}IDC = 0;IDL = 0;
IDG = 0;TUTU = true;(rb_Teacher.Checked == true)
{(int i = 0; i < 42; i++)
{= true;q = dataGridView_Info.SelectedRows[0].Cells[2].Value.ToString();= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] = " + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}
= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_cabinet] = " + IDC.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(IDL != 43)
{(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}
}(TUTU)
{= 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] = " + IDG.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";
}
}
}
{(rb_Group.Checked == true)
{(int i = 0; i < 42; i++)
{q = dataGridView_Info.SelectedRows[0].Cells[2].Value.ToString();= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] = " + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_cabinet] = " + IDC.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}(TUTU)
{ID_Teacher = 0;= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE '" + dataGridView_Info.SelectedRows[0].Cells[0].Value.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{.Read();_Teacher = (int)r[0];
}
= newSqlCommand("SELECT [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher] =" + ID_Teacher.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";
}
}
}
{(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_Group_CheckedChanged(object sender, EventArgs e)
{.Open();_Select.Items.Clear();= newSqlCommand("SELECT [Grup_Name] FROM [Grup]", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_Select.Items.Add((string)r[0]);
}
}.Close();
}rb_Teacher_CheckedChanged(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_cabinet_CheckedChanged(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();
}<CONLes> CL = newList<CONLes>();button1_Click(object sender, EventArgs e)
{(button1.BackColor == Color.Green)
{.Open();IDCon = 0;= newSqlCommand(@"SELECT [ID_Connect] FROM
(SELECT [ID_Connect], [ID_Teacher_Subject] FROM
(Select [ID_Connect], [ID_Teacher_Subject], [ID_Grup][Connect] INNER Join
(select [ID_Cabinet] FROM [Cabinet] WHERE [Number] =" + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString() + @")as t1[Connect].ID_Cabinet = t1.ID_cabinet) as t2 INNER JOIN
(SELECT [ID_Grup] FROM [Grup] WHERE [Grup_Name] Like '" + dataGridView_Info.SelectedRows[0].Cells[0].Value.ToString() + @"' )as t3t2.ID_Grup=t3.ID_Grup) as t4 INNER JOIN
(SELECT [ID_Teacher_Subject] FROM (SELECT [ID_Teacher_Subject], [ID_Subject] FROM Teacher_Subject INNER JOIN
(SELECT [ID_Teacher] from Teacher where [Surname] LIKE '" + listBox_Select.SelectedItem.ToString() + @"' )as t6 on_Subject.ID_Teacher=t6.ID_Teacher) as t8 INNER JOIN
(SELECT [ID_Subject] FROM [Subject] WHERE [Name_subject] LIKE '" + dataGridView_Info.SelectedRows[0].Cells[1].ToString() + @"' )as t7 on t8.ID_Subject=t7.ID_subject)as t5t5.ID_Teacher_Subject=t4.ID_Teacher_Subject", con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}= newSqlCommand(@"SELECT [ID_Lesson], [ID_Connect], [Itog], [ID_Cabinet], [ID_Teacher_Subject], [ID_Grup] FROM [Connect] WHERE [ID_Connect]=" + IDCon.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();.Add(newCONLes((int)r[0], (int)r[1], (int)r[2], (int)r[3], (int)r[4], (int)r[5]));
}(int i = 0; i < CL.Count; i++)
{((CL[i].itog != 0) && (CL[i].IDl == 43))
{= newSqlCommand(@"UPDATE [dbo].[Connect][Itog] = [Itog] - 1[dbo].[Connect].[ID_Connect] = " + IDCon.ToString(), con);.ExecuteNonQuery();a = 1;= newSqlCommand("INSERT INTO [Connect] ([ID_Lesson], [ID_Cabinet], [ID_Grup], [Itog]) VALUES ('" + a.ToString() + "','" + CL[i].IDcab.ToString() + "','" + CL[i].IDg.ToString() + "','" + a.ToString() + "')", con);.ExecuteNonQuery();
}
{((CL[i].itog != 0) && (CL[i].IDl != 43))
{= newSqlCommand(@"UPDATE [dbo].[Connect][Itog] = [Itog] + 1[dbo].[Connect].[ID_Connect] = " + IDCon.ToString(), con);.ExecuteNonQuery();
}
{.Show("Ошибка");
}
}
}.Close();
}
}
comboBox_corpus_SelectedIndexChanged_1(object sender, EventArgs e)
{.Open();_cabinet.Items.Clear();= newSqlCommand("SELECT [Number] FROM [Cabinet] WHERE [Number_campus]=" + comboBox_corpus.SelectedItem.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_cabinet.Items.Add((int)r[0]);
}
}.Close();
}listBox_Select_SelectedIndexChanged_1(object sender, EventArgs e)
{_Info.Rows.Clear();.Open();
(rb_Teacher.Checked == true)
{
= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE'" + listBox_Select.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [ID_Teacher_Subject], [ID_Teacher], [ID_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher]=" + IDt1.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConectTeachSubject((int)r[0], (int)r[1], (int)r[2]));//былпиздец
}
}
(int i = 0; i < Rt.Count; i++)
{= newSqlCommand(@"SELECT [Number], [Itog], [Surname],[Name_subject], [Group_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Group_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Group_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Group_Name](SELECT [ID_Group], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect] INNER JOIN [Teacher_Subject] on.ID_Teacher_Subject=Teacher_Subject.ID_Teacher_SubjectTeacher_Subject.ID_Teacher_Subject " + Rt[i].ID_teacher_subject + @") AS t1 INNER JOIN[Grup]t1.ID_Group = Grup.ID_Group) AS t2 ON t2.ID_Cabinet = Cabinet.ID_cabinet) as t3Subject.ID_subject = t3.ID_Subject) AS t4 ON Teacher.ID_Teacher = t4.ID_Teacher", con);
(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{a = r[0]; var b = r[1] isint ? r[1] : 0; var c = r[2]; var d = r[3]; var e1 = r[4];.Add(newConnect((string)c, (string)d, (string)e1, (int)a, (int)b));
}
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].grup;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].cabinet.ToString();
}awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
{(rb_Group.Checked == true)
{= newSqlCommand("SELECT [ID_Grup] FROM [Grup] WHERE [Grup_Name] LIKE'" + listBox_Select.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand(@"SELECT [Number], [Itog], [Surname], [Name_subject], [Group_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Group_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Group_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Group_Name](SELECT [ID_Group], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect]INNER JOIN [Teacher_Subject] on [Connect].ID_Teacher_Subject=Teacher_Subject.ID_Teacher_Subject[Connect].[ID_Group]=" + IDt2.ToString() + @") AS t1 INNER JOIN [Grup]t1.ID_Group=Grup.ID_Group) AS t2 ON t2.ID_Cabinet=Cabinet.ID_cabinet) as t3 ON Subject.ID_subject=t3.ID_Subject) AS t4 ON Teacher.ID_Teacher=t4.ID_Teacher", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConnect((string)r[2], (string)r[3], (string)r[4], (int)r[0], (int)r[1]));
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].teach;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].cabinet.ToString();
}awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
{= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] =" + listBox_Select.SelectedItem.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand(@"SELECT [Number], [Itog], [Surname], [Name_subject], [Group_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Group_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Group_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Group_Name](SELECT [ID_Group], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect]INNER JOIN [Teacher_Subject] on Connect.ID_Teacher_Subject=Teacher_Subject.ID_Teacher_Subject[Connect].[ID_Teacher_Subject]=" + IDt1.ToString() + @") AS t1 INNER JOIN [Grup] ON t1.ID_Group=Grup.ID_Group) AS t2t2.ID_Cabinet=Cabinet.ID_cabinet) as t3 ON Subject.ID_subject=t3.ID_Subject) AS t4 ON Teacher.ID_Teacher=t4.ID_Teacher", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConnect((string)r[2], (string)r[3], (string)r[4], (int)r[0], (int)r[1]));
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].grup;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].teach;
}awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
}.Close();
}Teacher_Cabinet_button_Click_1(object sender, EventArgs e)
{.Visible = false;_Cabinet f1 = newTeacher_Cabinet(constrc, this);.Show();
}listBox_teacher_SelectedIndexChanged_1(object sender, EventArgs e)
{_subject.ClearSelected();_subject.Items.Add("Математика");_subject.Items.Add("ИнформатикаиИКТ");_subject.Items.Add("Классныйчас");
listBox_subject.Items.Add("Введение в специальность");
teach = listBox_teacher.SelectedItem.ToString();.Open();<TCab> ConL = newList<TCab>();(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE'" + teach.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{[i].IDT = (int)r[0];
}
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [t1].Name_subject FROM (SELECT [Teacher_Subject].ID_Subject,[Teacher_Subject].ID_Teacher, [Subject].Name_subject FROM [Teacher_Subject] INNER JOIN [Subject] ON [Teacher_Subject].ID_Subject = [Subject].ID_subject) AS t1 WHERE [t1].ID_Teacher =" + ConL[i].IDT.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_subject.Items.Add((string)r[0]);
}
}
}.Close();
}dataGridView_Info_SelectionChanged_1(object sender, EventArgs e)
{(dataGridView_Info.SelectedRows.Count > 0)
{(int i = 0; i < Butts.Count; i++)
{[i].BackColor = Color.LightGray;[i].Text = "Выбрать";
}
{.Open();
}
{.Close();.Open();
}IDC = 0;IDL = 0;IDG = 0;TUTU = true;(rb_Teacher.Checked == true)
{(int i = 0; i < 42; i++)
{= true;q = dataGridView_Info.SelectedRows[0].Cells[2].Value.ToString();= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] = " + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_cabinet] = " + IDC.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(IDL != 43)
{(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}
}
(TUTU)
{= 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] = " + IDG.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";
}
}
}
{(rb_Group.Checked == true)
{q = dataGridView_Info.SelectedRows[0].Cells[2].Value.ToString();= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number] = " + dataGridView_Info.SelectedRows[0].Cells[3].Value.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{.Read();= (int)r[0];
}
= newSqlCommand("SELECT [ID_Lesson] FROM [Connect] WHERE [ID_cabinet] = " + IDC.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];(((IDL - 1) / 7 == i / 7) && ((IDL % 7) == i % 7))
{= false;;
}
}
}(TUTU)
{ID_Teacher = 0;= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE '" + dataGridView_Info.SelectedRows[0].Cells[0].Value.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{.Read();_Teacher = (int)r[0];
}= newSqlCommand("SELECT [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher] =" + ID_Teacher.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 = "Свободнаяжопка";