private void button3_Click(object sender, EventArgs e) { DB15 db = new DB15(kursach.Program.Pole.pole); var ec = from n in db.Vrem where n.ID == Convert.ToInt32(comboBox2.Items[comboBox2.SelectedIndex]) select n; foreach (var i in ec) { dateTimePicker1.Text = i.VremN.ToString(); dateTimePicker2.Text = i.VremK.ToString(); comboBox1.Text = i.Den; } }
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"; } }