public void InitializeDataBase()
{
// Ez a db server beállítása, a file conn stringet benthagyom arra az esetre, ha később kellene...
string connStr = @"Data Source=193.224.69.39,1433;Initial Catalog=HubaskyDataBase06;User ID=sa;Password=szoftech;Pooling=False";
ApplicationDb = new HubaskyDataBase(connStr);
// Ha még nem létezik az adatbázis, akkor default inicializáció:
if (ApplicationDb.Hospital.FirstOrDefault() == null)
{
// Default kórház
Hospital hosp = new Hospital();
hosp.Name = "Hubasky Magánkórház";
hosp.Address = "1234 Budapest, Gyógyító tér 1.";
hosp.Phone = "+36556667788";
hosp.Email = "*****@*****.**";
hosp.Web = "hubasky.hu";
ApplicationDb.Hospital.Add(hosp);
// Default admin user
Employee admin = new Employee("admin", ApplicationManager.CalculateSHA256("1234"), 100000.0, Role.Administrator, "Adminisztrátor", "-", "-", "-");
hosp.Employees.Add(admin);
ApplicationDb.SaveChanges();
}
}
private static void PopulateUnits(ApplicationManager appMgr)
{
Employee hospMgr = null;
var hosps = appMgr.ApplicationDb.Hospital.Select(m => m);
foreach (Hospital hosp in hosps)
{
hosp.Departments = new List<Department>();
}
var wards = appMgr.ApplicationDb.Wards.Select(w => w);
appMgr.ApplicationDb.Wards.RemoveRange(wards);
var depts = appMgr.ApplicationDb.Departments.Select(d => d);
appMgr.ApplicationDb.Departments.RemoveRange(depts);
appMgr.ApplicationDb.Hospital.RemoveRange(hosps);
var emps = appMgr.ApplicationDb.Employees.Select(m => m).ToList();
Hospital hospital = new Hospital();
hospital.Address = "1234 Budapest, Gyógyító köz 1.";
foreach (Employee emp in emps)
{
if ("eszti".Equals(emp.Username))
{
hospMgr = emp;
}
}
hospital.Manager = hospMgr;
hospital.Name = "Hubasky Magánkórház";
hospital.Employees = emps;
Department patientTreatDept = new Department();
patientTreatDept.Name = "Betegellátási főosztály";
hospital.Departments.Add(patientTreatDept);
//appMgr.ApplicationDb.Departments.Add(patientTreatDept);
Department surgeryDept = new Department();
surgeryDept.Name = "Sebészeti főosztály";
hospital.Departments.Add(surgeryDept);
//appMgr.ApplicationDb.Departments.Add(surgeryDept);
Department testDept = new Department();
testDept.Name = "Teszt főosztály";
hospital.Departments.Add(testDept);
//appMgr.ApplicationDb.Departments.Add(test);
List<Department> deptList = new List<Department>();
deptList.Add(patientTreatDept);
deptList.Add(surgeryDept);
deptList.Add(testDept);
appMgr.ApplicationDb.Departments.AddRange(deptList);
XmlReader xmlReader = new XmlReader();
int length = xmlReader.Wards.Count();
List<Ward> wardList = new List<Ward>();
List<Employee> empList = new List<Employee>();
for (int i = 0; i < length-1; i++)
{
//wardList.Add(new Ward(i, xmlReader.Wards.ElementAt(i),
// emps[i % 5], emps.Where(x => x.Username.Equals("Teszt" + i)).ToList(),
// xmlReader.Procedures));
}
appMgr.ApplicationDb.Wards.Union(wardList);
patientTreatDept.Wards.AddRange(wardList.GetRange(0, 8));
surgeryDept.Wards.AddRange(wardList.GetRange(8, 8));
testDept.Wards.AddRange(wardList.GetRange(16, 8));
/*Ward walkInPatientWard = new Ward();
walkInPatientWard.Name = "Járóbetegellátás";
walkInPatientWard.Manager = emps[0];
walkInPatientWard.Employees = emps;
appMgr.ApplicationDb.Wards.Add(walkInPatientWard);
Ward cardiologyWard = new Ward();
cardiologyWard.Name = "Kardiológia";
cardiologyWard.Manager = emps[1];
appMgr.ApplicationDb.Wards.Add(cardiologyWard);*/
/*patientTreatDept.Wards.Add(walkInPatientWard);
patientTreatDept.Wards.Add(cardiologyWard);*/
appMgr.ApplicationDb.Hospital.Add(hospital);
appMgr.ApplicationDb.SaveChanges();
}
