public static string TypeOfAdmin(tblAdministrator a) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblAdminType result = (from x in context.tblAdminTypes where x.adminTypeId == a.adminTypeId select x).FirstOrDefault(); return(result.name); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static tblAdministrator GetAdminById(int id) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblAdministrator result = (from x in context.tblAdministrators where x.administratorId == id select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static tblAdministrator AddAdministrator(tblAdministrator admin) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (admin.administratorId == 0) { //add tblAdministrator newAdmin = new tblAdministrator(); newAdmin.adminTypeId = admin.adminTypeId; //exipry date +7days DateTime d = DateTime.Now; d = d.AddDays(7); newAdmin.expiryDate = d.Date; newAdmin.userId = admin.userId; context.tblAdministrators.Add(newAdmin); context.SaveChanges(); admin.administratorId = newAdmin.administratorId; return(admin); } else { tblAdministrator adminToEdit = (from x in context.tblAdministrators where x.administratorId == admin.administratorId select x).FirstOrDefault(); adminToEdit.expiryDate = admin.expiryDate; adminToEdit.adminTypeId = admin.adminTypeId; adminToEdit.userId = admin.userId; context.SaveChanges(); return(admin); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }