public void Delete(int ID)
{
JurnalRabot pac = db5.JurnalRabot.Where(c => c.ID == ID).FirstOrDefault();
db5.JurnalRabot.DeleteOnSubmit(pac);
db5.SubmitChanges();
var ec = from n in db2.IspolOborud
where n.IDRabot == ID
select n;
foreach (var i in ec)
{
IspolOborud pac2 = db2.IspolOborud.Where(c => c.IDRabot == ID).FirstOrDefault();
db2.IspolOborud.DeleteOnSubmit(pac2);
db2.SubmitChanges();
}
var ec2 = from n in db2.IspolOborud
where n.IDRabot == ID
select n;
foreach (var i in ec2)
{
IspolPabot pac3 = db3.IspolRabot.Where(c => c.IDRabot == ID).FirstOrDefault();
db3.IspolRabot.DeleteOnSubmit(pac3);
db3.SubmitChanges();
}
}
public void Delete(int ID)
{
IspolOborud pac = db2.IspolOborud.Where(c => c.ID == ID).FirstOrDefault();
db2.IspolOborud.DeleteOnSubmit(pac);
db2.SubmitChanges();
}
public void Edit(int ID, int IDRabot, int IDMedicamenta)
{
IspolOborud pac = db2.IspolOborud.Where(c => c.ID == ID).FirstOrDefault();
pac.IDMedicamenta = IDMedicamenta;
pac.IDRabot = IDRabot;
db2.SubmitChanges();
}
public void ADD(int IDRabot, int IDMedicamenta)
{
IspolOborud pac = new IspolOborud();
pac.IDMedicamenta = IDMedicamenta;
pac.IDRabot = IDRabot;
db2.IspolOborud.InsertOnSubmit(pac);
db2.SubmitChanges();
}
