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(); } }
public static void createPatient(User user) { DbServices.Role role = db.TableRole.Where(r => r.Name == RolesKind.PATIENT).FirstOrDefault(); var userWcf = new DbServices.User { FstName = user.FstName, Surname = user.Surname, Email = user.Email, Pass = user.Pass, Pesel = user.Pesel, Roles = { role } }; var patient = new DbServices.Patient(); patient.Pesel = user.Pesel; try { db.AddToTablePatient(patient); db.AddRelatedObject(role, "Users", userWcf); DataServiceResponse response = db.SaveChanges(); foreach (ChangeOperationResponse change in response) { EntityDescriptor descriptor = change.Descriptor as EntityDescriptor; if (descriptor != null) { DbServices.User added = descriptor.Entity as DbServices.User; if (added != null) { Console.WriteLine("New patient added with email {0}.", added.Email); } } } } catch (DataServiceRequestException ex) { throw new ApplicationException( "An error occurred when saving changes.", ex); } }