//null or manager
public static tblClinicManager isManager(tblUser e)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicManager result = (from x in context.tblClinicManagers where x.userId == e.userId select x).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public static void DeleteManager(tblClinicManager manager)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicManager toDelete = (from u in context.tblClinicManagers where u.managerId == manager.managerId select u).First();
context.tblClinicManagers.Remove(toDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public static tblClinicManager AddManager(tblClinicManager manager)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
if (manager.managerId == 0)
{
//add
tblClinicManager newManager = new tblClinicManager();
newManager.floorNumber = manager.floorNumber;
newManager.maxNumberOfDoctors = manager.maxNumberOfDoctors;
newManager.minNumberOfRooms = manager.minNumberOfRooms;
newManager.numberOfOmissions = manager.numberOfOmissions;
newManager.userId = manager.userId;
context.tblClinicManagers.Add(newManager);
context.SaveChanges();
manager.managerId = newManager.managerId;
return(manager);
}
else
{
tblClinicManager managerToEdit = (from x in context.tblClinicManagers where x.managerId == manager.managerId select x).FirstOrDefault();
managerToEdit.floorNumber = manager.floorNumber;
managerToEdit.maxNumberOfDoctors = manager.maxNumberOfDoctors;
managerToEdit.minNumberOfRooms = manager.minNumberOfRooms;
managerToEdit.numberOfOmissions = manager.numberOfOmissions;
managerToEdit.userId = manager.userId;
context.SaveChanges();
return(manager);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}