public bool DeleteDomaci(int domaciID) { try { using (var db = new ModelOsnovnaSkolaContainer()) { Domaci d = (Domaci)db.Kontrolna_tacka.SingleOrDefault(x => x.Id_kontrolne_tacke == domaciID); List <Radi> dRadi = db.Rade.Where(x => x.Kontrolna_tackaId_kontrolne_tacke == domaciID).ToList(); foreach (var item in dRadi) { db.Entry(item).State = EntityState.Deleted; } db.SaveChanges(); db.Entry(d).State = EntityState.Deleted; db.SaveChanges(); return(true); } }catch (Exception e) { Console.WriteLine("Message:\n" + e.Message + "\nTrace:\n\n" + e.StackTrace + "\nInner:\n\n" + e.InnerException); return(false); } }
public bool AddDomaci(DomaciIM domaci, OblastIM oblast) { using (var db = new ModelOsnovnaSkolaContainer()) { try { Oblast o = db.Oblasti.Include(x => x.Kontrolna_tacka).SingleOrDefault(x => x.Id_oblasti == oblast.Id_oblasti); Domaci d = new Domaci() { ZaposleniId_zaposlenog = domaci.ZaposleniId_zaposlenog, dan_predaje = domaci.dan_predaje, dan_zadavanja = domaci.dan_zadavanja, zadatak = domaci.zadatak, Oblast = o }; db.Kontrolna_tacka.Add(d); db.SaveChanges(); return(true); }catch (Exception e) { Console.WriteLine("Message: " + e.Message + "\nInner: " + e.InnerException.Message); return(false); } } }
public bool ChangeDomaci(DomaciIM domaci) { Domaci d = domaciDAO.FindById(domaci.Id_kontrolne_tacke); d.dan_predaje = domaci.dan_predaje; d.dan_zadavanja = domaci.dan_zadavanja; d.zadatak = domaci.zadatak; return(domaciDAO.Update(d)); }
public bool AddDomaci(DomaciIM domaci) { Domaci d = new Domaci() { ZaposleniId_zaposlenog = domaci.ZaposleniId_zaposlenog, dan_predaje = domaci.dan_predaje, dan_zadavanja = domaci.dan_zadavanja, zadatak = domaci.zadatak, }; return(domaciDAO.Insert(d)); }
public DomaciIM GetDomaciById(int domaciID) { Domaci d = domaciDAO.FindById(domaciID); return(new DomaciIM() { Id_kontrolne_tacke = d.Id_kontrolne_tacke, zadatak = d.zadatak, dan_predaje = d.dan_predaje, dan_zadavanja = d.dan_zadavanja, ZaposleniId_zaposlenog = d.ZaposleniId_zaposlenog }); }