public void PatientsDBTest()
{
PatientsDB temp = new PatientsDB("tempdb_path");
Assert.IsNotNull(temp);
Assert.IsTrue(temp.ConnectionString == "tempdb_path");
}
public List <Patient> SetPriority()
{
var patients = PatientsDB.GetDataFromPatientsTable();
patients.ForEach(x => x.Status = 1);
switch (Helper.algorytm)
{
case 1:
return(Priority.CountPriorityBasedOnGlasgowScale(patients));
case 2:
return(Priority.CountPriorityBasedOnFOURScale(patients));
case 3:
return(Priority.CountPriorityBasedOnMETTS(patients));
case 4:
return(Priority.CountPriorityBasedOnSCON(patients));
case 5:
return(Priority.CountPriorityBasedOnSREN(patients));
case 6:
return(Priority.CountPriorityBasedOnMIXED(patients));
default:
return(null);
}
}
public void NewPatientFromDB(int patientCount)
{
Random random = new Random();
var itemsCount = PatientsDB.GetNumbersOfRowInTable("SavedPatients");
var idsSavedPatients = PatientsDB.GetDataFromSavedPatientsTable();
for (int patient = 0; patient < patientCount; patient++)
{
PatientsDB.TransferRecordFromSavedPatientTableById(idsSavedPatients.ElementAt(random.Next(1, itemsCount)).Id);
}
}
public void PatientDB_CleanTest()
{
/*FIXME: Pass connection string for testdb */
PatientsDB db = new PatientsDB();
List <Patient> plist;
db.Clear();
plist = db.GetPatientsInfo();
Assert.IsNotNull(plist);
Assert.IsTrue(plist.Count == 0);
}
public void PatientsDB_AddPatientTest()
{
PatientsDB db = new PatientsDB();
List <Patient> plist_read;
db.Clear();
Patient p_in = new Patient();
p_in.Name = "test patient";
p_in.DoB = new DateTime(2000, 10, 10);
p_in.Address = "test Address";
p_in.AddTestInfo(new TestInfo("test_type", new DateTime(1999, 10, 11), "test_instrument", "test_results"));
db.SavePatient(p_in);
plist_read = db.GetPatientsInfo();
Assert.IsTrue(plist_read.Count == 1);
Assert.IsTrue(plist_read[0].Name == p_in.Name);
Assert.IsTrue(System.DateTime.Compare(plist_read[0].DoB, p_in.DoB) == 0);
Assert.IsTrue(plist_read[0].Tests.Count == p_in.Tests.Count);
/* Add New test results */
p_in.AddTestInfo(new TestInfo("test_type2", new DateTime(1992, 10, day: 12), "new_instrument", "new_resuts"));
db.SavePatient(p_in);
plist_read = db.GetPatientsInfo();
Assert.IsTrue(plist_read.Count == 1);
Assert.IsTrue(plist_read[0].Tests.Count == 2);
/* Add One more object */
p_in = new Patient();
p_in.Name = "test patient1";
p_in.DoB = new DateTime(1900, 1, 1);
p_in.Address = "test Address 1";
p_in.AddTestInfo(new TestInfo("test_type1", new DateTime(1999, 10, 11), "test_instrument1", "test_results1"));
db.SavePatient(p_in);
plist_read = db.GetPatientsInfo();
Assert.IsTrue(plist_read.Count == 2);
Assert.IsTrue(plist_read[0].Tests.Count == 2);
Assert.IsTrue(plist_read[1].Tests.Count == 1);
}
public static void Add_Patient_Orange(int patientCount)
{
string[] name = { "Ania", "Anita", "Adam", "Adriam", "Bartosz", "Bartłmiej", "Barbara", "Bianka", "Celina", "Cycylia", "Czesław" };
string[] surname = { "Kowalski", "Wybicki", "Lama", "Nowak", "Kruszek", "Fretowski", "Gołebiowski" };
Random random;
for (int i = 0; i < patientCount; i++)
{
random = new Random();
var PatientName = name[random.Next(0, 10)] + " " + surname[random.Next(0, 6)];
var Plec = random.Next(0, 1);
var DrogiOddechowe = 0;
var CzestoscOddechow = random.Next(26, 29);
var Pulsoksymetria = random.Next(100, 110);
var Tetno = random.Next(121, 129);
var CisnienieKrwi = random.Next(100, 110);
var Disability = 3;
var Temperatura = (Math.Round(random.NextDouble() * (43 - 41) + 41, 1)).ToString().Replace(',', '.');
var GSC = random.Next(5, 8);
var Four = random.Next(5, 8);
Patient patient = new Patient()
{
PatientName = PatientName,
GSC = GSC,
Temperature = Temperatura,
Inspection = DrogiOddechowe,
RLS = Disability,
RR = CzestoscOddechow,
POX = Pulsoksymetria,
HR = Tetno,
BP = CisnienieKrwi,
Four = Four,
Sex = Plec,
Priority = 0,
Status = 0
};
PatientsDB.PostDataInPatientsTable(patient);
}
}
public void GeneratePatientBasedOnData(IFormCollection formData)
{
var PatientName = formData["PatientName"];
var Plec = Convert.ToInt32(formData["Plec"]);
var DrogiOddechowe = Convert.ToInt32(formData["DrogiOddechowe"]);
var CzestoscOddechow = Convert.ToInt32(formData["CzestoscOddechow"]);
var Pulsoksymetria = Convert.ToInt32(formData["Pulsoksymetria"]);
var Tetno = Convert.ToInt32(formData["Tetno"]);
var CisnienieKrwi = Convert.ToInt32(formData["CisnienieKrwi"]);
var Disability = Convert.ToInt32(formData["Disability"]);
var Temperatura = (Convert.ToDouble(formData["Temperatura"])).ToString();
var KontaktSlowny = Convert.ToInt32(formData["KontaktSlowny"].ToString().Substring(2, 1));
var OtwieranieOczu = Convert.ToInt32(formData["OtwieranieOczu"].ToString().Substring(2, 1));
var ReakcjaRuchowa = Convert.ToInt32(formData["ReakcjaRuchowa"].ToString().Substring(2, 1));
var OdruchyPniaMózgu = Convert.ToInt32(formData["OdruchyPniaMózgu"].ToString().Substring(2, 1));
var OtwieranieOczuFour = Convert.ToInt32(formData["OtwieranieOczu2"].ToString().Substring(2, 1));
var OdruchyOddychania = Convert.ToInt32(formData["OdruchyOddychania"].ToString().Substring(2, 1));
var ReakcjaRuchowaFour = Convert.ToInt32(formData["ReakcjaRuchowa2"].ToString().Substring(2, 1));
var GSC = KontaktSlowny + OtwieranieOczu + ReakcjaRuchowa;
var Four = ReakcjaRuchowaFour + OdruchyOddychania + OtwieranieOczuFour + OdruchyPniaMózgu;
Patient patient = new Patient()
{
PatientName = PatientName,
GSC = GSC,
Temperature = Temperatura.Replace(',', '.'),
Inspection = DrogiOddechowe,
RLS = Disability,
RR = CzestoscOddechow,
POX = Pulsoksymetria,
HR = Tetno,
BP = CisnienieKrwi,
Sex = Plec,
Four = Four,
Priority = 0,
Status = 0
};
PatientsDB.PostDataInPatientsTable(patient);
PatientsDB.PostDataInSavedPatientsTable(patient);
}
public void PriorityWithAddToQuery()
{
var newPatientsCount = random.Next(0, 15);
newPatients.GeneratePatientWithRandomData(newPatientsCount);
var lastAddedPatients = PatientsDB.GetLastAddedPatientFromPatientsTable(newPatientsCount);
lastAddedPatients.ForEach(x => { x.IfAdded = true; x.IfReturned = false; });
switch (Helper.algorytm)
{
case 1:
lastAddedPatients = Priority.CountPriorityBasedOnGlasgowScale(lastAddedPatients);
break;
case 2:
lastAddedPatients = Priority.CountPriorityBasedOnFOURScale(lastAddedPatients);
break;
case 3:
lastAddedPatients = Priority.CountPriorityBasedOnMETTS(lastAddedPatients);
break;
case 4:
lastAddedPatients = Priority.CountPriorityBasedOnSCON(lastAddedPatients);
break;
case 5:
lastAddedPatients = Priority.CountPriorityBasedOnSREN(lastAddedPatients);
break;
case 6:
lastAddedPatients = Priority.CountPriorityBasedOnMIXED(lastAddedPatients);
break;
}
lastAddedPatients.ForEach(x => x.Status = 1);
//dodanie do tabllicy
simulationProcess.UpdatePatientList(lastAddedPatients, false);
}
public int GetPatientCountInDB()
{
return(PatientsDB.GetNumbersOfRowInTable("Patients"));
}
public static void CleanTable()
{
PatientsDB.CleanTable();
}
