private static 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(3).ToShortDateString();
callingDates.EndCallingDate = dateToCall.AddDays(4).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;
}
private static List<SignedDocument> GetListOfDocumentssToSendViaFax(string listOfCarProviderIDS)
{
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 vVisit.VisitID,"
+ " ClinicalDocuments.DocumentID as DocumentID,"
+ " ClinicalDocumentSignatures.DateSigned as DateSigned,"
+ " patient.PatientID as PatientID,"
+ " person.FirstName +' '+ person.LastName as PatientName,"
//+ " Visit.CareProviderID as CareProviderID,"
+ " 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"
+ " 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"
+ " where ClinicalDocumentSignatures.DateSigned between '09/3/2015' and '09/4/2015'"
//+ " where ClinicalDocumentSignatures.DateSigned between '" + callingDates.BeginCallingDate + "' and '" + callingDates.EndCallingDate + "'"
+ " and ClinicalDocTypes.DocTypeID in (1,7)"
+ " and ClinicalDocumentSignatures.SignerID in (1025,1033)";
// + " and vVisit.VisitID = 209777";
//+ " and ClinicalDocumentSignatures.SignerID in (1033)";
//string query = "select ClinicalDocuments.DocumentID,ClinicalDocumentSignatures.SignerID as SignerID, vVisit.BillableFirstName + ' ' + vVisit.BillableLastName as Name,CASE "
// + " WHEN [System] = 1"
// + " THEN 'Chart'"
// + " ELSE 'Administrative'"
// + " END as 'DocType', "
// + " ClinicalDocuments.created as DateCreated,patient.PatientID,person.LastName, person.FirstName,"
// + " vVisit.PrimaryCareProviderID as PrimaryCareProviderID,"
// + " vVisit.ReferringProviderID as ReferringProviderID,"
// + " ClinicalDocTypes.DocTypeName,vVisit.ReferringFirstName + ' ' + vVisit.ReferringLastName as ReferringProvider,"
// + " vVisit.PrimaryFirstName + ' ' + vVisit.PrimaryLastName as PrimaryPhysician from ClinicalDocuments"
// + " inner JOIN patient "
// + " on ClinicalDocuments.PatientID = patient.PatientID"
// + " inner JOIN person"
// + " on patient.PersonID = person.PersonID"
// + " inner JOIN vVisit"
// + " on vVisit.VisitID = ClinicalDocuments.VisitID"
// + " inner JOIN ClinicalDocTypes"
// + " on ClinicalDocTypes.DocTypeID = ClinicalDocuments.DocTypeID"
// + " inner JOIN Users"
// + " on Users.UserID = ClinicalDocuments.CreatedBy"
// + " inner JOIN ClinicalDocumentSignatures"
// + " on ClinicalDocumentSignatures.DocumentID = ClinicalDocuments.DocumentID"
// //+ listOfCarProviderIDS
// + " where ClinicalDocumentSignatures.SignerID in (1025,1033)"
// + " and ClinicalDocumentSignatures.documentid = ClinicalDocuments.documentid"
// + " and ClinicalDocumentSignatures.DateSigned between '" + callingDates.BeginCallingDate + "' and '" + callingDates.EndCallingDate + "'"
// + " and ClinicalDocTypes.DocTypeID in (1,7)"
// + " order by Users.Firstname + ' ' + users.Lastname,ClinicalDocuments.created";
documentsList = db.Query<SignedDocument>(query).ToList();
return documentsList;
}
}
catch (Exception er)
{
// LogErrors(er.ToString());
//Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
//Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
return documentsList;
}
}
