public string AcceptRejectDL(int id, string Option, string reason) { Request RequestObj = new Request(); try { using (TrainingManagementEntities1 entityObject = new TrainingManagementEntities1()) { if (Option == "Accept") { RequestObj = entityObject.Requests.Where(a => a.RequestID == id).Single(); RequestObj.Status = "Accepted"; RequestObj.Reason = reason; entityObject.SaveChanges(); } if (Option == "Reject") { RequestObj = entityObject.Requests.Where(a => a.RequestID == id).Single(); RequestObj.Status = "Rejected"; RequestObj.Reason = reason; entityObject.SaveChanges(); } } } catch (Exception e) { throw e; } return("Done"); }
public void ChangePasswordEmployee(int id, string pass) { try { Employee employeeobj = (from data in entityObject.Employees where data.EID == id select data).Single(); employeeobj.Pwd = pass; entityObject.SaveChanges(); } catch (Exception e) { throw e; } }
public string ChangePasswordDL(int ID, string OldPass, string NewPass) { string result = ""; try { managerObject = entityObj.Managers.Where(a => a.MID == ID && a.Pwd == OldPass).Single(); managerObject.Pwd = NewPass; entityObj.SaveChanges(); result = "changed"; } catch (Exception e) { throw e; } return(result); }
public int AddManager(string UserName, string Password, string Designition) { try { loginObject.UserName = UserName; loginObject.Pwd = Password; loginObject.Designation = Designition; managerObject.UserName = UserName; managerObject.Designation = Designition; contextObject.Logins.Add(loginObject); contextObject.Managers.Add(managerObject); contextObject.SaveChanges(); return(1); } catch (Exception e) { throw e; } }
public void UpdateDatabase(int EmpID) { DateTime todayDate = System.DateTime.Now; try { List <Request> requestList = (from data in entityObject.Requests where data.EmployeeID == EmpID && (data.Status != "Requested" || data.Status != "Rejected" || data.Status != "Cancelled") select data).ToList(); foreach (Request data in requestList) { if (todayDate >= data.StartDate && todayDate < data.EndDate && data.Status != "Requested" && data.Status != "Rejected" && data.Status != "Cancelled") { data.Status = "On Going"; } else if (todayDate >= data.EndDate && data.Status != "Requested" && data.Status != "Rejected" && data.Status != "Cancelled") { data.Status = "Completed"; } else if (todayDate < data.StartDate && data.Status != "Requested" && data.Status != "Rejected" && data.Status != "Cancelled") { data.Status = "Accepted"; } else { } } entityObject.SaveChanges(); } catch (Exception e) { throw e; } }