public static tblManager GetManagerById(int id)
{
try
{
using (dbFirmEntities context = new dbFirmEntities())
{
tblManager result = (from x in context.tblManagers where x.managerId == id select x).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public static tblManager AddManager(tblManager manager)
{
try
{
using (dbFirmEntities context = new dbFirmEntities())
{
if (manager.managerId == 0)
{
//add
tblManager newManager = new tblManager();
newManager.officeNumber = manager.officeNumber;
newManager.successfulProjects = manager.successfulProjects;
newManager.email = manager.email;
newManager.backupPassword = manager.backupPassword;
newManager.userId = manager.userId;
context.tblManagers.Add(newManager);
context.SaveChanges();
manager.managerId = newManager.managerId;
return(manager);
}
else
{
tblManager managerToEdit = (from x in context.tblManagers where x.managerId == manager.managerId select x).FirstOrDefault();
managerToEdit.officeNumber = manager.officeNumber;
managerToEdit.levelOfResponsibility = manager.levelOfResponsibility;
managerToEdit.salary = manager.salary;
managerToEdit.successfulProjects = manager.successfulProjects;
managerToEdit.backupPassword = manager.backupPassword;
managerToEdit.email = manager.email;
managerToEdit.userId = manager.userId;
context.SaveChanges();
return(manager);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
