public void TestRetrieveScheduleChangeRequestByRequestID() { // arrange ScheduleChangeRequestVM request = null; IRequestManager requestManager = new RequestManager(_requestAccessor); // act request = requestManager.RetrieveScheduleChangeRequestByRequestID(1000004); // assert Assert.IsNotNull(request); }
/// <summary> /// CREATOR: Kaleb Bachert /// CREATED: 2020/4/9 /// APPROVER: Lane Sandburg /// /// This method gets a ScheduleChangeRequest by RequestID /// </summary> /// <remarks> /// UPDATER: NA /// UPDATED: NA /// UPDATE: NA /// /// </remarks> /// <param name="requestID"></param> /// <param name="userID"></param> public ScheduleChangeRequestVM SelectScheduleChangeRequestByRequestID(int requestID) { ScheduleChangeRequestVM request = null; var conn = DBConnection.GetConnection(); var cmd = new SqlCommand("sp_select_schedule_change_request_by_requestid", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("RequestID", requestID); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); { request = new ScheduleChangeRequestVM(); request.ScheduleChangeRequestID = reader.GetInt32(0); request.ShiftID = reader.GetInt32(1); request.ApprovalDate = reader.IsDBNull(2) ? "" : reader.GetDateTime(2).ToString(); request.ApprovingUserID = reader.IsDBNull(3) ? 0 : reader.GetInt32(3); request.RequestID = reader.GetInt32(4); request.EmployeeWorking = reader.GetInt32(5); request.Date = reader.GetDateTime(6).ToShortDateString(); request.DepartmentID = reader.GetString(7); request.StartTime = reader.GetString(8); request.EndTime = reader.GetString(9); request.Role = reader.GetString(10); } reader.Close(); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(request); }