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";
}
}
