//public string getCurrentDepartmentHeadName(int currentDeputyHeadId) //{ // var q = context.DepartmentCoveringHeadRecord.Where(x => x.UserId == currentDeputyHeadId).First(); // Models.User u = q; // string name = u.Name; // return name; //} public Models.DepartmentCoveringHeadRecord findCurrentDeputyHeadToEdit(int currentDeputyHeadId) { DateTime today = DateTime.Now.Date; var q = context.DepartmentCoveringHeadRecord.Where(x => x.UserId == currentDeputyHeadId && x.EndDate >= today).First(); DepartmentCoveringHeadRecord d2 = new DepartmentCoveringHeadRecord(); d2 = q; return(d2); }
public DepartmentCoveringHeadRecord GetCurrentDeputy(string dept) { Department department = b.getDepartmentDetails(dept); if (department.CoveringHeadId != null) { currentDeputyId = (int)department.CoveringHeadId; DepartmentCoveringHeadRecord d = b.findCurrentDeputyHeadToEdit(currentDeputyId); return(d); } else { return(null); } }