/// <summary>
/// CREATOR: Kaleb Bachert
/// CREATED: 2020/4/7
/// APPROVER: Lane Sandburg
///
/// This method adds a new Schedule Change Request
/// </summary>
/// <remarks>
/// UPDATER: NA
/// UPDATED: NA
/// UPDATE: NA
///
/// </remarks>
/// <param name="request"></param>
/// <param name="requestingUserID"></param>
public int InsertScheduleChangeRequest(ScheduleChangeRequest request, int requestingUserID)
{
int rows = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_insert_schedule_change_request", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ShiftID", request.ShiftID);
cmd.Parameters.AddWithValue("@RequestingUserID", requestingUserID);
try
{
conn.Open();
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(rows);
}
/// <summary>
/// CREATOR: Kaleb Bachert
/// CREATED: 2020/4/7
/// APPROVER: Lane Sandburg
///
/// Method that inserts a new Schedule Change Request
/// </summary>
/// <remarks>
/// UPDATER: NA
/// UPDATED: NA
/// UPDATE: NA
///
/// </remarks>
public int InsertScheduleChangeRequest(ScheduleChangeRequest request, int requestingUserID)
{
int oldCount = scheduleChangeRequests.Count;
scheduleChangeRequests.Add(request);
return(scheduleChangeRequests.Count - oldCount);
}
/// <summary>
/// CREATOR: Kaleb Bachert
/// CREATED: 2020/4/7
/// APPROVER: Lane Sandburg
///
/// This method calls the InsertScheduleChangeRequest method from the Accessor
/// </summary>
/// <remarks>
/// UPDATER: NA
/// UPDATED: NA
/// UPDATE: NA
///
/// </remarks>
/// <param name="request"></param>
/// <param name="requestingUserID"></param>
public bool AddScheduleChangeRequest(ScheduleChangeRequest request, int requestingUserID)
{
try
{
return(1 == _requestAccessor.InsertScheduleChangeRequest(request, requestingUserID));
}
catch (Exception ex)
{
throw new ApplicationException("Data not added.", ex);
}
}
public ActionResult CreateRequest(int shiftID, string shiftDate)
{
try
{
ScheduleChangeRequest request = new ScheduleChangeRequest();
request.ShiftID = shiftID;
_requestManager.AddScheduleChangeRequest(request, Convert.ToInt32(Session["currentUserID"]));
return(Json(Url.Action("Index", "ChooseRequestType", new { outputMessage = "SUCCESS: Schedule Change Request Submitted!" })));
}
catch (Exception ex) //Null selection, return to selection page with same date
{
return(Json(Url.Action("Create", "RequestScheduleChange", new { userID = Session["currentUserID"], selectedDate = shiftDate })));
}
}
