public EmployeeVacationRequestViewItem(VacationRequest vacationRequest, String shiftPartnerFullName) { _vacationRequestID = vacationRequest.getVacationRequestID(); _vacationStartDate = vacationRequest.getVacationStartDate(); _vacationEndDate = vacationRequest.getVacationEndDate(); _requesterID = vacationRequest.getEmployeeID(); _netVacationDays = vacationRequest.getNetVacationDays(); _vacationRequestProcessingState = vacationRequest.getVacationRequestProcessingState(); _shiftPartnerFullName = shiftPartnerFullName; }
public VacationReplacementRequestViewItem(VacationRequest vacationRequest, String requesterFullName) { this._vacationRequestID = vacationRequest.getVacationRequestID(); this._requesterID = vacationRequest.getEmployeeID(); this._vacationStartDate = vacationRequest.getVacationStartDate(); this._vacationEndDate = vacationRequest.getVacationEndDate(); this._netVacationDays = vacationRequest.getNetVacationDays(); this._requesterFullName = requesterFullName; this._vacationRequestProcessingState = vacationRequest.getVacationRequestProcessingState(); }
public AllVacationRequestViewItem(VacationRequest vacationRequest, String requesterFullName) { _vacationRequestID = vacationRequest.getVacationRequestID(); _vacationStartDate = vacationRequest.getVacationStartDate(); _vacationEndDate = vacationRequest.getVacationEndDate(); _requesterID = vacationRequest.getEmployeeID(); _netVacationDays = vacationRequest.getNetVacationDays(); _vacationRequestProcessingState = vacationRequest.getVacationRequestProcessingState(); _requesterFullName = requesterFullName; _modificationDate = vacationRequest.getModificationDate(); }
public PendingVacationRequestViewItem(VacationRequest vacationRequest, String requesterName, String deputyName, int remainingVacationDays) { this._vacationRequestID = vacationRequest.getVacationRequestID(); this._requesterID = vacationRequest.getEmployeeID(); this._vacationStartDate = vacationRequest.getVacationStartDate(); this._vacationEndDate = vacationRequest.getVacationEndDate(); this._netVacationDays = vacationRequest.getNetVacationDays(); this._vacationRequestProcessingState = vacationRequest.getVacationRequestProcessingState(); this._requesterFullName = requesterName; this._deputyFullName = deputyName; this._vacationPeriodOverlapNote = vacationRequest.getVacationPeriodOverlapNote(); this._vacationLockPeriodNote = vacationRequest.getVacationLockPeriodNote(); this._remainingVacationDays = remainingVacationDays; }
/// <summary> /// constructor to create a vacation request /// </summary> public VacationRequest(String EmployeeID, DateTime VacationStartDate, DateTime VacationEndDate) { this._employeeID = EmployeeID; this._vacationStartDate = VacationStartDate; this._vacationEndDate = VacationEndDate; //init with default values: this._vacationRequestID = 0; this._submissionDate = DateTime.Today; this._vacationType = DEFAULT_VACATION_TYPE; this._vacationRequestProcessingState = VacationRequestProcessingState.submitted; this._modificationDate = DateTime.Now; this._vacationPeriodOverlapNote = false; ; this._vacationLockPeriodNote = false; this._netVacationDays = 0; }
public static String ConvertStateToString(VacationRequestProcessingState ProcessingState) { String result = "unbekannt"; switch (ProcessingState) { case VacationRequestProcessingState.agreed: result = AGREED; break; case VacationRequestProcessingState.approved: result = APPROVED; break; case VacationRequestProcessingState.canceled: result = CANCELED; break; case VacationRequestProcessingState.permitted: result = PERMITTED; break; case VacationRequestProcessingState.rejectedByDeputy: result = REJECTED_BY_DEPUTY; break; case VacationRequestProcessingState.rejectedByDivisionManager: result = REJECTED_BY_DIVISION_MANAGER; break; case VacationRequestProcessingState.submitted: result = SUBMITTED; break; case VacationRequestProcessingState.taken: result = TAKEN; break; default: result = UNKNOWN; break; } return result; }
/// <summary> /// general constructor /// </summary> public VacationRequest(ulong VacationRequestID, String EmployeeID, DateTime VacationStartDate, DateTime VacationEndDate, DateTime SubmissionDate, String VacationType, VacationRequestProcessingState VacationRequestProcessingState, DateTime ModificationDate, Boolean VacationPeriodOverlapNote, Boolean VacationLockPeriodNote, int NetVacationDays) { this._vacationRequestID = VacationRequestID; this._employeeID = EmployeeID; this._vacationStartDate = VacationStartDate; this._vacationEndDate = VacationEndDate; this._submissionDate = SubmissionDate; this._vacationType = VacationType; this._vacationRequestProcessingState = VacationRequestProcessingState; this._modificationDate = ModificationDate; this._vacationPeriodOverlapNote = VacationPeriodOverlapNote; this._vacationLockPeriodNote = VacationLockPeriodNote; this._netVacationDays = NetVacationDays; }
public void setVacationRequestProcessingState(VacationRequestProcessingState VacationRequestProcessingState) { this._vacationRequestProcessingState = VacationRequestProcessingState; }
// geändert /// <summary> /// updates the State of the VacationRequest with the given VacationRequestID /// </summary> /// <param name="VacationRequestID">ID of the VacationRequest in which the state will be changed</param> /// <param name="State">the to-be VacationProcessingState</param> /// <param name="modificationDate">Dateime of modification</param> /// <returns>true or false (update successfull or not)</returns> public Boolean UpdateVacationRequestStatus(ulong VacationRequestID, VacationRequestProcessingState State, DateTime modificationDate ) { bool Result = false; using (SqlConnection connection = new SqlConnection(sqlConnectionString)) { string sqlStatement = //insert ID like that because of DataType conflicts "UPDATE dbo.VacationRequest SET VacationProcessingState = @VacationProcessingState, ModificationDate = @modificationDate WHERE VacationRequestID = @VacationRequestID"; using (SqlCommand cmd = new SqlCommand(sqlStatement, connection)) { cmd.Parameters.AddWithValue("VacationRequestID", (long) VacationRequestID); cmd.Parameters.AddWithValue("VacationProcessingState", ConvertVacationRequestProcessingStateToString(State)); cmd.Parameters.AddWithValue("modificationDate", modificationDate); try { connection.Open(); cmd.ExecuteNonQuery(); //insert,delete,update is NonQuery Result = true; } catch (SqlException e) //if failure in Database result = false { { Result = false; } } } } return Result; }