// D-Delete
public bool DeleteDepartmentById(int departmentId)
{
using (var db = new ClinicDBEntities())
{
List <int> departmentIds = GetAllDepartmentIds();
if (departmentIds.Contains(departmentId))
{
MessageBox.Show("Ne mozete obrisati departman dok god na njemu rade neki doktori!");
return(false);
}
else
{
try
{
// trigger
Klinika_Departman departmanKlinika = db.Klinika_Departman.Where(x => x.DepartmanDepartman_Id == departmentId).FirstOrDefault();
db.Entry(departmanKlinika).State = System.Data.Entity.EntityState.Deleted;
//departman = db.Departmen.Where(x => x.Departman_Id == departmentId).FirstOrDefault();
//db.Entry(departman).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
MessageBox.Show("Ne mozete obrisati departman dok god na njemu rade neki doktori / \nleze neki pacijenti!");
return(false);
}
}
}
}
// C = Create
public void CreateDepartment(string naziv, string sprat, int clinicId)
{
// dodavanje u tabelu departman
Departman departman = new Departman(naziv, sprat);
using (var db = new ClinicDBEntities())
{
db.Departmen.Add(departman);
db.SaveChanges();
}
// dodavanje u medjutabelu
Klinika_Departman kd = new Klinika_Departman()
{
KlinikaKlinika_Id = clinicId,
DepartmanDepartman_Id = departman.Departman_Id
};
using (var db = new ClinicDBEntities())
{
db.Klinika_Departman.Add(kd);
db.SaveChanges();
}
}
