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