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);
}
