Esempio n. 1
0
        private void butOK_Click(object sender, EventArgs e)
        {
            DataTable tablePats = KPINoShowAppt.GetNoShowAppt(dtpStart.Value, dtpEnd.Value);

            ReportComplex report = new ReportComplex(true, false);

            report.ReportName = Lan.g(this, "Patients who missed their appointment");
            report.AddTitle("Title", Lan.g(this, "Patients who missed their appointment"));
            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("Postal Code", 90, FieldValueType.String);
            query.AddColumn("Date of Service", 100, FieldValueType.String);
            query.AddColumn("Primary Provider", 80, FieldValueType.String);
            query.AddColumn("Procedure Description", 100, FieldValueType.String);
            query.AddGroupSummaryField("Patient Count:", "Name", "Provider", SummaryOperation.Count);
            report.AddPageNum();
            if (!report.SubmitQueries())
            {
                return;
            }
            FormReportComplex FormR = new FormReportComplex(report);

            FormR.ShowDialog();
            //DialogResult=DialogResult.OK;
        }
Esempio n. 2
0
        public void GetPatientsNoShow()
        {
            DataTable real_dt     = KPINoShowAppt.GetNoShowAppt(Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-03-20"));
            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("Postal Code");
            expected_dt.Columns.Add("Date of Service");
            expected_dt.Columns.Add("Primary Provider");
            expected_dt.Columns.Add("Procedure Description");

            DataRow _testPat = expected_dt.NewRow();

            _testPat["Name"]   = "Test, Patient 1";
            _testPat["Gender"] = "F";
            var birthdate = Convert.ToDateTime("1990-07-21");
            var age       = DateTime.UtcNow.Year - birthdate.Year;

            if (birthdate > DateTime.UtcNow.AddYears(-age))
            {
                age--;
            }
            _testPat["Age"]                   = age.ToString();
            _testPat["Postal Code"]           = "T6E1R1";
            _testPat["Primary Provider"]      = "DOC";
            _testPat["Procedure Description"] = "fix teeth";

            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"]);
        }