/// <summary>
/// Creator: Kaleb Bachert
/// Created: 3/17/2020
/// Approver: Lane Sandburg
///
/// Method that inserts a new availability request
/// </summary>
/// <remarks>
/// Updater: NA
/// Updated: NA
/// Update: NA
/// </remarks>
public int InsertAvailabilityRequest(AvailabilityRequestVM request, int requestingUserID)
{
int oldCount = availabilityRequestVMs.Count;
availabilityRequestVMs.Add(request);
return(availabilityRequestVMs.Count - oldCount);
}
/// <summary>
/// CREATOR: Kaleb Bachert
/// CREATED: 2020/3/17
/// APPROVER: Lane Sandburg
///
/// This method calls the InsertTimeOffRequest method from the Accessor
/// </summary>
/// <remarks>
/// UPDATER: NA
/// UPDATED: NA
/// UPDATE: NA
///
/// </remarks>
/// <param name="requestID"></param>
/// <param name="userID"></param>
public bool AddAvailabilityRequest(AvailabilityRequestVM request, int requestingEmployeeID)
{
try
{
return(1 == _requestAccessor.InsertAvailabilityRequest(request, requestingEmployeeID));
}
catch (Exception ex)
{
throw new ApplicationException("Data not added.", ex);
}
}
/// CREATOR: Chase Schulte
/// CREATED: 2020/04/21
/// APPROVER: Kaleb Bachert
///
/// This method retrieves a availabilityRequestByID
/// </summary>
/// <remarks>
/// UPDATER:
/// UPDATED:
/// UPDATE:
/// </remarks>
/// <param name="requestID"></param>
/// <returns></returns>
public AvailabilityRequestVM SelectAvailabilityRequestByID(int requestID)
{
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_availbility_request_by_request_id", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("RequestID", requestID);
AvailabilityRequestVM availabilityRequest = new AvailabilityRequestVM();
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
availabilityRequest.AvailabilityRequestID = reader.GetInt32(0);
availabilityRequest.SundayStartTime = reader.IsDBNull(1) ? "" : reader.GetString(1);
availabilityRequest.SundayEndTime = reader.IsDBNull(2) ? "" : reader.GetString(2);
availabilityRequest.MondayStartTime = reader.IsDBNull(3) ? "" : reader.GetString(3);
availabilityRequest.MondayEndTime = reader.IsDBNull(4) ? "" : reader.GetString(4);
availabilityRequest.TuesdayStartTime = reader.IsDBNull(5) ? "" : reader.GetString(5);
availabilityRequest.TuesdayEndTime = reader.IsDBNull(6) ? "" : reader.GetString(6);
availabilityRequest.WednesdayStartTime = reader.IsDBNull(7) ? "" : reader.GetString(7);
availabilityRequest.WednesdayEndTime = reader.IsDBNull(8) ? "" : reader.GetString(8);
availabilityRequest.ThursdayStartTime = reader.IsDBNull(9) ? "" : reader.GetString(9);
availabilityRequest.ThursdayEndTime = reader.IsDBNull(10) ? "" : reader.GetString(10);
availabilityRequest.FridayStartTime = reader.IsDBNull(11) ? "" : reader.GetString(11);
availabilityRequest.FridayEndTime = reader.IsDBNull(12) ? "" : reader.GetString(12);
availabilityRequest.SaturdayStartTime = reader.IsDBNull(13) ? "" : reader.GetString(13);
availabilityRequest.SaturdayEndTime = reader.IsDBNull(14) ? "" : reader.GetString(14);
availabilityRequest.RequestID = reader.GetInt32(15);
availabilityRequest.RequestingUserID = reader.GetInt32(16);
availabilityRequest.FirstName = reader.GetString(17);
availabilityRequest.LastName = reader.GetString(18);
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(availabilityRequest);
}
/// <summary>
/// CREATOR: Kaleb Bachert
/// CREATED: 2020/3/18
/// APPROVER: Lane Sandburg
///
/// This method adds a new Availability Request
/// </summary>
/// <remarks>
/// UPDATER: NA
/// UPDATED: NA
/// UPDATE: NA
///
/// </remarks>
/// <param name="requestID"></param>
/// <param name="userID"></param>
public int InsertAvailabilityRequest(AvailabilityRequestVM request, int requestingUserID)
{
int rows = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_insert_availability_request", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SundayStart", request.SundayStartTime);
cmd.Parameters.AddWithValue("@SundayEnd", request.SundayEndTime);
cmd.Parameters.AddWithValue("@MondayStart", request.MondayStartTime);
cmd.Parameters.AddWithValue("@MondayEnd", request.MondayEndTime);
cmd.Parameters.AddWithValue("@TuesdayStart", request.TuesdayStartTime);
cmd.Parameters.AddWithValue("@TuesdayEnd", request.TuesdayEndTime);
cmd.Parameters.AddWithValue("@WednesdayStart", request.WednesdayStartTime);
cmd.Parameters.AddWithValue("@WednesdayEnd", request.WednesdayEndTime);
cmd.Parameters.AddWithValue("@ThursdayStart", request.ThursdayStartTime);
cmd.Parameters.AddWithValue("@ThursdayEnd", request.ThursdayEndTime);
cmd.Parameters.AddWithValue("@FridayStart", request.FridayStartTime);
cmd.Parameters.AddWithValue("@FridayEnd", request.FridayEndTime);
cmd.Parameters.AddWithValue("@SaturdayStart", request.SaturdayStartTime);
cmd.Parameters.AddWithValue("@SaturdayEnd", request.SaturdayEndTime);
cmd.Parameters.AddWithValue("@RequestingUserID", requestingUserID);
try
{
conn.Open();
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(rows);
}
