public void GetCompletedCases()
{
DataTable compcasesFor14;
DataTable patsFor14;
patsFor14 = KPICompletedCases.GetCompletedCasesPats(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"));
Assert.AreEqual(0, patsFor14.Rows.Count);
var seedData2 = File.ReadAllText(@"..\..\Resources\kpi14completedcasesPT2.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData2);
var startDate = new DateTime(2016, 3, 20);
var endDate = new DateTime(2017, 4, 5);
String patQuery = @"
SELECT DISTINCT p.PatNum, p.LName, p.FName, p.MiddleI,
p.HmPhone, p.WkPhone, p.WirelessPhone, p.Email
FROM unittest.procedurelog pl
JOIN unittest.appointment a ON pl.PlannedAptNum = a.AptNum
JOIN unittest.procedurecode pc ON pc.CodeNum = pl.CodeNum
JOIN unittest.patient p ON p.PatNum = pl.PatNum
WHERE a.AptStatus = 6
AND pl.ProcStatus = 2
AND (pl.ProcDate BETWEEN '2016-03-21' AND '2018-03-21' )
";
// var patsFor14a = KPICompletedCases.GetCompletedCasesPats(startDate, endDate);
var patsFor14a = StretchKPICustomForm.GetPatients(startDate, endDate, patQuery);
Assert.IsNotNull(patsFor14a);
Assert.AreEqual(1, patsFor14a.Rows.Count);
var compcasesFor14a = KPICompletedCases.GetCompletedCasesPerPat(startDate, endDate,
"1401");
Assert.AreEqual(1, compcasesFor14a.Rows.Count);
var seedData3 = File.ReadAllText(@"..\..\Resources\kpi14completedcasesPT3.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData3);
var patsFor14b = StretchKPICustomForm.GetPatients(startDate, endDate, patQuery);
Assert.IsNotNull(patsFor14b);
Assert.AreEqual(2, patsFor14b.Rows.Count);
var compcasesFor14b = KPICompletedCases.GetCompletedCasesPerPat(startDate, endDate,
"1402");
Assert.AreEqual(3, compcasesFor14b.Rows.Count);
compcasesFor14b = KPICompletedCases.GetCompletedCasesPerPat(startDate, endDate,
"1403");
Assert.AreEqual(3, compcasesFor14b.Rows.Count);
}
public void Initialize()
{
//Create test DB
DatabaseTools.SetDbConnection("", "localhost", "3306", "root", "", false);
DatabaseTools.FreshFromDump("localhost", "3306", "root", "", false);
//Inject data
var seedData = File.ReadAllText(@"..\..\Resources\backlogrecall.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData);
}
public void GetPendingTreatments()
{
DataTable plannedAppsFor13;
DataTable patsFor13;
patsFor13 = StretchKPICustomForm.GetPatients(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
KPIPendingTreatments.getPatQuery());
Assert.AreEqual(0, patsFor13.Rows.Count);
// TEST FOR 2 TREATMENTS FOR 1 PAT, 1 PLANNEDAPPT; ONE TREATMENT HAS CODE 01202
var seedData2 = File.ReadAllText(@"..\..\Resources\kpi13pendingtreatmentsPT2.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData2);
patsFor13 = StretchKPICustomForm.GetPatients(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
KPIPendingTreatments.getPatQuery());
plannedAppsFor13 = KPIPendingTreatments.GetPendingTreatmentProcsPerPat(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
patsFor13.Rows[0]["PatNum"].ToString());
Assert.AreEqual(1, patsFor13.Rows.Count);
Assert.AreEqual(1, plannedAppsFor13.Rows.Count);
// TEST FOR 6 MORE TREATMENTS FOR 3PATS, 2 MORE PLANNEDAPPTS
var seedData3 = File.ReadAllText(@"..\..\Resources\kpi13pendingtreatmentsPT3.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData3);
patsFor13 = StretchKPICustomForm.GetPatients(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
KPIPendingTreatments.getPatQuery());
Assert.AreEqual(3, patsFor13.Rows.Count);
plannedAppsFor13 = KPIPendingTreatments.GetPendingTreatmentProcsPerPat(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
"1302");
Assert.AreEqual(3, plannedAppsFor13.Rows.Count);
plannedAppsFor13 = KPIPendingTreatments.GetPendingTreatmentProcsPerPat(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
"1303");
Assert.AreEqual(3, plannedAppsFor13.Rows.Count);
// TEST FOR 3 LESS TREATMENTS FOR 3PATS, 1 MORE SCHEDULEDAPPT
var seedData4 = File.ReadAllText(@"..\..\Resources\kpi13pendingtreatmentsPT4.txt");
DatabaseTools.ExecuteSqlScript("localhost", "3306", "root", "", seedData4);
patsFor13 = StretchKPICustomForm.GetPatients(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
KPIPendingTreatments.getPatQuery());
Assert.AreEqual(2, patsFor13.Rows.Count);
plannedAppsFor13 = KPIPendingTreatments.GetPendingTreatmentProcsPerPat(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
"1302");
Assert.AreEqual(0, plannedAppsFor13.Rows.Count);
plannedAppsFor13 = KPIPendingTreatments.GetPendingTreatmentProcsPerPat(
Convert.ToDateTime("2016-03-20"), Convert.ToDateTime("2017-04-05"),
"1303");
Assert.AreEqual(3, plannedAppsFor13.Rows.Count);
}
