public bool Approve(ShiftRequest sr)
{
string changeAllShifts;
if (sr.HasWorked())
{
changeAllShifts = DeleteFromTableAllShifts(sr);
}
else
{
changeAllShifts = AddInTableAllShifts(sr);
}
if (changeAllShifts == "yes")
{
string deleteRequest = DeleteShiftRequest(sr);
if (deleteRequest == "deleted")
{
return(true);
}
}
return(false);
}
private void RejectRequest(ShiftRequest rejectedRequest)
{
if (rejectedRequest != null)
{
//DialogResult dialogResult = CustomMessageBoxController.ShowMessage("Are you sure you want to reject this request?", MessageBoxButtons.YesNo);
if ((CustomMessageBoxController.ShowMessage("Are you sure you want to reject this request?", MessageBoxButtons.YesNo)) == DialogResult.Yes)
{
bool isRejected = rc.Reject(rejectedRequest);
if (isRejected)
{
LoadRequests();
CustomMessageBoxController.ShowMessage("Request is rejected!", MessageBoxButtons.OK);
}
else
{
CustomMessageBoxController.ShowMessage("Could not reject request!", MessageBoxButtons.OK);
}
}
}
else
{
CustomMessageBoxController.ShowMessage("There is no request to reject!", MessageBoxButtons.OK);
}
}
private string DeleteShiftRequest(ShiftRequest sr)
{
try
{
//SQL command to delete a user with particular ID from the database
string sql = "DELETE FROM shift_requests where id = @id;";
MySqlCommand cmd = new MySqlCommand(sql, base.connection);
cmd.Parameters.AddWithValue("@id", sr.RequestID);
base.connection.Open();
int deletions = cmd.ExecuteNonQuery(); //change the database
if (deletions == 1)
{
return("deleted");
}
else
{
return("unsuccessful");
}
}
catch (MySqlException ex)
{
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
finally
{
if (connection != null)
{
base.connection.Close();
}
}
}