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