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(); }