public long CreateRequestDay(long requestId, DateTime ptoDayDate, long requestTypeID) { long returnValue; try { using (var context = new PTOMEntities()) { returnValue = GetSequenceNextValue(context, "PTOMS.PTO_DAY_ID_SQ"); var d = new PTO_DAY { PTO_DAY_DATE = ptoDayDate, PTO_DAY_ID = returnValue, PTO_REQUEST_ID = requestId, REQUEST_TYPE_ID = requestTypeID }; context.PTO_DAY.AddObject(d); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } return(returnValue); }
public void UpdateEmployee(long employeeId, bool isAdmin, string displayName, string email, DateTime hireDate, DateTime anniversaryDate, long approverId) { try { using (var context = new PTOMEntities()) { var item = context.EMPLOYEE.FirstOrDefault(emp => emp.EMPLOYEE_ID == employeeId); if (item != null) { item.DISPLAY_NAME = displayName; item.IS_ADMIN = isAdmin ? "Y" : "N"; item.EMAIL = email; item.HIRE_DATE = hireDate; item.ANNIVERSARY_DATE = anniversaryDate; item.APPROVER_EMPLOYEE_ID = approverId; context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public long CreateRequest(long userId, long approverEmployeeId, string comment, long ptoCycleID) { long returnValue; try { using (var context = new PTOMEntities()) { returnValue = GetSequenceNextValue(context, "PTOMS.PTO_REQUEST_ID_SQ"); var r = new PTO_REQUEST { APPROVER_EMPLOYEE_ID = approverEmployeeId, EMPLOYEE_ID = userId, PTO_COMMENT = comment, PTO_REQUEST_ID = returnValue, REQUEST_DATE = DateTime.Now, PTO_CYCLE_ID = ptoCycleID, STATUS = RequestStatus.Pending.ToString() }; context.PTO_REQUEST.AddObject(r); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } return(returnValue); }
public long CreateRollover(long employeeId, decimal?hours) { long returnvalue; try { using (var context = new PTOMEntities()) { returnvalue = GetSequenceNextValue(context, "PTOMS.ROLLOVER_ID_SQ"); var r = new ROLLOVER { ROLLOVER_ID = returnvalue, EMPLOYEE_ID = employeeId, HOURS = hours, PTO_CYCLE_ID = CurrentCycle.PTOCycleID.Value }; context.ROLLOVER.AddObject(r); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } return(returnvalue); }
public long CreateEmployee(string userName, string displayName, bool isAdmin, string email, DateTime hireDate, DateTime anniversaryDate, long approverId) { long returnValue; try { using (var context = new PTOMEntities()) { returnValue = GetSequenceNextValue(context, "PTOMS.EMPLOYEE_ID_SQ"); var employee = new EMPLOYEE { EMPLOYEE_ID = returnValue, USERNAME = userName.ToLower(), DISPLAY_NAME = displayName, IS_ADMIN = isAdmin ? "Y" : "N", EMAIL = email, HIRE_DATE = hireDate, ANNIVERSARY_DATE = anniversaryDate, APPROVER_EMPLOYEE_ID = approverId }; context.EMPLOYEE.AddObject(employee); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } return(returnValue); }
public long?CreateHoliday(DateTime date, string name, long ptoCycle) { long returnValue; try { using (var context = new PTOMEntities()) { returnValue = GetSequenceNextValue(context, "PTOMS.HOLIDAY_ID_SQ"); var holiday = new HOLIDAY { HOLIDAY_ID = returnValue, NAME = name, HOLIDAY_DATE = date, PTO_CYCLE = ptoCycle }; context.HOLIDAY.AddObject(holiday); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } return(returnValue); }
public void DeleteRequest(long requestId) { try { using (var context = new PTOMEntities()) { var REQ = context.PTO_REQUEST.FirstOrDefault(x => x.PTO_REQUEST_ID == requestId); if (REQ != null) { context.DeleteObject(REQ); context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void DeleteEmployee(long employeeId) { try { using (var context = new PTOMEntities()) { var EMPLOYEE = context.EMPLOYEE.FirstOrDefault(emp => emp.EMPLOYEE_ID == employeeId); if (EMPLOYEE != null) { context.DeleteObject(EMPLOYEE); context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void UpdateRollover(long employeeId, decimal?hours) { try { using (var context = new PTOMEntities()) { var r = context.ROLLOVER.FirstOrDefault(x => x.EMPLOYEE_ID == employeeId); if (r != null) { r.HOURS = hours; r.PTO_CYCLE_ID = CurrentCycle.PTOCycleID.Value; context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
private void UpdateApprover(long employeeId, bool Approver) { try { using (var context = new PTOMEntities()) { var employee = context.EMPLOYEE.FirstOrDefault(h => h.EMPLOYEE_ID == employeeId); if (employee != null) { employee.IS_APPROVER = Approver ? "Y":"N"; context.SaveChanges(); } ; } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void EditRequestDay(long requestId, DateTime ptoDayDate, long requestTypeID, long ptoDayID) { try { using (var context = new PTOMEntities()) { var d = context.PTO_DAY.FirstOrDefault(day => day.PTO_DAY_ID == ptoDayID); if (d != null) { d.PTO_DAY_DATE = ptoDayDate; d.PTO_REQUEST_ID = requestId; d.REQUEST_TYPE_ID = requestTypeID; context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void UpdateEmployeeTeams(long employeeId, long teamId) { try { using (var context = new PTOMEntities()) { var item = context.EMPLOYEE_TEAM.FirstOrDefault(x => x.EMPLOYEE_ID == employeeId); if (item != null) { item.EMPLOYEE_ID = employeeId; item.TEAM_ID = teamId; context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void AssignEmployeeToTeam(long employeeId, long teamId) { try { using (var context = new PTOMEntities()) { var t = new EMPLOYEE_TEAM { EMPLOYEE_ID = employeeId, TEAM_ID = teamId, EMPLOYEE_TEAM_ID = GetSequenceNextValue(context, "PTOMS.EMPLOYEE_TEAM_ID_SQ") }; context.EMPLOYEE_TEAM.AddObject(t); context.SaveChanges(); } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void UpdateRequest(long requestID, long approverId, string comment, RequestStatus status, string requestChangeComment, DateTime?requestChangeDate) { try { using (var context = new PTOMEntities()) { var r = context.PTO_REQUEST.FirstOrDefault(REQ => REQ.PTO_REQUEST_ID == requestID); if (r != null) { r.APPROVER_EMPLOYEE_ID = approverId; r.PTO_COMMENT = comment; r.STATUS = status.ToString(); r.STATUS_CHANGE_COMMENT = requestChangeComment; r.STATUS_CHANGE_DATE = requestChangeDate; context.SaveChanges(); } } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }
public void UpdateHoliday(long holidayID, DateTime date, string name, long ptoCycle) { try { using (var context = new PTOMEntities()) { var holiday = context.HOLIDAY.FirstOrDefault(h => h.HOLIDAY_ID == holidayID); if (holiday != null) { holiday.HOLIDAY_DATE = date; holiday.NAME = name; holiday.PTO_CYCLE = ptoCycle; context.SaveChanges(); } ; } } catch (Exception ex) { LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex); throw; } }