///<summary>Gets up to 30 days of open time slots based on the RecallType passed in.
///Open time slots are found by looping through operatories flagged for Web Sched and finding openings that can hold the RecallType.
///The RecallType passed in must be a valid recall type.
///Providers passed in will be the only providers considered when looking for available time slots.
///Passing in a null clinic will only consider operatories with clinics set to 0 (unassigned).
///The timeslots on and between the Start and End dates passed in will be considered and potentially returned as available.
///Optionally pass in a recall object in order to consider all other recalls due for the patient. This will potentially affect the time pattern.
///Throws exceptions.</summary>
public static List <TimeSlot> GetAvailableWebSchedTimeSlots(RecallType recallType, List <Provider> listProviders, Clinic clinic
, DateTime dateStart, DateTime dateEnd, Recall recallCur = null)
{
//No need to check RemotingRole; no call to db.
if (recallType == null) //Validate that recallType is not null.
{
throw new ODException(Lans.g("WebSched", "The recall appointment you are trying to schedule is no longer available.") + "\r\n"
+ Lans.g("WebSched", "Please call us to schedule your appointment."));
}
//Get all the Operatories that are flagged for Web Sched.
List <Operatory> listOperatories = Operatories.GetOpsForWebSched();
if (listOperatories.Count < 1) //This is very possible for offices that aren't set up the way that we expect them to be.
{
throw new ODException(Lans.g("WebSched", "There are no operatories set up for Web Sched.") + "\r\n"
+ Lans.g("WebSched", "Please call us to schedule your appointment."), ODException.ErrorCodes.NoOperatoriesSetup);
}
List <long> listProvNums = listProviders.Select(x => x.ProvNum).Distinct().ToList();
List <Schedule> listSchedules = Schedules.GetSchedulesAndBlockoutsForWebSched(listProvNums, dateStart, dateEnd, true
, (clinic == null) ? 0 : clinic.ClinicNum);
string timePatternRecall = recallType.TimePattern;
//Apparently scheduling this one recall can potentially schedule a bunch of other recalls at the same time.
//We need to potentially bloat our time pattern based on the other recalls that are due for this specific patient.
if (recallCur != null)
{
Patient patCur = Patients.GetLim(recallCur.PatNum);
List <Recall> listRecalls = Recalls.GetList(recallCur.PatNum);
timePatternRecall = Recalls.GetRecallTimePattern(recallCur, listRecalls, patCur, new List <string>());
}
string timePatternAppointment = RecallTypes.ConvertTimePattern(timePatternRecall);
return(GetTimeSlotsForRange(dateStart, dateEnd, timePatternAppointment, listProvNums, listOperatories, listSchedules, clinic));
}
///<summary></summary>
public static Operatory CreateOperatory(string abbrev = "", string opName = "", long provDentist = 0, long provHygienist = 0, long clinicNum = 0
, bool isHygiene = false, bool isWebSched = false, int itemOrder = 0, bool isNewPatAppt = false)
{
Operatory op = new Operatory();
op.Abbrev = abbrev;
op.ClinicNum = clinicNum;
op.IsHygiene = isHygiene;
op.IsWebSched = isWebSched;
op.IsNewPatAppt = isNewPatAppt;
op.ItemOrder = itemOrder;
if (opName == "")
{
op.OpName = "ClinicNum: " + clinicNum.ToString();
}
else
{
op.OpName = opName;
}
op.ProvDentist = provDentist;
op.ProvHygienist = provHygienist;
Operatories.Insert(op);
if (abbrev == "")
{
op.Abbrev = op.OperatoryNum.ToString();
Operatories.Update(op);
}
Operatories.RefreshCache();
return(op);
}
///<summary>Gets up to 30 days of open time slots for New Patient Appointments based on the timePattern passed in.
///Open time slots are found by looping through the passed in operatories and finding openings that can hold the entire appointment.
///Passing in a clinicNum of 0 will only consider unassigned operatories.
///The timeslots on and between the Start and End dates passed in will be considered and potentially returned as available.
///Optionally pass in an appt type def num which will only consider operatories with the corresponding appointment type.
///defNumApptType is required and will ONLY consider operatories that are associated to the def's corresponding appointment type.
///The time pattern and procedures on the appointment will be determined via the appointment type as well.
///Throws exceptions.</summary>
public static List <TimeSlot> GetAvailableNewPatApptTimeSlots(DateTime dateStart, DateTime dateEnd, long clinicNum, long defNumApptType)
{
//No need to check RemotingRole; no call to db.
//Get the appointment type that is associated to the def passed in. This is required for New Pat Appts.
AppointmentType appointmentType = AppointmentTypes.GetWebSchedNewPatApptTypeByDef(defNumApptType);
if (appointmentType == null)
{
//This message will typically show to a patient and we want them to call in OR to refresh the web app which should no longer show the reason.
throw new ODException(Lans.g("WebSched", "The reason for your appointment is no longer available.") + "\r\n"
+ Lans.g("WebSched", "Please call us to schedule your appointment."));
}
//Now we need to find all operatories that are associated to the aforementioned appointment type.
List <Operatory> listOperatories = Operatories.GetOpsForWebSchedNewPatApptDef(defNumApptType);
if (listOperatories.Count < 1) //This is very possible for offices that aren't set up the way that we expect them to be.
{
return(new List <TimeSlot>()); //Don't throw an exception here to the patient, they can just select another reason.
}
//Set the timePattern from the appointment type passed in.
string timePattern = AppointmentTypes.GetTimePatternForAppointmentType(appointmentType);
List <Provider> listProviders = Providers.GetProvidersForWebSchedNewPatAppt();
Clinic clinic = Clinics.GetClinic(clinicNum);
List <long> listProvNums = listProviders.Select(x => x.ProvNum).Distinct().ToList();
List <Schedule> listSchedules = Schedules.GetSchedulesAndBlockoutsForWebSched(listProvNums, dateStart, dateEnd, false, clinicNum);
return(GetTimeSlotsForRange(dateStart, dateEnd, timePattern, listProvNums, listOperatories, listSchedules, clinic, defNumApptType));
}
private void UserControlSetupWizOperatory_Load(object sender, EventArgs e)
{
FillGrid();
if (Operatories.GetCount(true) == 0)
{
MsgBox.Show("FormSetupWizard", "You have no valid operatories. Please click the Add button to add an operatory.");
timer1.Start();
}
}
private void gridMain_CellDoubleClick(object sender, ODGridClickEventArgs e)
{
Operatory opCur = (Operatory)gridMain.ListGridRows[e.Row].Tag;
FormOperatoryEdit FormOE = new FormOperatoryEdit(opCur);
List <Operatory> listOld = new List <Operatory>();
foreach (Operatory op in _listOps)
{
listOld.Add(op.Copy());
}
FormOE.ListOps = _listOps;
FormOE.ShowDialog();
if (FormOE.DialogResult == DialogResult.OK)
{
Operatories.Sync(_listOps, listOld);
FillGrid();
DataValid.SetInvalid(InvalidType.Operatories);
}
}
private void butAdd_Click(object sender, EventArgs e)
{
FormOperatoryEdit FormOE = new FormOperatoryEdit(new Operatory());
FormOE.IsNew = true;
List <Operatory> listOld = new List <Operatory>();
foreach (Operatory op in _listOps)
{
listOld.Add(op.Copy());
}
FormOE.ListOps = _listOps;
FormOE.ShowDialog();
if (FormOE.DialogResult == DialogResult.OK)
{
Operatories.Sync(_listOps, listOld);
FillGrid();
DataValid.SetInvalid(InvalidType.Operatories);
}
}
///<summary>Gets up to 30 days of open time slots based on the RecallType passed in.
///Open time slots are found by looping through operatories flagged for Web Sched and finding openings that can hold the RecallType.
///The RecallType passed in must be a valid recall type.
///Providers passed in will be the only providers considered when looking for available time slots.
///Passing in a null clinic will only consider operatories with clinics set to 0 (unassigned).
///The timeslots on and between the Start and End dates passed in will be considered and potentially returned as available.
///Optionally pass in a recall object in order to consider all other recalls due for the patient. This will potentially affect the time pattern.
///Throws exceptions.</summary>
public static List <TimeSlot> GetAvailableWebSchedTimeSlots(RecallType recallType, List <Provider> listProviders, Clinic clinic
, DateTime dateStart, DateTime dateEnd, Recall recallCur = null, Logger.IWriteLine log = null)
{
//No need to check RemotingRole; no call to db.
if (recallType == null) //Validate that recallType is not null.
{
throw new ODException(Lans.g("WebSched", "The recall appointment you are trying to schedule is no longer available.") + "\r\n"
+ Lans.g("WebSched", "Please call us to schedule your appointment."));
}
//Get all the Operatories that are flagged for Web Sched.
List <Operatory> listOperatories = Operatories.GetOpsForWebSched();
if (listOperatories.Count < 1) //This is very possible for offices that aren't set up the way that we expect them to be.
{
throw new ODException(Lans.g("WebSched", "There are no operatories set up for Web Sched.") + "\r\n"
+ Lans.g("WebSched", "Please call us to schedule your appointment."), ODException.ErrorCodes.NoOperatoriesSetup);
}
log?.WriteLine("listOperatories:\r\n\t" + string.Join(",\r\n\t", listOperatories.Select(x => x.OperatoryNum + " - " + x.Abbrev)), LogLevel.Verbose);
List <long> listProvNums = listProviders.Select(x => x.ProvNum).Distinct().ToList();
List <Schedule> listSchedules = Schedules.GetSchedulesAndBlockoutsForWebSched(listProvNums, dateStart, dateEnd, true
, (clinic == null) ? 0 : clinic.ClinicNum, log);
log?.WriteLine("listSchedules:\r\n\t" + string.Join(",\r\n\t", listSchedules.Select(x => x.ScheduleNum + " - " + x.SchedDate + " " + x.StartTime))
, LogLevel.Verbose);
string timePatternRecall = recallType.TimePattern;
//Apparently scheduling this one recall can potentially schedule a bunch of other recalls at the same time.
//We need to potentially bloat our time pattern based on the other recalls that are due for this specific patient.
if (recallCur != null)
{
Patient patCur = Patients.GetPat(recallCur.PatNum);
List <Recall> listRecalls = Recalls.GetList(recallCur.PatNum);
timePatternRecall = Recalls.GetRecallTimePattern(recallCur, listRecalls, patCur, new List <string>());
}
string timePatternAppointment = RecallTypes.ConvertTimePattern(timePatternRecall);
return(GetTimeSlotsForRange(dateStart, dateEnd, timePatternAppointment, listProvNums, listOperatories, listSchedules, clinic, log: log,
isDoubleBookingAllowed: PrefC.GetInt(PrefName.WebSchedRecallDoubleBooking) == 0));//is double booking allowed according to the preference
}
///<summary>Adds valid time slots to listAvailableTimeSlots if the time slot found does NOT already exist within the list.
///This is a helper method to better break up the complexity of GetAvailableWebSchedTimeSlots() so that it is easier to follow.
///Make sure that timePattern is always passed in utilizing 5 minute increments (no conversion will be applied to the pattern passed in).
///Optionally set defNumApptType if looking for time slots for New Pat Appt which will apply the DefNum to all time slots found.</summary>
private static void AddTimeSlotsFromSchedule(List <TimeSlot> listAvailableTimeSlots, Schedule schedule, long operatoryNum
, TimeSpan timeSchedStart, TimeSpan timeSchedStop, List <Schedule> listBlockouts
, Dictionary <DateTime, List <ApptSearchProviderSchedule> > dictProvSchedules, List <Appointment> listApptsForOps, string timePattern
, long defNumApptType = 0)
{
//No need to check RemotingRole; no call to db and this is a private method.
//Figure out how large of a time slot we need to find in order to consider this time slot "available".
int apptLengthMins = timePattern.Length * 5;
int timeIncrement = PrefC.GetInt(PrefName.AppointmentTimeIncrement);
DateTime dateSched = schedule.SchedDate;
//Start going through this operatories schedule according to the time increment, looking for a gap that can handle apptLengthMins.
TimeSpan timeSlotStart = new TimeSpan(timeSchedStart.Ticks);
//Start looking for collisions AFTER the start time.
//Stop as soon as the slots stop time meets or passes the sched stop time.
//Iterate through the schedule via the time increment preference.
for (TimeSpan timeSlotStop = timeSchedStart.Add(new TimeSpan(0, timeIncrement, 0))
; timeSlotStop <= timeSchedStop
; timeSlotStop = timeSlotStop.Add(new TimeSpan(0, timeIncrement, 0)))
{
//Check to see if we've found an opening.
TimeSpan timeSpanCur = timeSlotStop - timeSlotStart;
//Check to see if there is an appointment or a blockout that collides with this blockout.
bool isOverlapping = false;
//First we'll look at blockouts because it should be quicker than looking at the appointments
foreach (Schedule blockout in listBlockouts)
{
if (dateSched.Date != blockout.SchedDate)
{
continue; //Blockout is not on the same day that we are looking at.
}
if (!blockout.Ops.Exists(x => x == operatoryNum))
{
continue; //Blockout is not present in this operatory.
}
//Same operatory and day, check if the times overlap.
//Create new TimeSpans in order to remove the date portion from the blockouts.
TimeSpan timeBlockoutStart = new TimeSpan(blockout.StartTime.Hours, blockout.StartTime.Minutes, 0);
TimeSpan timeBlockoutStop = new TimeSpan(blockout.StopTime.Hours, blockout.StopTime.Minutes, 0);
if (IsTimeOverlapping(timeSlotStart, timeSlotStop, timeBlockoutStart, timeBlockoutStop))
{
isOverlapping = true;
break;
}
}
if (isOverlapping) //This check is here so that we don't waste time looping through appointments if we don't need to.
//There was a collision, set the time slot start time to the stop time and continue from there.
{
timeSlotStart = timeSlotStop;
continue;
}
//Next we'll look for overlapping appointments
foreach (Appointment appointment in listApptsForOps)
{
if (appointment.Op != operatoryNum)
{
continue;
}
if (dateSched.Date != appointment.AptDateTime.Date)
{
continue; //Appt is not on the same day that we are looking at.
}
//Same operatory and day, check if the times overlap.
TimeSpan timeApptStart = appointment.AptDateTime.TimeOfDay;
TimeSpan timeApptStop = appointment.AptDateTime.AddMinutes(appointment.Pattern.Length * 5).TimeOfDay;
if (IsTimeOverlapping(timeSlotStart, timeSlotStop, timeApptStart, timeApptStop))
{
isOverlapping = true;
break;
}
}
if (isOverlapping)
{
//There was a collision, set the time slot start time to the stop time and continue from there.
timeSlotStart = timeSlotStop;
continue;
}
if (timeSpanCur.TotalMinutes >= apptLengthMins)
{
//We just found an opening. Make sure we don't already have this time slot available.
DateTime dateTimeSlotStart = new DateTime(dateSched.Year, dateSched.Month, dateSched.Day, timeSlotStart.Hours, timeSlotStart.Minutes, 0);
DateTime dateTimeSlotStop = new DateTime(dateSched.Year, dateSched.Month, dateSched.Day, timeSlotStop.Hours, timeSlotStop.Minutes, 0);
TimeSlot timeSlot = new TimeSlot(dateTimeSlotStart, dateTimeSlotStop, operatoryNum, schedule.ProvNum, defNumApptType);
if (!listAvailableTimeSlots.Any(x => (x.DateTimeStart == dateTimeSlotStart && x.DateTimeStop == dateTimeSlotStop &&
x.ProvNum == schedule.ProvNum))) //We will return multiple time slots for the same time for different providers.
{
//This time slot is not already in our list of available time slots, check for double booking.
if (dictProvSchedules.ContainsKey(dateSched.Date))
{
long recallProvNum = schedule.ProvNum;
if (IsApptPatternDoubleBooked(dictProvSchedules[dateSched.Date], recallProvNum, timePattern, dateTimeSlotStart))
{
//There is a double booking conflict. Do not add this time slot as a possibility.
//However, at this point we know that there are no appointment conflicts for the current time slot, only a double booking conflict.
//The appointment needs to scoot within the operatory to hopefully find the first available opening (unit test 86).
timeSlotStart = timeSlotStart.Add(new TimeSpan(0, timeIncrement, 0));
continue;
}
}
//There are no collisions with this provider's schedule, add it to our list of available time slots.
listAvailableTimeSlots.Add(timeSlot);
}
else
{
//We have found a time slot in another operatory that matches the necessary criteria.
//Check to see if this operatory should be considered before the previously found operatory.
TimeSlot timeSlotCur = listAvailableTimeSlots.First(x => (x.DateTimeStart == dateTimeSlotStart && x.DateTimeStop == dateTimeSlotStop));
Operatory operatoryIn = Operatories.GetOperatory(operatoryNum);
Operatory operatoryCur = Operatories.GetOperatory(timeSlotCur.OperatoryNum);
if (operatoryIn.ItemOrder < operatoryCur.ItemOrder)
{
timeSlotCur.OperatoryNum = operatoryIn.OperatoryNum;
}
}
//Continue looking for more open slots starting at the end of this time slot.
//E.g. we just found 9:30 AM to 10:00 AM. We need to continue from 10:00 AM.
timeSlotStart = timeSlotStop;
continue;
}
}
}
///<summary>Gets open time slots based on the parameters passed in.
///Open time slots are found by looping through the passed in operatories and finding openings that can hold the entire appointment.
///Make sure that timePattern is always passed in utilizing 5 minute increments (no conversion will be applied to the pattern passed in).
///Providers passed in will be the only providers considered when looking for available time slots.
///Passing in a null clinic will only consider operatories with clinics set to 0 (unassigned).
///The timeslots on and between the Start and End dates passed in will be considered and potentially returned as available.
///Optionally set defNumApptType if looking for time slots for New Pat Appt which will apply the DefNum to all time slots found.
///Throws exceptions.</summary>
public static List <TimeSlot> GetTimeSlotsForRange(DateTime dateStart, DateTime dateEnd, string timePattern, List <long> listProvNums
, List <Operatory> listOperatories, List <Schedule> listSchedules, Clinic clinic, long defNumApptType = 0, Logger.IWriteLine log = null)
{
//No need to check RemotingRole; no call to db.
//Order the operatories passed in by their ItemOrder just in case they were passed in all jumbled up.
List <long> listOpNums = listOperatories.OrderBy(x => x.ItemOrder).Select(x => x.OperatoryNum).Distinct().ToList();
//Remove all schedules that fall outside of the date range passed in. Only consider the date right now, the time portion is handled later.
listSchedules.RemoveAll(x => !x.SchedDate.Date.Between(dateStart.Date, dateEnd.Date));
List <Schedule> listProviderSchedules = listSchedules.FindAll(x => x.BlockoutType == 0);
List <Schedule> listBlockoutSchedules = listSchedules.FindAll(x => x.BlockoutType > 0);
//Get every single appointment for all operatories within our start and end dates for double booking and overlapping consideration.
List <Appointment> listApptsForOps = Appointments.GetAppointmentsForOpsByPeriod(Operatories.GetDeepCopy(true).Select(x => x.OperatoryNum).ToList()
, dateStart, dateEnd, log, listSchedules.GroupBy(x => x.ProvNum).Select(x => x.Key).ToList());
log?.WriteLine("listProviderSchedules:\r\n\t" + string.Join(",\r\n\t",
listProviderSchedules.Select(x => x.ScheduleNum + " - " + x.SchedDate.ToShortDateString() + " " + x.StartTime)), LogLevel.Verbose);
log?.WriteLine("listBlockoutSchedules:\r\n\t" + string.Join(",\r\n\t",
listBlockoutSchedules.Select(x => x.ScheduleNum + " - " + x.SchedDate.ToShortDateString() + " " + x.StartTime)), LogLevel.Verbose);
log?.WriteLine("listApptsForOps:\r\n\t"
+ string.Join(",\r\n\t", listApptsForOps.Select(x => x.AptNum + " - " + x.AptDateTime + " OpNum: " + x.Op)), LogLevel.Verbose);
//We need to be conscious of double booking possibilities. Go get provider schedule information for the date range passed in.
Dictionary <DateTime, List <ApptSearchProviderSchedule> > dictProvSchedules = Appointments.GetApptSearchProviderScheduleForProvidersAndDate(
listProvNums, dateStart, dateEnd, listProviderSchedules, listApptsForOps);
//Split up the operatory specific provider schedules from the dynamic ones because each will have different operatory logic.
List <Schedule> listProviderSchedulesWithOp = listProviderSchedules.FindAll(x => x.Ops.Intersect(listOpNums).ToList().Count > 0);
List <ScheduleOp> listScheduleOps = ScheduleOps.GetForSchedList(listProviderSchedules);
//Now we need to get the dynamic schedules (not assigned to a specific operatory).
List <Schedule> listProviderDynamicSchedules = listProviderSchedules.FindAll(x => !listScheduleOps.Exists(y => y.ScheduleNum == x.ScheduleNum));
//Now that we have found all possible valid schedules, find all the unique time slots from them.
List <Schedule> listProviderSchedulesAll = new List <Schedule>(listProviderSchedulesWithOp);
listProviderSchedulesAll.AddRange(listProviderDynamicSchedules);
listProviderSchedulesAll = listProviderSchedulesAll.OrderBy(x => x.SchedDate).ToList();
List <TimeSlot> listAvailableTimeSlots = new List <TimeSlot>();
List <DateTime> listUniqueDays = new List <DateTime>();
int timeIncrement = PrefC.GetInt(PrefName.AppointmentTimeIncrement);
//Loop through all schedules five minutes at a time to find time slots large enough that have no appointments and no blockouts within them.
foreach (Schedule schedule in listProviderSchedulesAll)
{
DateTime dateSched = schedule.SchedDate;
//Straight up ignore schedules in the past. This should not be possible but this is just in case.
if (dateSched.Date < DateTime.Today)
{
continue;
}
if (!listUniqueDays.Contains(dateSched))
{
listUniqueDays.Add(dateSched);
}
TimeSpan timeSchedStart = schedule.StartTime;
TimeSpan timeSchedStop = schedule.StopTime;
//Now, make sure that the start time is set to a starting time that makes sense with the appointment time increment preference.
int minsOver = (timeSchedStart.Minutes) % timeIncrement;
if (minsOver > 0)
{
int minsToAdd = timeIncrement - minsOver;
timeSchedStart = timeSchedStart.Add(new TimeSpan(0, minsToAdd, 0));
}
//Double check that we haven't pushed the start time past the stop time.
if (timeSchedStart >= timeSchedStop)
{
continue;
}
//Figure out all possible operatories for this particular schedule.
List <Operatory> listOpsForSchedule = new List <Operatory>();
if (schedule.Ops.Count > 0)
{
listOpsForSchedule = listOperatories.FindAll(x => schedule.Ops.Exists(y => y == x.OperatoryNum));
}
else //Dynamic schedule. Figure out what operatories this provider is part of that are associated to the corresponding eService.
//Get all of the valid operatories that this provider is associated with.
{
listOpsForSchedule = listOperatories.FindAll(x => x.ProvDentist == schedule.ProvNum || x.ProvHygienist == schedule.ProvNum);
}
if (PrefC.HasClinicsEnabled)
{
//Skip this schedule entry if the operatory's clinic does not match the patient's clinic.
if (clinic == null)
{
//If a clinic was not passed in, ONLY consider unassigned operatories
listOpsForSchedule = listOpsForSchedule.FindAll(x => x.ClinicNum == 0);
}
else
{
//If a valid clinic was passed in, make sure the operatory has a matching clinic.
listOpsForSchedule = listOpsForSchedule.FindAll(x => x.ClinicNum == clinic.ClinicNum);
}
}
if (listOpsForSchedule.Count == 0)
{
continue; //No valid operatories for this schedule.
}
log?.WriteLine("schedule: " + schedule.ScheduleNum + "\tlistOpsForSchedule:\r\n\t"
+ string.Join(",\r\n\t", listOpsForSchedule.Select(x => x.OperatoryNum + " - " + x.Abbrev)), LogLevel.Verbose);
//The list of operatories has been filtered above so we need to find ALL available time slots for this schedule in all operatories.
foreach (Operatory op in listOpsForSchedule)
{
AddTimeSlotsFromSchedule(listAvailableTimeSlots, schedule, op.OperatoryNum, timeSchedStart, timeSchedStop
, listBlockoutSchedules, dictProvSchedules, listApptsForOps, timePattern, defNumApptType);
}
}
//Remove any time slots that start before right now (just in case the consuming method is looking for slots for today).
listAvailableTimeSlots.RemoveAll(x => x.DateTimeStart.Date == DateTime.Now.Date && x.DateTimeStart.TimeOfDay < DateTime.Now.TimeOfDay);
//Order the entire list of available time slots so that they are displayed to the user in sequential order.
//We need to do this because we loop through each provider's schedule one at a time and add openings as we find them.
//Then order by operatory.ItemOrder in order to preserve old behavior (filling up the schedule via operatories from the left to the right).
return(listAvailableTimeSlots.OrderBy(x => x.DateTimeStart)
//listOpNums was ordered by ItemOrder at the top of this method so we can trust that it is in the correct order.
.ThenBy(x => listOpNums.IndexOf(x.OperatoryNum))
.ToList());
}
///<summary>Adds valid time slots to listAvailableTimeSlots if the time slot found does NOT already exist within the list.
///This is a helper method to better break up the complexity of GetAvailableWebSchedTimeSlots() so that it is easier to follow.
///Make sure that timePattern is always passed in utilizing 5 minute increments (no conversion will be applied to the pattern passed in).
///Optionally set defNumApptType if looking for time slots for New Pat Appt which will apply the DefNum to all time slots found.</summary>
private static void AddTimeSlotsFromSchedule(List <TimeSlot> listAvailableTimeSlots, Schedule schedule, long operatoryNum
, TimeSpan timeSchedStart, TimeSpan timeSchedStop, List <Schedule> listBlockouts
, Dictionary <DateTime, List <ApptSearchProviderSchedule> > dictProvSchedules, List <Appointment> listApptsForOps, string timePattern
, long defNumApptType = 0, bool isDoubleBookingAllowed = true)
{
//No need to check RemotingRole; no call to db and this is a private method.
//Figure out how large of a time slot we need to find in order to consider this time slot "available".
int apptLengthMins = timePattern.Length * 5;
int timeIncrement = PrefC.GetInt(PrefName.AppointmentTimeIncrement);
DateTime dateSched = schedule.SchedDate;
//Filter out all blockouts that are not pertinent to this dateSched and operatoryNum combo.
List <Schedule> listBlockoutsForDateAndOp = listBlockouts.FindAll(x => x.SchedDate.Date == dateSched.Date && x.Ops.Contains(operatoryNum));
//Filter out all appointments that are not pertinent to this dateSched and operatoryNum combo.
List <Appointment> listApptsForDateAndOp = listApptsForOps.FindAll(x => x.AptDateTime.Date == dateSched.Date && x.Op == operatoryNum);
//Start going through this operatory's schedule according to the time increment, looking for a gap that can handle apptLengthMins.
TimeSpan timeSlotStart = new TimeSpan(timeSchedStart.Ticks);
//Make a list of all perfect world appointment starting times that we will use within our time slot finding loop to make our slot finding
//more predictable and user friendly. This is mainly for the scenario where offices manually schedule strange appointments throughout the day.
//E.g. Searching for hour long time slots, a 15 min appt was manually scheduled for 09:55 - 10:10 which throws off the nice "on the hour" slots.
//We want to have logic that will prefer to return time slots on the hour. E.g. 8 - 9, 10:10 - 11: 10, 11 - 12 (note the overlap), 12 - 13...
List <TimeSpan> listPerfectSlotStarts = new List <TimeSpan>();
//The first perfect time slot start will always be when our schedule starts.
for (TimeSpan timeSlotPerfect = new TimeSpan(timeSchedStart.Ticks)
; timeSlotPerfect <= new TimeSpan(timeSchedStop.Ticks)
; timeSlotPerfect = timeSlotPerfect.Add(new TimeSpan(0, apptLengthMins, 0)))
{
listPerfectSlotStarts.Add(timeSlotPerfect);
}
//Start looking for collisions AFTER the start time.
//Stop as soon as the slots stop time meets or passes the sched stop time.
//Iterate through the schedule via the time increment preference.
for (TimeSpan timeSlotStop = timeSchedStart.Add(new TimeSpan(0, timeIncrement, 0))
; timeSlotStop <= timeSchedStop
; timeSlotStop = timeSlotStop.Add(new TimeSpan(0, timeIncrement, 0)))
{
//Check to see if we've found an opening.
TimeSpan timeSpanCur = timeSlotStop - timeSlotStart;
//Check to see if there is an appointment or a blockout that collides with this blockout.
bool isOverlapping = false;
#region Blockout Collisions
TimeSpan timeBlockoutStart = new TimeSpan();
TimeSpan timeBlockoutStop = new TimeSpan();
//First we'll look at blockouts because it should be quicker than looking at the appointments
foreach (Schedule blockout in listBlockoutsForDateAndOp)
{
//Create new TimeSpans in order to remove the date portion from the blockouts.
timeBlockoutStart = new TimeSpan(blockout.StartTime.Hours, blockout.StartTime.Minutes, 0);
timeBlockoutStop = new TimeSpan(blockout.StopTime.Hours, blockout.StopTime.Minutes, 0);
if (IsTimeOverlapping(timeSlotStart, timeSlotStop, timeBlockoutStart, timeBlockoutStop))
{
isOverlapping = true;
break;
}
}
if (isOverlapping) //This check is here so that we don't waste time looping through appointments if we don't need to.
//There was a collision with a blockout. Set the time slot start time to the stop time of the blockout and continue from there.
{
timeSlotStart = timeBlockoutStop;
continue;
}
#endregion
#region Appointment Collisions
TimeSpan timeApptStart = new TimeSpan();
TimeSpan timeApptStop = new TimeSpan();
//Next we'll look for overlapping appointments
foreach (Appointment appointment in listApptsForDateAndOp)
{
timeApptStart = appointment.AptDateTime.TimeOfDay;
timeApptStop = appointment.AptDateTime.AddMinutes(appointment.Pattern.Length * 5).TimeOfDay;
if (IsTimeOverlapping(timeSlotStart, timeSlotStop, timeApptStart, timeApptStop))
{
isOverlapping = true;
break;
}
}
if (isOverlapping)
{
//There was a collision with an appointment. Set the time slot start time to the stop time of the appointment and continue from there.
timeSlotStart = timeApptStop;
continue;
}
#endregion
#region Opening Found
if (timeSpanCur.TotalMinutes >= apptLengthMins)
{
//We just found an opening. Make sure we don't already have this time slot available.
DateTime dateTimeSlotStart = new DateTime(dateSched.Year, dateSched.Month, dateSched.Day, timeSlotStart.Hours, timeSlotStart.Minutes, 0);
DateTime dateTimeSlotStop = new DateTime(dateSched.Year, dateSched.Month, dateSched.Day, timeSlotStop.Hours, timeSlotStop.Minutes, 0);
TimeSlot timeSlot = new TimeSlot(dateTimeSlotStart, dateTimeSlotStop, operatoryNum, schedule.ProvNum, defNumApptType);
if (!listAvailableTimeSlots.Any(x => (x.DateTimeStart == dateTimeSlotStart && x.DateTimeStop == dateTimeSlotStop &&
x.ProvNum == schedule.ProvNum))) //We will return multiple time slots for the same time for different providers.
{
//This time slot is not already in our list of available time slots, check for double booking.
if (dictProvSchedules.ContainsKey(dateSched.Date))
{
long recallProvNum = schedule.ProvNum;
if (IsApptTimeSlotDoubleBooked(dictProvSchedules[dateSched.Date], listApptsForDateAndOp, recallProvNum, timePattern, dateTimeSlotStart
, defNumApptType, isDoubleBookingAllowed))
{
//There is a double booking conflict. Do not add this time slot as a possibility.
//However, at this point we know that there are no appointment conflicts for the current time slot, only a double booking conflict.
//The appointment needs to scoot within the operatory to hopefully find the first available opening (unit test 86).
timeSlotStart = timeSlotStart.Add(new TimeSpan(0, timeIncrement, 0));
continue;
}
}
//There are no collisions with this provider's schedule, add it to our list of available time slots.
listAvailableTimeSlots.Add(timeSlot);
//Check to see if the time slot that was just added started on a "perfect starting time".
//If it didn't, we need to backtrack to the most recent "perfect starting time" and continue from there.
if (!listPerfectSlotStarts.Contains(timeSlotStart))
{
//Find the most recent "perfect starting time" that corresponds to the timeSlotStop that was just found.
//We then need to set both timeSlotStart AND timeSlotStop to the closest "perfect starting time" and continue from there.
//E.g. If apptLengthMins is 60 minutes, odds are we are looking for appointments that start on the hour.
//So if we just found an opening that started at 10:10 then we need to backtrack from the stopping time of 11:10 and find the closest
//"perfect starting time", 11:00 in this case, and continue searching from there.
timeSlotStart = listPerfectSlotStarts.Last(x => x.Subtract(timeSlotStop).TotalMinutes < 0);
timeSlotStop = timeSlotStart;
}
}
else
{
//We have found a time slot in another operatory that matches the necessary criteria.
//Check to see if this operatory should be considered before the previously found operatory.
TimeSlot timeSlotCur = listAvailableTimeSlots.First(x => (x.DateTimeStart == dateTimeSlotStart && x.DateTimeStop == dateTimeSlotStop));
Operatory operatoryIn = Operatories.GetOperatory(operatoryNum);
Operatory operatoryCur = Operatories.GetOperatory(timeSlotCur.OperatoryNum);
if (operatoryIn.ItemOrder < operatoryCur.ItemOrder)
{
timeSlotCur.OperatoryNum = operatoryIn.OperatoryNum;
}
}
//Continue looking for more open slots starting at the end of this time slot.
//E.g. we just found 9:30 AM to 10:00 AM. We need to continue from 10:00 AM.
timeSlotStart = timeSlotStop;
continue;
}
#endregion
}
}
///<summary>Uses ListApptSinceSignalCache to determine what Appointments and Schedules have changed for the given ClinicNum's ops.
///Only goes to the database if an appointment, schedule, or operatory signal is linked to the op's passed in and is in our daterange.
///If an entry for a given operatory is included in the output, then all appointments and blockouts for that operatory will be included for all dates specified in the range.
///timeRefreshed is the last time signals were processed. A value of DateTime.MinVal will return an empty list of appointments and schedules.
///If includeApptItemsInOutput==true then lists of Appointments and Schedules will be full and valid.
///When includeApptItemsInOutput==false then lists will be empty and caller is only interesting in whether or not the list of tuples itself would be > 0. This will be used to decide if signal processing should be performed.</summary>
public static List <Tuple <long, DateTime, List <Appointment>, List <Schedule> > > GetApptsAndSchedsSince(DateTime timeRefreshed, DateTime dateViewingStart, DateTime dateViewingEnd, List <long> listClinicNums, bool includeApptItemsInOutput)
{
//Xam will pass DateTime.MinVal if first this is the first attempt for the session.
//Pass back empty list here so we can establish TimeRefreshed for next time.
if (timeRefreshed == DateTime.MinValue)
{
return(new List <Tuple <long, DateTime, List <Appointment>, List <Schedule> > >());
}
List <Signalod> listSignalsFiltered = null;
lock (_lockInvalidTypes) {
listSignalsFiltered = ListApptSinceSignalCache.FindAll(x =>
//Only care about signal since the last time we asked.
x.SigDateTime >= timeRefreshed &&
//Always include signals that have not specified DateViewing of MinVal. This is a special case means a full appt refresh is needed.
//Otherwise only include signals which match that date range that we are actually viewing right now.
(x.DateViewing == DateTime.MinValue.Date || x.DateViewing.Between(dateViewingStart, dateViewingEnd, true, true)));
}
List <Signalod> listApptSignals = listSignalsFiltered.FindAll(x => x.IType == InvalidType.Appointment);
List <Signalod> listSchedSignals = listSignalsFiltered.FindAll(x => x.IType == InvalidType.Schedules);
//Operatories signal insert is not accompanied by an Appointment signal in OD proper.
//So if we get any Op signal, assume that all appts are dirty for all clinics. Dirty Ops is rare so it's fine to be overly cautious.
bool isOpsChanged = listSignalsFiltered.Any(x => x.IType == InvalidType.Operatories);
//Get all operatories for each clinic in listClinics, generally we will only be passed one clinic.
List <long> listOpNumsVisible = new List <long>();
foreach (long clinicNum in listClinicNums)
{
//For now, all ops for this clinic. If we ever implement appt view for OD Mobile, we will need a filter here.
//todo: test with clinicNum 0 and clinics off. Should get all clinics but probably only gets clinicNum 0.
listOpNumsVisible.AddRange(Operatories.GetOpsForClinic(clinicNum).Select(x => x.OperatoryNum).ToList());
}
//Remove duplicates.
listOpNumsVisible = listOpNumsVisible.Distinct().ToList();
//Init these to empty list, not null. This is important down below.
List <Appointment> listAppts = new List <Appointment>();
List <Schedule> listScheds = new List <Schedule>();
List <Tuple <long, DateTime, List <Appointment>, List <Schedule> > > ret = new List <Tuple <long, DateTime, List <Appointment>, List <Schedule> > >();
if (
//An Operatory signal means we should refresh all operatories for all dates.
isOpsChanged
//An appt signal where we don't know exactly which appts have changed so refresh all operatories.
|| listApptSignals.Exists(x => x.DateViewing == DateTime.MinValue.Date)
//A schedule signal where we don't know exactly which schedules have changed so refresh all blockouts.
|| listSchedSignals.Exists(x => x.DateViewing == DateTime.MinValue.Date))
{
//Only query the db when we absolutely have to.
if (includeApptItemsInOutput && listOpNumsVisible.Count > 0)
{
//Get all appts and schedules for the ops which have changes.
listAppts = Appointments.GetAppointmentsForOpsByPeriod(listOpNumsVisible, dateViewingStart, dateViewingEnd);
listScheds = Schedules.GetAllForDateRangeAndType(dateViewingStart, dateViewingEnd, ScheduleType.Blockout, false, listOpNumsVisible);
}
//One entry in the list per every operatory and date in our range.
foreach (long opNum in listOpNumsVisible)
{
int days = dateViewingEnd.Subtract(dateViewingStart).Days;
for (int i = 0; i <= days; i++)
{
//The entry may be empty for a given operatory if there are currently no items for the given date range.
DateTime date = dateViewingStart.AddDays(i).Date;
ret.Add(new Tuple <long, DateTime, List <Appointment>, List <Schedule> >(
opNum,
date,
//Will be empty in !includeApptItemsInOutput.
listAppts.FindAll(y => y.Op == opNum && y.AptDateTime.Date == date),
//Will be empty in !includeApptItemsInOutput.
listScheds.FindAll(y => y.Ops.Contains(opNum) && y.SchedDate.Date == date)
));
}
}
}
else
{
//Only add entries for operatory/date pairs which had a signal specificially added.
var dateChanges = listApptSignals
//We are not considering KeyType.Provider for now.
//This leaves a tiny edge case where a KeyType.Provider signal was made by SignalOds.SetInvalidAppt() but not a KeyType.Operatory signal.
//Sam and Luke were not even able to produce this edge case and implementing it would cause us to have to redesign this linq statement to not be Ops-based.
//If a bug is reported in the future regarding changing something about provider not updating the appt view in ODMobile then this is likely the culprit.
.FindAll(x => x.FKeyType == KeyType.Operatory && x.FKey.In(listOpNumsVisible))
.GroupBy(x => new { x.FKey, x.DateViewing.Date })
.Select(x => new { Op = x.Key.FKey, x.Key.Date })
.Union(listSchedSignals
.FindAll(x => x.FKeyType == KeyType.Operatory && x.FKey.In(listOpNumsVisible))
.GroupBy(x => new { x.FKey, x.DateViewing.Date })
.Select(x => new { Op = x.Key.FKey, x.Key.Date })
)
.GroupBy(x => new { x.Op, x.Date })
.Select(x => new { x.Key.Op, x.Key.Date })
.GroupBy(x => x.Date)
.Select(x => new { Date = x.Key, Ops = x.Select(y => y.Op).ToList() });
foreach (var dateChange in dateChanges)
{
//Only query the db when we absolutely have to.
if (includeApptItemsInOutput)
{
//Get all appts and schedules for each unique op/date.
//Some dates in our range may have changes and some may not so we will need to query the db once for each date which has changes.
//Appointments.GetAppointmentsForOpsByPeriod DOES add a day to DateEnd.
listAppts = Appointments.GetAppointmentsForOpsByPeriod(dateChange.Ops, dateChange.Date, dateChange.Date);
//Schedules.GetAllForDateRangeAndType does NOT add a day to DateEnd.
listScheds = Schedules.GetAllForDateRangeAndType(dateChange.Date, dateChange.Date.AddDays(1), ScheduleType.Blockout, false, dateChange.Ops);
}
//One entry in the list per changed operatory/date. The entry may be empty for a given operatory if there are currently no items for the given date range.
ret.AddRange(dateChange.Ops.Select(x => new Tuple <long, DateTime, List <Appointment>, List <Schedule> >(
x,
dateChange.Date,
//Will be empty in !includeApptItemsInOutput.
listAppts.FindAll(y => y.Op == x && y.AptDateTime.Date == dateChange.Date),
//Will be empty in !includeApptItemsInOutput.
listScheds.FindAll(y => y.Ops.Contains(x) && y.SchedDate.Date == dateChange.Date)
)));
}
}
return(ret);
}
