public void DeleteScheldure(DeleteSchedule deleteSchedule) { using var scope = ServiceProvider.CreateScope(); var backupService = scope.ServiceProvider.GetService <BackupService>(); backupService.DeleteSchedule(deleteSchedule.TenantId); }
public ActionResult <DeleteScheduleResponse> Post(DeleteSchedule request) { //Remove mapping. if (request.AttributeIds != null && request.ScheduleIds != null) { for (int pos = 0; pos != request.AttributeIds.Length; ++pos) { GXDeleteArgs arg = GXDeleteArgs.Delete <GXScheduleToAttribute>(q => request.ScheduleIds[pos] == q.ScheduleId); arg.Where.And <GXScheduleToAttribute>(q => request.AttributeIds[pos] == q.AttributeId); host.Connection.Delete(arg); } host.SetChange(TargetType.Schedule, DateTime.Now); } else if (request.ScheduleIds != null) { GXSelectArgs arg = GXSelectArgs.Select <GXSchedule>(a => a.Id, q => request.ScheduleIds.Contains(q.Id)); List <GXSchedule> list = host.Connection.Select <GXSchedule>(arg); DateTime now = DateTime.Now; foreach (GXSchedule it in list) { it.Removed = now; host.Connection.Update(GXUpdateArgs.Update(it, q => q.Removed)); } host.SetChange(TargetType.Schedule, now); } return(new DeleteScheduleResponse()); }
protected void ASPxScheduler1_AppointmentsDeleted(object sender, DevExpress.XtraScheduler.PersistentObjectsEventArgs e) { Appointment apt = (Appointment)e.Objects[0]; //Delete Schedule DeleteSchedule objSchedule = new DeleteSchedule(); objSchedule.Index = 0; objSchedule.AppointmentID = Convert.ToInt32(apt.Id); switch (apt.Type) { case AppointmentType.ChangedOccurrence: break; case AppointmentType.DeletedOccurrence: case AppointmentType.Pattern: objSchedule.Index = apt.RecurrenceIndex; billSysDeleteBO.DeleteEventSchedular(objSchedule); break; case AppointmentType.Normal: billSysDeleteBO.DeleteEventSchedular(objSchedule); break; case AppointmentType.Occurrence: break; default: break; } }
public async Task <ActionResult> DeleteSchedule(Guid groupId, string teamName, int semester) { var command = new DeleteSchedule { GroupId = groupId, UserId = User.GetUserId(), TeamName = teamName, Semester = semester }; await _scheduleService.DeleteTeamSchedule(command); return(Ok()); }
public async Task DeleteTeamSchedule(DeleteSchedule command) { await _administratorService.ValidateAtLeastAdministrator(command.UserId, command.GroupId); var group = await _groupRepository.GetWithTeamScheduleAndCourses(command.GroupId, command.TeamName); if (group == null) { throw new AppException($"Team with name {command.TeamName} doesn't exist.", AppErrorCode.DOESNT_EXIST); } var team = group.Teams.First(t => t.Name == command.TeamName); team.DeleteSchedule(command.Semester); await _groupRepository.SaveChangesAsync(); }
public ContentResult DelSchedule(ScheduleModel schedule) { bool deleted = DeleteSchedule.Delete(schedule); if (deleted) { return(new ContentResult { StatusCode = (int)HttpStatusCode.OK }); } else { return(new ContentResult { StatusCode = (int)HttpStatusCode.InternalServerError }); } }
public void DeleteEventSchedular(DeleteSchedule objSchedule) { try { conn = new SqlConnection(strConn); conn.Open(); comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "PROC_DELETE_VISIT"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Parameters.AddWithValue("@Index ", objSchedule.Index); comm.Parameters.AddWithValue("@AppointMentID", objSchedule.AppointmentID); comm.ExecuteNonQuery(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } finally { conn.Close(); } }
protected void ASPxScheduler1_AppointmentsChanged(object sender, PersistentObjectsEventArgs e) { //Delete Schedule DevExpress.XtraScheduler.Internal.Implementations.AppointmentInstance AppointmentInstance = (DevExpress.XtraScheduler.Internal.Implementations.AppointmentInstance)e.Objects[0]; DeleteSchedule objSchedule = new DeleteSchedule(); objSchedule.Index = 0; if (AppointmentInstance.Type == AppointmentType.Normal) { objSchedule.AppointmentID = Convert.ToInt32(AppointmentInstance.Id); } else if (AppointmentInstance.Type == AppointmentType.Pattern) { objSchedule.AppointmentID = Convert.ToInt32(AppointmentInstance.RecurrencePattern.Id); } switch (AppointmentInstance.Type) { case AppointmentType.ChangedOccurrence: break; case AppointmentType.DeletedOccurrence: case AppointmentType.Pattern: objSchedule.Index = -1; billSysDeleteBO.DeleteEventSchedular(objSchedule); break; case AppointmentType.Normal: // billSysDeleteBO.DeleteEventSchedular(objSchedule); break; case AppointmentType.Occurrence: break; default: break; } if (AppointmentInstance.Type == AppointmentType.Pattern) { OccurrenceCalculator oc = OccurrenceCalculator.CreateInstance(AppointmentInstance.RecurrenceInfo); TimeInterval ttc = new TimeInterval(AppointmentInstance.RecurrenceInfo.Start, AppointmentInstance.RecurrenceInfo.End.Add(AppointmentInstance.Duration)); AppointmentBaseCollection appts = oc.CalcOccurrences(ttc, AppointmentInstance); foreach (Appointment item in appts) { int index = item.RecurrenceIndex; #region Data insert to TXN_CALENDAR try { ArrayList objAdd; Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender(); objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(AppointmentInstance.CustomFields[0].ToString())); objAdd.Add(item.Start); objAdd.Add(item.Start.Hour + "." + item.Start.Minute); objAdd.Add(AppointmentInstance.Description); objAdd.Add(AppointmentInstance.CustomFields[2]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(item.End.Minute); int endHr = Convert.ToInt32(item.End.Hour); string endTime = item.End.Hour + "." + item.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(item.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(AppointmentInstance.StatusKey); objAdd.Add(item.CustomFields["VISIT_TYPE_ID"]); objAdd.Add(AppointmentInstance.Id); objAdd.Add(index); _bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); index++; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion } return; } else if (AppointmentInstance.Type == AppointmentType.Normal) { string[] clientData = AppointmentInstance.Location.Split(new char[] { '-' }); Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender(); int index = 0; if (clientData[2].Trim() != "null") { if (_bill_Sys_Calender.CHECKVISIT_FOR_APPOINTMENT(Convert.ToInt32(AppointmentInstance.Id), index, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID)) { #region Data Update to TXN_CALENDAR try { ArrayList objAdd; objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2])); objAdd.Add(AppointmentInstance.Start); objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute); objAdd.Add(AppointmentInstance.Description); objAdd.Add(clientData[1]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(AppointmentInstance.End.Minute); int endHr = Convert.ToInt32(AppointmentInstance.End.Hour); string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(AppointmentInstance.StatusKey); objAdd.Add(clientData[0]); objAdd.Add(AppointmentInstance.Id); objAdd.Add(index); objAdd.Add(AppointmentInstance.Id); _bill_Sys_Calender.UPDATEEventByAppointmentId(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); index++; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion } else { #region Data insert to TXN_CALENDAR try { ArrayList objAdd; objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2])); objAdd.Add(AppointmentInstance.Start); objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute); objAdd.Add(AppointmentInstance.Description); objAdd.Add(clientData[1]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(AppointmentInstance.End.Minute); int endHr = Convert.ToInt32(AppointmentInstance.End.Hour); string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(0); objAdd.Add(clientData[0]); objAdd.Add(AppointmentInstance.Id); objAdd.Add(index); _bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion } } } else if (AppointmentInstance.Type == AppointmentType.DeletedOccurrence) { //Deleted code in TXN_CALENDER_EVENTS //DeleteSchedule objSchedule = new DeleteSchedule(); //objSchedule.Index = apt.RecurrenceIndex; //objSchedule.AppointmentID = Convert.ToInt32(apt.RecurrencePattern.Id); //billSysDeleteBO.DeleteEventSchedular(objSchedule); //return; } else if (AppointmentInstance.Type == AppointmentType.ChangedOccurrence) { string[] clientData = AppointmentInstance.Location.Split(new char[] { '-' }); int index = AppointmentInstance.RecurrenceIndex; #region Data Update to TXN_CALENDAR try { ArrayList objAdd; Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender(); objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2])); objAdd.Add(AppointmentInstance.Start); objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute); objAdd.Add(AppointmentInstance.Description); objAdd.Add(clientData[1]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(AppointmentInstance.End.Minute); int endHr = Convert.ToInt32(AppointmentInstance.End.Hour); string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (AppointmentInstance.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(AppointmentInstance.StatusKey); objAdd.Add(clientData[0]); objAdd.Add(AppointmentInstance.RecurrencePattern.Id); objAdd.Add(index); objAdd.Add(AppointmentInstance.Id); _bill_Sys_Calender.UPDATEEventByAppointmentId(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); index++; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion } }
protected void ASPxScheduler1_AppointmentsInserted(object sender, DevExpress.XtraScheduler.PersistentObjectsEventArgs e) { //Task.Factory.StartNew(() => //{ Appointment apt = (Appointment)e.Objects[0]; string[] clientData = apt.Location.Split(new char[] { '-' }); if (clientData[2].Trim() != "null") { if (apt.Type == AppointmentType.Pattern) { OccurrenceCalculator oc = OccurrenceCalculator.CreateInstance(apt.RecurrenceInfo); TimeInterval ttc = new TimeInterval(apt.RecurrenceInfo.Start, apt.RecurrenceInfo.End.Add(apt.Duration)); AppointmentBaseCollection appts = oc.CalcOccurrences(ttc, apt); foreach (Appointment item in appts) { int index = item.RecurrenceIndex; #region Data insert to TXN_CALENDAR try { ArrayList objAdd; Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender(); objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2])); objAdd.Add(item.Start); objAdd.Add(item.Start.Hour + "." + item.Start.Minute); objAdd.Add(apt.Description); objAdd.Add(clientData[1]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(apt.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(item.End.Minute); int endHr = Convert.ToInt32(item.End.Hour); string endTime = item.End.Hour + "." + item.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (apt.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (apt.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(item.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(apt.StatusId); objAdd.Add(clientData[0]); objAdd.Add(apt.Id); objAdd.Add(index); _bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); index++; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion } return; } else if (apt.Type == AppointmentType.Normal) { #region Data insert to TXN_CALENDAR try { ArrayList objAdd; Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender(); objAdd = new ArrayList(); objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2])); objAdd.Add(apt.Start); objAdd.Add(apt.Start.Hour + "." + apt.Start.Minute); objAdd.Add(apt.Description); objAdd.Add(clientData[1]); objAdd.Add("TY000000000000000003"); objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); objAdd.Add(apt.Start.ToString("tt", CultureInfo.InvariantCulture)); int endMin = Convert.ToInt32(apt.End.Minute); int endHr = Convert.ToInt32(apt.End.Hour); string endTime = apt.End.Hour + "." + apt.End.Minute; if (endMin >= 60) { endMin = endMin - 60; endHr = endHr + 1; if (endHr > 12) { endHr = endHr - 12; if (apt.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } else if (endHr == 12) { if (apt.End.Hour != 12) { if (endTime == "AM") { endTime = "PM"; } else if (endTime == "PM") { endTime = "AM"; } } } } objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString()); objAdd.Add(apt.End.ToString("tt", CultureInfo.InvariantCulture)); objAdd.Add(0); objAdd.Add(clientData[0]); objAdd.Add(apt.Id); objAdd.Add(0); _bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString()); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } #endregion return; } else if (apt.Type == AppointmentType.DeletedOccurrence) { //Deleted code in TXN_CALENDER_EVENTS DeleteSchedule objSchedule = new DeleteSchedule(); objSchedule.Index = apt.RecurrenceIndex; objSchedule.AppointmentID = Convert.ToInt32(apt.RecurrencePattern.Id); billSysDeleteBO.DeleteEventSchedular(objSchedule); return; } else if (apt.Type == AppointmentType.ChangedOccurrence) { return; } } }