private CallingDates GetCallingDates() { CallingDates callingDates = new CallingDates(); DateTime dateToCall = DateTime.Now; if (DateTime.Now.DayOfWeek == DayOfWeek.Monday) { callingDates.BeginCallingDate = dateToCall.AddDays(-3).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(-2).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Tuesday) { callingDates.BeginCallingDate = dateToCall.AddDays(-1).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(0).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Wednesday) { callingDates.BeginCallingDate = dateToCall.AddDays(-1).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(0).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Thursday) { callingDates.BeginCallingDate = dateToCall.AddDays(-1).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(0).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Friday) { callingDates.BeginCallingDate = dateToCall.AddDays(-1).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(0).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Saturday) { callingDates.BeginCallingDate = dateToCall.AddDays(-1).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(0).ToShortDateString(); return callingDates; } else if (DateTime.Now.DayOfWeek == DayOfWeek.Sunday) { callingDates.BeginCallingDate = dateToCall.AddDays(2).ToShortDateString(); callingDates.EndCallingDate = dateToCall.AddDays(3).ToShortDateString(); return callingDates; } return callingDates; }
public List<SignedDocument> GetListOfOrthoNowDocumentssToSendViaFax() { List<SignedDocument> documentsList = new List<SignedDocument>(); string beginDate = DateTime.Now.AddDays(-1).ToShortDateString(); string endDate = DateTime.Now.ToShortDateString(); CallingDates callingDates = new CallingDates(); callingDates = GetCallingDates(); try { using (IDbConnection db = new SqlConnection(ConfigurationValues.GreenwayConnection)) { string query = "select 'Y' as Proccess, ClinicalDocumentSignatures.SequenceNumber as SequenceNumber, CareProviderLocation.LocationName as Location, vVisit.VisitID," + " ClinicalDocuments.DocumentID as DocumentID," + " ClinicalDocumentSignatures.DateSigned as DateSigned," + " patient.PatientID as PatientID," + " person.FirstName +' '+ person.LastName as PatientName," + " vVisit.BillableCareProviderID as CareProviderID," + " vvisit.BillableFirstName + ' ' + vvisit.BillableLastName + ', ' + vVisit.BillableCredentials as CareProviderName," + " vVisit.PrimaryCareProviderID as PrimaryCareProviderID," + " vVisit.PrimaryFirstName + ' ' + vVisit.PrimaryLastName + ', ' + vVisit.PrimaryCredentials as PrimaryCareProvider," + " vVisit.ReferringProviderID as ReferringCareProviderID," + " vVisit.ReferringFirstName + ' ' + vVisit.ReferringLastName + ', ' + vVisit.ReferringCredentials as ReferringCareProvider," + " ClinicalDocTypes.DocTypeName as DocTypeName," + " ClinicalDocumentSignatures.SignerID as SignerID," + " ClinicalDocuments.Createdby as CreatedByID" + " from ClinicalDocumentSignatures" + " inner JOIN ClinicalDocuments" + " on ClinicalDocuments.DocumentID = ClinicalDocumentSignatures.DocumentID" + " inner JOIN Visit" + " on visit.VisitID = ClinicalDocuments.VisitID" + " inner JOIN vVisit" + " on vVisit.VisitID = visit.VisitID" + " inner JOIN patient " + " on ClinicalDocuments.PatientID = patient.PatientID" + " inner JOIN person" + " on patient.PersonID = person.PersonID" + " inner JOIN CareProvider" + " on CareProvider.CareProviderID = visit.CareProviderID" + " inner JOIN ClinicalDocTypes" + " on ClinicalDocTypes.DocTypeID = ClinicalDocuments.DocTypeID" + " inner JOIN CareProviderLocation" + " on CareProviderLocation.Locationid = Visit.ServiceLocationID" + " inner JOIN vApptInfo" + " on vApptInfo.VisitID = Visit.VisitID" + " inner JOIN ScheduleStepList" + " on ScheduleStepList.StepId = vApptInfo.StepID" //+ " where ClinicalDocumentSignatures.DateSigned between '" + callingDates.BeginCallingDate + "' and '" + callingDates.EndCallingDate + "'" + " and ClinicalDocumentSignatures.DateSigned between '5/18/2015' and '5/19/2015'" //+ " where ClinicalDocumentSignatures.Signerid = 1024" + " where ClinicalDocTypes.DocTypeID in (1,7)" + " and CareProviderLocation.LocationName in ('HMDN2408','BRFD84','ORNG330')" //+ " and CareProviderLocation.LocationName in ('HMDN2408ON','BRFD84ON','ORNG330ON')" + " and ClinicalDocumentSignatures.SignerID = 1024" //+ listOfLocations //+ listOfProviderIds + " and ScheduleStepList.StepId NOT IN (1038,1018,1035)"; documentsList = db.Query<SignedDocument>(query).ToList(); return CheckBusinessRulesForSendingFaxes(documentsList); } } catch (Exception er) { Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); return documentsList; } }