//set Delegate by DepartmentCode , fromDate , toDate and empId public static bool setDelegate(string deptCode, DateTime fromDate, DateTime toDate, int empId) { //DepartmentVM deptVM = new DepartmentVM(); using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First(); department.DeptCode = deptCode; department.DelegateFromDate = fromDate; department.DelegateToDate = toDate; department.DelegateApproverId = empId; int rowinserted = entities.SaveChanges(); if (rowinserted > 0) { string startDate = (department.DelegateFromDate ?? default(DateTime)).ToString("dd MMMM yyyy"); string endDate = (department.DelegateToDate ?? default(DateTime)).ToString("dd MMMM yyyy"); EmailBL.AddNewEmailToEmp(empId, "Assign Delegate", "You have been assigned as delegate from " + startDate + " to " + endDate); return(true); } else { return(false); } } }
//set Rep by DepartmentCode , fromEmpId and toEmpId public static void setRep(string deptCode, int empId) { using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>(); { department.DeptRepId = empId; entities.SaveChanges(); EmailBL.AddNewEmailToEmp(empId, "Assign Reprsentative", "You have been assigned as reprsentative for your department."); } } return; }
//set Delegate by DepartmentCode , fromDate , toDate and empId public static void setDelegate(string deptCode, DateTime fromDate, DateTime toDate, int empId) { using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First(); department.DeptCode = deptCode; department.DelegateFromDate = fromDate; department.DelegateToDate = toDate; department.DelegateApproverId = empId; entities.SaveChanges(); string startDate = (department.DelegateFromDate ?? default(DateTime)).ToString("dd MMMM yyyy"); string endDate = (department.DelegateToDate ?? default(DateTime)).ToString("dd MMMM yyyy"); EmailBL.AddNewEmailToEmp(empId, "Assign Delegate", "You have been assigned as delegate from " + startDate + " to " + endDate); } }
//set Rep by DepartmentCode , fromEmpId and toEmpId public static bool setRep(string deptCode, int empId) { using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>(); { department.DeptRepId = empId; int rowinserted = entities.SaveChanges(); if (rowinserted > 0) { EmailBL.AddNewEmailToEmp(empId, "Assign Representative", "You have been assigned as representative for your department."); return(true); } else { return(false); } } } }