static void DeletePatient(HospitalDB db, int id)
{
var tmp = db.Patients.Where(a => a.PatientID == id);
var oldValue = db.Patients.Where(a => a.PatientID == id);
db.Patients.RemoveRange(oldValue);
db.SaveChanges();
}
static void UpdatePatient(HospitalDB db, int id, Patient patient)
{
Patient oldValue = db.Patients.Where(a => a.PatientID == id).First();
oldValue.FullName = patient.FullName;
oldValue.Address = patient.Address;
oldValue.Chamber = patient.Chamber;
oldValue.Diagnosis = patient.Diagnosis;
oldValue.AttendingDoctorID = patient.AttendingDoctorID;
oldValue.ArrivalData = patient.ArrivalData;
oldValue.StatementData = patient.StatementData;
db.SaveChanges();
}
static void AddPatient(HospitalDB db, Patient patient)
{
db.Patients.Add(patient);
db.SaveChanges();
}
static public void Inicialize(HospitalDB db)
{
db.Database.EnsureCreated();
if (db.HospitalDepartments.Any())
{
return;
}
List <string> names = new List <string>(new string[] {
"HospitalDepartment_1", "HospitalDepartment_2", "HospitalDepartment_3"
});
Random rand = new Random();
foreach (string name in names)
{
db.HospitalDepartments.Add(new HospitalDepartment
{
NameOfDepartment = name,
Capacity = rand.Next(10, 20)
});
}
db.SaveChanges();
names = new List <string>(new string[] {
"Doctor_1", "Doctor_2", "Doctor_3", "Doctor_4", "Doctor_5", "Doctor_6"
});
int k = 0;
foreach (string name in names)
{
db.Doctors.Add(new Doctor
{
DoctorName = name,
HospitalDepartmentID = rand.Next(1, 4),
Specialty = "sp" + (k % 3).ToString(),
Category = "ctgr" + (k % 3).ToString()
});
k++;
}
db.SaveChanges();
names = new List <string>(new string[] {
"Patient_1", "Patient_2", "Patient_3", "Patient_4", "Patient_5", "Patient_6",
"Patient_7", "Patient_8", "Patient_9", "Patient_10", "Patient_11", "Patient_12"
});
DateTime today = DateTime.Now.Date;
k = 0;
foreach (string name in names)
{
db.Patients.Add(new Patient
{
FullName = name,
Address = "adress",
Chamber = rand.Next(10, 40),
Diagnosis = "",
AttendingDoctorID = rand.Next(1, 7),
ArrivalData = today.AddDays(-k),
StatementData = new DateTime()
});
k++;
}
db.SaveChanges();
}
