protected void ShowVac_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteVac") { int rowNumber = Convert.ToInt32(e.CommandArgument); int vacId = Convert.ToInt32(ShowVac.Rows[rowNumber].Cells[0].Text); VacationService vs = new VacationService(); vs.DeleteVacation(vacId); SortDDL_SelectedIndexChanged(sender, e); } }
public async Task <IActionResult> DeleteVacationConfirmed(int id) { await _vacationService.DeleteVacation(id); return(RedirectToAction(nameof(Index))); }
public static void VacationsForDoctor() { VacationService vs = new VacationService(); DoctorService docser = new DoctorService(); DataSet ds = docser.GetDoctors(), temp; DateTime start, end; string docId = ""; int vacId; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { docId = ds.Tables[0].Rows[i]["DoctorId"].ToString(); if (Convert.ToBoolean(ds.Tables[0].Rows[i]["DoctorIsOnVacation"].ToString())) { temp = vs.IsDoctorOnVacation(docId); if (temp.Tables[0].Rows.Count != 0) { //loop runs on all the doctors possible vacations for (int j = 0; j < temp.Tables[0].Rows.Count; j++) { start = Convert.ToDateTime(temp.Tables[0].Rows[j]["VacationStartDate"].ToString()); end = Convert.ToDateTime(temp.Tables[0].Rows[j]["VacationEndDate"].ToString()); if (DateTime.Now > end || DateTime.Now < start) { //update doctor docser.UpdateDoctorVacation(false, docId); //delete the vacation from database if (DateTime.Now > end) { vacId = Convert.ToInt32(temp.Tables[0].Rows[j]["VacationId"].ToString()); vs.DeleteVacation(vacId); } } else { docser.UpdateDoctorVacation(true, docId); break; } } } else { //update doctor docser.UpdateDoctorVacation(false, docId); } } else { //if the doctors have vacations but DoctorIsOnVacation=false temp = vs.IsDoctorOnVacation(docId); if (temp.Tables[0].Rows.Count != 0) { for (int j = 0; j < temp.Tables[0].Rows.Count; j++) { start = Convert.ToDateTime(temp.Tables[0].Rows[j]["VacationStartDate"].ToString()); end = Convert.ToDateTime(temp.Tables[0].Rows[j]["VacationEndDate"].ToString()); if (DateTime.Now <= end && DateTime.Now >= start) { //update DoctorIsOnVacation=True docser.UpdateDoctorVacation(true, docId); } else { //if the doctor have future vacation if (DateTime.Now > end) { vacId = Convert.ToInt32(temp.Tables[0].Rows[j]["VacationId"].ToString()); vs.DeleteVacation(vacId); } } } } } } }