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