private void butOK_Click(object sender, EventArgs e)
{
DataTable tablePats = KPIRecallBacklog.GetRecallBacklog(dtpStart.Value, dtpEnd.Value);
ReportComplex report = new ReportComplex(true, false);
report.ReportName = Lan.g(this, "Backlog of Recall Patients");
report.AddTitle("Title", Lan.g(this, "Backlog of Recall Patients"));
report.AddSubTitle("Date", dtpStart.Value.ToShortDateString() + " - " + dtpEnd.Value.ToShortDateString());
QueryObject query;
query = report.AddQuery(tablePats, "", "", SplitByKind.None, 0);
query.AddColumn("Name", 90, FieldValueType.String);
query.AddColumn("Gender", 60, FieldValueType.String);
query.AddColumn("Contact Method", 100, FieldValueType.String);
query.AddColumn("Phone", 100, FieldValueType.String);
query.AddColumn("Email", 120, FieldValueType.String);
query.AddColumn("Hygienist ID (Last Appt)", 60, FieldValueType.String);
query.AddColumn("Date of Last Recall", 90, FieldValueType.String);
query.AddColumn("Due Date", 90, FieldValueType.String);
query.AddGroupSummaryField("Patient Count", "Gender", "Name", SummaryOperation.Count);
report.AddPageNum();
if (!report.SubmitQueries())
{
return;
}
FormReportComplex FormR = new FormReportComplex(report);
FormR.ShowDialog();
//DialogResult=DialogResult.OK;
}
public void GetPatientsOnRecall()
{
var startDate = new DateTime(2016, 3, 20);
var endDate = new DateTime(2017, 4, 2);
DataTable test = KPIRecallBacklog.GetRecallBacklog(startDate, endDate);
Assert.IsNotNull(test);
Assert.AreEqual(1, test.Rows.Count);
}