public void AddSpeciment(List <SpecimentsInOrder> listSpeciments)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <SpecimentsInOrder, int> specimentDao = new GenericDaoImpl <SpecimentsInOrder, int>(SF.GetSession());
GenericDaoImpl <OrderOfPatient, int> orderDao = new GenericDaoImpl <OrderOfPatient, int>(SF.GetSession());
GenericDaoImpl <Speciment, int> specimentNameDao = new GenericDaoImpl <Speciment, int>(SF.GetSession());
GenericDaoImpl <SpecimentStatus, int> specimentStatusDao = new GenericDaoImpl <SpecimentStatus, int>(SF.GetSession());
OrderOfPatient order = new OrderOfPatient();
Speciment specimentName = new Speciment();
SpecimentStatus specimentStatus = new SpecimentStatus();
foreach (SpecimentsInOrder item in listSpeciments)
{
order = orderDao.Get(item.Order.ID_Order);
specimentName = specimentNameDao.Get(item.Speciment.ID_Speciment);
specimentStatus = specimentStatusDao.Get(item.SpecimentStatus.ID_SpecimentStatus);
item.Order = order;
item.Speciment = specimentName;
item.SpecimentStatus = specimentStatus;
item.Status = 1;
specimentDao.Save(item);
}
SF.CloseSession();
}
public void UpdateSpeciment(List <SpecimentsInOrder> listSpeciments)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <SpecimentsInOrder, int> specimentDao = new GenericDaoImpl <SpecimentsInOrder, int>(SF.GetSession());
GenericDaoImpl <OrderOfPatient, int> orderDao = new GenericDaoImpl <OrderOfPatient, int>(SF.GetSession());
GenericDaoImpl <Speciment, int> specimentNameDao = new GenericDaoImpl <Speciment, int>(SF.GetSession());
GenericDaoImpl <SpecimentStatus, int> specimentStatusDao = new GenericDaoImpl <SpecimentStatus, int>(SF.GetSession());
OrderOfPatient order = new OrderOfPatient();
Speciment specimentName = new Speciment();
SpecimentStatus specimentStatus = new SpecimentStatus();
foreach (SpecimentsInOrder item in listSpeciments)
{
order = orderDao.Get(item.Order.ID_Order);
specimentName = specimentNameDao.Get(item.Speciment.ID_Speciment);
specimentStatus = specimentStatusDao.Get(item.SpecimentStatus.ID_SpecimentStatus);
SpecimentsInOrder sp = specimentDao.Get(item.ID_SpecimentOrder);
sp.DateOfTaking = item.DateOfTaking;
sp.Nurse = item.Nurse;
sp.Order = order;
sp.Speciment = specimentName;
sp.SpecimentStatus = specimentStatus;
specimentDao.Save(sp);
}
SF.CloseSession();
}
public void UpdateOrder(List <OrderOfPatient> listOrders)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <OrderOfPatient, int> orderDao = new GenericDaoImpl <OrderOfPatient, int>(SF.GetSession());
GenericDaoImpl <OrderStatus, int> orderStatusDao = new GenericDaoImpl <OrderStatus, int>(SF.GetSession());
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
GenericDaoImpl <Doctor, int> doctorDao = new GenericDaoImpl <Doctor, int>(SF.GetSession());
OrderStatus orderStatus = new OrderStatus();
Patient patient = new Patient();
Doctor doctor = new Doctor();
foreach (OrderOfPatient item in listOrders)
{
orderStatus = orderStatusDao.Get(item.OrderStatus.ID_OrderStatus);
patient = patientDao.Get(item.Patient.ID_Patient);
doctor = doctorDao.Get(item.Doctor.ID_Doctor);
OrderOfPatient ord = orderDao.Get(item.ID_Order);
ord.DateOrder = item.DateOrder;
ord.Symptoms = item.Symptoms;
ord.Patient = patient;
ord.Doctor = doctor;
ord.OrderStatus = orderStatus;
orderDao.Save(ord);
}
SF.CloseSession();
}
public SpecimentsInOrder GetDataSpeciment()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
int IdSpeciment = 2;
//вытягиваем все тесты для спесимента ,у которого id=2
GenericDaoImpl <SpecimentsInOrder, int> specimentDao = new GenericDaoImpl <SpecimentsInOrder, int>(SF.GetSession());
SpecimentsInOrder spec = specimentDao.Get(IdSpeciment);
spec.testsInOrderList = new List <int>();
TestsInOrderDaoImpl testDao = new TestsInOrderDaoImpl(SF.GetSession());
foreach (TestsInOrder item in testDao.GetTestsOfSpeciment(IdSpeciment).ToList())
{
spec.testsInOrderList.Add(item.ID_TestOrder);
}
SF.CloseSession();
return(spec);
}
public void UpdateTest(List <TestsInOrder> listTests)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <TestsInOrder, int> testDao = new GenericDaoImpl <TestsInOrder, int>(SF.GetSession());
GenericDaoImpl <Test, int> testNameDao = new GenericDaoImpl <Test, int>(SF.GetSession());
GenericDaoImpl <TestStatus, int> testStatusDao = new GenericDaoImpl <TestStatus, int>(SF.GetSession());
Test testName = new Test();
TestStatus testStatus = new TestStatus();
foreach (TestsInOrder item in listTests)
{
testName = testNameDao.Get(item.Test.ID_Test);
testStatus = testStatusDao.Get(item.TestStatus.ID_TestStatus);
TestsInOrder tst = testDao.Get(item.ID_TestOrder);
tst.DateStart = item.DateStart;
tst.Result = item.Result;
tst.Test = testName;
tst.TestStatus = testStatus;
testDao.Save(tst);
}
SF.CloseSession();
}
public void DeleteTest(List <TestsInOrder> listTests)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
TestsInOrderDaoImpl testDao = new TestsInOrderDaoImpl(SF.GetSession());
GenericDaoImpl <Test, int> testNameDao = new GenericDaoImpl <Test, int>(SF.GetSession());
GenericDaoImpl <TestStatus, int> testStatusDao = new GenericDaoImpl <TestStatus, int>(SF.GetSession());
Test testName = new Test();
TestStatus testStatus = new TestStatus();
foreach (TestsInOrder itemTest in listTests)
{
testName = testNameDao.Get(itemTest.Test.ID_Test);
testStatus = testStatusDao.Get(itemTest.TestStatus.ID_TestStatus);
itemTest.Test = testName;
itemTest.TestStatus = testStatus;
itemTest.Status = 0;
testDao.SaveOrUpdate(itemTest);
}
SF.CloseSession();
}
public List <Relative> GetRelativesOfPatient(Patient patient)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
Patient p = patientDao.Get(patient.ID_Patient);
p.relativeList = new List <int>();
RelativeDaoImpl relativeDao = new RelativeDaoImpl(SF.GetSession());
List <Relative> tempList = relativeDao.GetListRelativesOfPatient(patient.ID_Patient).ToList();
if (tempList.Count > 0)
{
foreach (Relative item in tempList)
{
p.relativeList.Add(item.ID_Relative);
}
}
SF.CloseSession();
return(tempList);
}
public void AddPatient(List <Patient> listPatients)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
GenericDaoImpl <Gender, int> genderDao = new GenericDaoImpl <Gender, int>(SF.GetSession());
Gender male = genderDao.Get(1);
Gender female = genderDao.Get(2);
foreach (Patient item in listPatients)
{
if (item.Gender.ID_Gender == male.ID_Gender)
{
item.Gender = male;
}
else if (item.Gender.ID_Gender == female.ID_Gender)
{
item.Gender = female;
}
item.Status = 1;
patientDao.Save(item);
}
SF.CloseSession();
}
public void UpdatePatient(List <Patient> listPatients)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
GenericDaoImpl <Gender, int> genderDao = new GenericDaoImpl <Gender, int>(SF.GetSession());
Gender male = genderDao.Get(1);
Gender female = genderDao.Get(2);
foreach (Patient item in listPatients)
{
Patient p = patientDao.Get(item.ID_Patient);
p.Lastname = item.Lastname;
p.Firstname = item.Firstname;
p.DOB = item.DOB;
p.SSN = item.SSN;
if (item.Gender.ID_Gender == male.ID_Gender)
{
p.Gender = male;
}
else if (item.Gender.ID_Gender == female.ID_Gender)
{
p.Gender = female;
}
patientDao.SaveOrUpdate(p);
}
SF.CloseSession();
}
public void DeleteSpeciment(List <SpecimentsInOrder> listSpeciments)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
SpecimentsInOrderDaoImpl specimentDao = new SpecimentsInOrderDaoImpl(SF.GetSession());
GenericDaoImpl <OrderOfPatient, int> orderDao = new GenericDaoImpl <OrderOfPatient, int>(SF.GetSession());
GenericDaoImpl <Speciment, int> specimentNameDao = new GenericDaoImpl <Speciment, int>(SF.GetSession());
GenericDaoImpl <SpecimentStatus, int> specimentStatusDao = new GenericDaoImpl <SpecimentStatus, int>(SF.GetSession());
TestsInOrderDaoImpl testDao = new TestsInOrderDaoImpl(SF.GetSession());
GenericDaoImpl <Test, int> testNameDao = new GenericDaoImpl <Test, int>(SF.GetSession());
GenericDaoImpl <TestStatus, int> testStatusDao = new GenericDaoImpl <TestStatus, int>(SF.GetSession());
List <TestsInOrder> listTest;
OrderOfPatient order = new OrderOfPatient();
Speciment specimentName = new Speciment();
SpecimentStatus specimentStatus = new SpecimentStatus();
Test testName = new Test();
TestStatus testStatus = new TestStatus();
foreach (SpecimentsInOrder itemSpec in listSpeciments)
{
order = orderDao.Get(itemSpec.Order.ID_Order);
specimentName = specimentNameDao.Get(itemSpec.Speciment.ID_Speciment);
specimentStatus = specimentStatusDao.Get(itemSpec.SpecimentStatus.ID_SpecimentStatus);
itemSpec.Order = order;
itemSpec.Speciment = specimentName;
itemSpec.SpecimentStatus = specimentStatus;
itemSpec.Status = 0;
specimentDao.SaveOrUpdate(itemSpec);
listTest = testDao.GetTestsOfSpeciment(itemSpec.ID_SpecimentOrder).ToList();
if (listTest.Count > 0)
{
foreach (TestsInOrder itemTest in listTest)
{
testName = testNameDao.Get(itemTest.Test.ID_Test);
testStatus = testStatusDao.Get(itemTest.TestStatus.ID_TestStatus);
itemTest.Test = testName;
itemTest.TestStatus = testStatus;
itemTest.Status = 0;
testDao.SaveOrUpdate(itemTest);
}
}
}
SF.CloseSession();
}
public int SaveRelative(Relative relative)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Relative, int> relativeDao = new GenericDaoImpl <Relative, int>(SF.GetSession());
int id = (relativeDao.Save(relative)).ID_Relative;
SF.CloseSession();
return(id);
}
public OrderOfPatient GetDataOrder()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <OrderOfPatient, int> orderDao = new GenericDaoImpl <OrderOfPatient, int>(SF.GetSession());
OrderOfPatient ord = orderDao.Get(2);
SF.CloseSession();
return(ord);
}
public List <TestStatus> GetDataTestStatus()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <TestStatus, int> testStatusDao = new GenericDaoImpl <TestStatus, int>(SF.GetSession());
List <TestStatus> list = new List <TestStatus>();
list = testStatusDao.GetAll().ToList();
SF.CloseSession();
return(list);
}
public List <Doctor> GetDataAllDoctors()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Doctor, int> doctorDao = new GenericDaoImpl <Doctor, int>(SF.GetSession());
List <Doctor> list = new List <Doctor>();
list = doctorDao.GetAll().ToList();
SF.CloseSession();
return(list);
}
public List <Gender> GetDataGender()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Gender, int> genderDao = new GenericDaoImpl <Gender, int>(SF.GetSession());
List <Gender> list = new List <Gender>();
list = genderDao.GetAll().ToList();
SF.CloseSession();
return(list);
}
public List <Speciment> GetDataSpecimentName()
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Speciment, int> specimentNameDao = new GenericDaoImpl <Speciment, int>(SF.GetSession());
List <Speciment> list = new List <Speciment>();
list = specimentNameDao.GetAll().ToList();
SF.CloseSession();
return(list);
}
public Patient GetDataPatient(int IdPatient)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
Patient p = patientDao.Get(IdPatient);
//p.orderOfPatientList = new List<int>();
//OrderOfPatientDaoImpl orderDao = new OrderOfPatientDaoImpl(SF.GetSession());
//foreach (OrderOfPatient item in orderDao.GetOrdersOfPatient(IdPatient).ToList())
//{
// p.orderOfPatientList.Add(item.ID_Order);
//}
SF.CloseSession();
return(p);
}
public void DeletePatient(List <Patient> listPatients)
{
SessionFactory SF = new SessionFactory();
SF.Init();
SF.OpenSession();
GenericDaoImpl <Patient, int> patientDao = new GenericDaoImpl <Patient, int>(SF.GetSession());
RelativeDaoImpl relativeDao = new RelativeDaoImpl(SF.GetSession());
OrderOfPatientDaoImpl orderDao = new OrderOfPatientDaoImpl(SF.GetSession());
SpecimentsInOrderDaoImpl specimentDao = new SpecimentsInOrderDaoImpl(SF.GetSession());
TestsInOrderDaoImpl testDao = new TestsInOrderDaoImpl(SF.GetSession());
GenericDaoImpl <Gender, int> genderDao = new GenericDaoImpl <Gender, int>(SF.GetSession());
List <Relative> listRel;
List <OrderOfPatient> listOrd;
List <SpecimentsInOrder> listSpec;
List <TestsInOrder> listTest;
Gender male = genderDao.Get(1);
Gender female = genderDao.Get(2);
foreach (Patient patient in listPatients)
{
if (patient.Gender.ID_Gender == male.ID_Gender)
{
patient.Gender = male;
}
else if (patient.Gender.ID_Gender == female.ID_Gender)
{
patient.Gender = female;
}
listRel = relativeDao.GetListRelativesOfPatient(patient.ID_Patient).ToList();
listOrd = orderDao.GetOrdersOfPatient(patient.ID_Patient).ToList();
if (listRel.Count == 0 && listOrd.Count == 0)
{
patientDao.Delete(patient);
}
else if (listRel.Count > 0 || listOrd.Count > 0)
{
if (listRel.Count > 0)
{
foreach (Relative item in listRel)
{
item.Status = 0;
relativeDao.SaveOrUpdate(item);
}
}
if (listOrd.Count > 0)
{
foreach (OrderOfPatient item in listOrd)
{
item.Status = 0;
orderDao.SaveOrUpdate(item);
listSpec = specimentDao.GetSpecimentsOfOrder(item.ID_Order).ToList();
if (listSpec.Count > 0)
{
foreach (SpecimentsInOrder itemSpec in listSpec)
{
itemSpec.Status = 0;
specimentDao.SaveOrUpdate(itemSpec);
listTest = testDao.GetTestsOfSpeciment(itemSpec.ID_SpecimentOrder).ToList();
if (listTest.Count > 0)
{
foreach (TestsInOrder itemTest in listTest)
{
itemTest.Status = 0;
testDao.SaveOrUpdate(itemTest);
}
}
}
}
}
}
patient.Status = 0;
patientDao.SaveOrUpdate(patient);
}
}
SF.CloseSession();
}