private static bool CompareDateCriteria(DateCriteria criteria, DateTime nodeDate,
DateTime firstDate, DateTime secondDate)
{
switch (criteria)
{
case DateCriteria.On:
return(nodeDate.Date == firstDate.Date);
case DateCriteria.Before:
return(nodeDate < firstDate);
case DateCriteria.After:
return(nodeDate > firstDate);
case DateCriteria.Between:
return(nodeDate >= firstDate && nodeDate <= secondDate);
}
return(true);
}
private void creationCriteriaCombo_OnChange(object sender, EventArgs e)
{
DateCriteria creationCriteria = (DateCriteria)EnumEx.GetValueFromDescription(typeof(DateCriteria),
creationCriteriaCombo.SelectedItem.ToString());
switch (creationCriteria)
{
case DateCriteria.Any:
firstCreationDatePicker.Visible = false;
firstCreationTimePicker.Visible = false;
creationAndLabel.Visible = false;
secondCreationDatePicker.Visible = false;
secondCreationTimePicker.Visible = false;
break;
case DateCriteria.On:
firstCreationDatePicker.Visible = true;
firstCreationTimePicker.Visible = false;
creationAndLabel.Visible = false;
secondCreationDatePicker.Visible = false;
secondCreationTimePicker.Visible = false;
break;
case DateCriteria.After:
case DateCriteria.Before:
firstCreationDatePicker.Visible = true;
firstCreationTimePicker.Visible = true;
creationAndLabel.Visible = false;
secondCreationDatePicker.Visible = false;
secondCreationTimePicker.Visible = false;
break;
case DateCriteria.Between:
firstCreationDatePicker.Visible = true;
firstCreationTimePicker.Visible = true;
creationAndLabel.Visible = true;
secondCreationDatePicker.Visible = true;
secondCreationTimePicker.Visible = true;
break;
}
}
private DateValidation validateCreationCriteria()
{
DateCriteria creationCriteria = (DateCriteria)EnumEx.GetValueFromDescription(typeof(DateCriteria),
creationCriteriaCombo.SelectedItem.ToString());
DateTime firstDateTime = firstCreationDatePicker.Value.Date;
firstDateTime = firstDateTime.Add(firstCreationTimePicker.Value.TimeOfDay);
DateTime secondDateTime = secondCreationDatePicker.Value.Date;
secondDateTime = secondDateTime.Add(secondCreationTimePicker.Value.TimeOfDay);
DateValidation creationResult = validateDateCriteria(creationCriteria, firstDateTime, secondDateTime);
searchCriteria.CreatedDateCriteria = creationCriteria;
searchCriteria.FirstCreatedDate = firstDateTime;
searchCriteria.SecondCreatedDate = secondDateTime;
return(creationResult);
}
private DateValidation validateModifiedCriteria()
{
DateCriteria modifiedCriteria = (DateCriteria)EnumEx.GetValueFromDescription(typeof(DateCriteria),
modifiedCriteriaCombo.SelectedItem.ToString());
DateTime firstDateTime = firstModifiedDatePicker.Value.Date;
firstDateTime = firstDateTime.Add(firstModifiedTimePicker.Value.TimeOfDay);
DateTime secondDateTime = secondModifiedDatePicker.Value.Date;
secondDateTime = secondDateTime.Add(secondModifiedTimePicker.Value.TimeOfDay);
DateValidation modifiedResult = validateDateCriteria(modifiedCriteria, firstDateTime, secondDateTime);
searchCriteria.ModifiedDateCriteria = modifiedCriteria;
searchCriteria.FirstModifiedDate = firstDateTime;
searchCriteria.SecondModifiedDate = secondDateTime;
return(modifiedResult);
}
private DateValidation validateDateCriteria(DateCriteria dateCriteria,
DateTime firstDateTime, DateTime secondDateTime)
{
switch (dateCriteria)
{
case DateCriteria.On:
if (firstDateTime.Date > DateTime.Today.Date)
{
return(DateValidation.AfterNow);
}
break;
case DateCriteria.After:
if (firstDateTime > DateTime.Now)
{
return(DateValidation.AfterNow);
}
break;
case DateCriteria.Between:
if (firstDateTime > DateTime.Now)
{
return(DateValidation.AfterNow);
}
if (firstDateTime > secondDateTime)
{
return(DateValidation.NegativeSpan);
}
break;
}
return(DateValidation.Good);
}
} // Is SQL, ie = " AND clinic_id IN (30)
private void SetReportSource()
{
List <AgingReportRow> reportData = new List <AgingReportRow>();
claim c = new claim();
company_contact_info cci = new company_contact_info();
c.company_address_id = 0;
string SQL = @"SELECT co.name as company_name, group_name as group_plan, group_num , cci.phone as company_phone,
c.id as claim_id, sent_date, date_of_service, subscriber_first_name + ' ' + subscriber_last_name AS subscriber,
CASE c.claim_type WHEN 0 THEN 'P' WHEN 1 THEN 'S' ELSE 'PRE' END AS 'Type', c.subscriber_alternate_number as idnum, patient_first_name + ' ' + patient_last_name AS patient,
patient_dob as Birthday, c.amount_of_claim as Total, revisit_date, cs.name as current_status
FROM claims c INNER JOIN companies co ON c.company_id = co.id INNER JOIN company_contact_info cci ON
cci.order_id = c.company_address_id AND co.id = cci.company_id LEFT JOIN claimstatus cs ON cs.id = c.status_id ";
string claimsToInclude = "-1";
string reportName = string.Empty;
if (chkShowPrimary.Checked)
{
reportName = "Primary";
claimsToInclude += ",0";
}
if (chkShowSecondary.Checked)
{
if (reportName != string.Empty)
{
reportName += " and ";
}
reportName += "Secondary";
claimsToInclude += ",1";
}
if (chkShowPredeterms.Checked)
{
if (reportName != string.Empty)
{
reportName += " and ";
}
reportName += "Predeterm";
claimsToInclude += ",2,3";
}
string whereClause = string.Format(" WHERE claim_type IN({0}) AND DATEDIFF(d, sent_date, GETDATE()) > {1} {2} AND [open] = 1", claimsToInclude, DateCriteria, ClinicCriteria);
DataTable allMatches = c.Search(SQL + whereClause + " ORDER BY company_name, group_plan");
foreach (DataRow aRow in allMatches.Rows)
{
AgingReportRow ar = new AgingReportRow();
ar.CompanyName = aRow["company_name"].ToString();
ar.GroupNumber = aRow["group_num"].ToString();
ar.GroupPlan = aRow["group_plan"].ToString() == "" ? "[No Plan Name]" : aRow["group_plan"].ToString(); // give it a default val if blank
try { ar.CompanyPhone = new PhoneObject(aRow["company_phone"].ToString()).FormattedPhone; }
catch { ar.CompanyPhone = aRow["company_phone"].ToString(); }
ar.SentDate = Convert.ToDateTime(aRow["sent_date"]);
ar.DateOfService = Convert.ToDateTime(aRow["date_of_service"]);
ar.Subscriber = aRow["subscriber"].ToString();
ar.Type = aRow["type"].ToString();
ar.IDNum = aRow["idnum"].ToString();
ar.Patient = aRow["patient"].ToString();
if (CommonFunctions.DBNullToString(aRow["birthday"]) == "")
{
ar.Birthday = new DateTime(1901, 1, 1);
}
else
{
ar.Birthday = Convert.ToDateTime(aRow["birthday"]);
}
ar.Total = Convert.ToDecimal(aRow["total"]) / 100;
if (CommonFunctions.DBNullToString(aRow["revisit_date"]) == "")
{
ar.RevisitDate = "";
}
else
{
ar.RevisitDate = Convert.ToDateTime(aRow["revisit_date"]).ToString("M/d/yy");
}
ar.CurrentStatus = aRow["current_status"].ToString();
reportData.Add(ar);
}
AgingReportRowBindingSource.DataSource = reportData;
reportName += string.Format(" (> {0} days)", DateCriteria.ToString("0"));
rptvMain.ShowParameterPrompts = false;
rptvMain.LocalReport.ReportPath = "Reporting\\PriorityReport.rdlc";
rptvMain.LocalReport.SetParameters(new ReportParameter("ReportName", reportName));
rptvMain.RefreshReport();
}
