private void button3_Click(object sender, EventArgs e) { DB11 db = new DB11(kursach.Program.Pole.pole); var Raspisanie = from n in db.Raspisanie where n.ID == Convert.ToInt32(comboBox1.Items[comboBox1.SelectedIndex]) select n; foreach (var i in Raspisanie) { var Vrach = from n2 in db14.Vrach where n2.ID == i.IDVrach select n2; var Vrem = from n2 in db15.Vrem where n2.ID == i.IDVrem select n2; foreach (var j in Vrach) { foreach (var k in Vrem) { comboBox2.Text = i.ID + " " + k.Den + " " + k.VremN + "-" + k.VremK; } comboBox3.Text = j.FIO; } } }
private void Raspisanie_Load(object sender, EventArgs e) { DB14 db = new DB14(kursach.Program.Pole.pole); DB11 db2 = new DB11(kursach.Program.Pole.pole); DB15 db3 = new DB15(kursach.Program.Pole.pole); var ec = from n in db.Vrach select n; var ec2 = from n2 in db2.Raspisanie select n2; var ec3 = from n3 in db3.Vrem select n3; label1.Text += "\n"; label2.Text += "\n"; label3.Text += "\n"; label4.Text += "\n"; label5.Text += "\n"; label6.Text += "\n"; label7.Text += "\n"; label8.Text += "\n"; foreach (var i in ec) { label1.Text += i.FIO + "\n"; foreach (var i2 in ec2) { if (i.ID == i2.IDVrach) { foreach (var i3 in ec3) { if (i2.IDVrem == i3.ID) { if (i3.Den == "Понедельник") { label2.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Вторник") { label3.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Среда") { label4.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Четверг") { label5.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Пятница") { label6.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Суббота") { label7.Text += i3.VremN + "-" + i3.VremK; } if (i3.Den == "Воскресенье") { label8.Text += i3.VremN + "-" + i3.VremK; } } } } } label2.Text += "\n"; label3.Text += "\n"; label4.Text += "\n"; label5.Text += "\n"; label6.Text += "\n"; label7.Text += "\n"; label8.Text += "\n"; } }