public void GetNewToRecall()
{
DataTable real_dt = KPINewToRecall.GetNewToRecall(Convert.ToDateTime("2016-03-26"), Convert.ToDateTime("2017-03-26"));
DataTable expected_dt = new DataTable();
expected_dt.Clear();
expected_dt.Columns.Add("Name");
expected_dt.Columns.Add("Gender");
expected_dt.Columns.Add("Age");
expected_dt.Columns.Add("Type of Recall");
DataRow _testPat = expected_dt.NewRow();
_testPat["Name"] = "Test, Patient 1";
_testPat["Gender"] = "M";
var birthdate = Convert.ToDateTime("1988-07-21");
var age = DateTime.UtcNow.Year - birthdate.Year;
if (birthdate > DateTime.UtcNow.AddYears(-age))
{
age--;
}
_testPat["Age"] = age.ToString();
_testPat["Type of Recall"] = "Prophy";
expected_dt.Rows.Add(_testPat);
Assert.IsNotNull(real_dt);
Assert.AreEqual(1, real_dt.Rows.Count);
Assert.AreEqual(real_dt.Rows[0]["Name"], expected_dt.Rows[0]["Name"]);
Assert.AreEqual(real_dt.Rows[0]["Type of Recall"], expected_dt.Rows[0]["Type of Recall"]);
}
private void butOK_Click(object sender, EventArgs e)
{
DataTable tablePats;
tablePats = KPINewToRecall.GetNewToRecall(dtpStart.Value, dtpEnd.Value);
ReportComplex report = new ReportComplex(true, false);
report.ReportName = Lan.g(this, "New to Recall Patients");
report.AddTitle("Title", Lan.g(this, "New to Recall Patients"));
report.AddSubTitle("Date", dtpStart.Value.ToShortDateString() + " - " + dtpEnd.Value.ToShortDateString());
QueryObject query;
query = report.AddQuery(tablePats, "", "", SplitByKind.None, 0);
query.AddColumn("Name", 150, FieldValueType.String);
query.AddColumn("Gender", 60, FieldValueType.String);
query.AddColumn("Age", 40, FieldValueType.String);
query.AddColumn("Type of Recall", 100, FieldValueType.String);
query.AddGroupSummaryField("Patient Count:", "Name", "Type of Recall", SummaryOperation.Count);
report.AddPageNum();
if (!report.SubmitQueries())
{
return;
}
FormReportComplex FormR = new FormReportComplex(report);
FormR.ShowDialog();
//DialogResult=DialogResult.OK;
}