public static void addIlnnessToDb(SharedModels.IllnessModel illness)
{
var illDb = db.TableIllness.Where(i => i.Name == illness.Name).ToList();
var ilnessDb = new DbServices.Illness();
if (illDb.Count == 0)
{
ilnessDb.Name = illness.Name;
db.AddToTableIllness(ilnessDb);
db.SaveChanges();
}
else
{
ilnessDb = illDb.First();
}
var pWasSick = new DbServices.PatientWasSick
{
Date = illness.Date,
Description = illness.Description,
PatientId = illness.IdPatient,
Illness = ilnessDb,
IllnessId = ilnessDb.Id
};
db.AddToTablePatientWasSick(pWasSick);
db.SetLink(pWasSick, "Illness", ilnessDb);
db.SaveChanges();
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (TBIllness.Text.CompareTo("") != 0 && datePicker1.Text.CompareTo("") != 0)
{
int day = int.Parse(datePicker1.Text.Substring(0, 2));
int month = int.Parse(datePicker1.Text.Substring(3, 2));
int year = int.Parse(datePicker1.Text.Substring(6, 4));
DateTime dt = new DateTime(year, month, day);
Illness illness = new Illness(TBIllness.Text, dt, TBDesc.Text);
if (illnesses.myIllnesses == null)
{
illnesses.myIllnesses = new List <Illness>();
}
if (UserPersister.User != null)
{
var patientDb = db.TablePatient.Where(i => i.Pesel == UserPersister.User.Pesel);
var illDb = db.TableIllness.Where(i => i.Name == illness.Name).ToList();
var ilnessDb = new DbServices.Illness();
if (illDb.Count == 0)
{
ilnessDb.Name = illness.Name;
db.AddToTableIllness(ilnessDb);
db.SaveChanges();
}
else
{
ilnessDb = illDb.First();
}
var pWasSick = new DbServices.PatientWasSick
{
Date = illness.Date,
Illness = ilnessDb,
IllnessId = ilnessDb.Id,
PatientId = patientDb.First().Id,
Description = illness.Description
};
db.AddToTablePatientWasSick(pWasSick);
db.SetLink(pWasSick, "Illness", ilnessDb);
db.SaveChanges();
}
illnesses.myIllnesses.Add(illness);
Close();
}
}