//add button handling
        private void Add_Click(object sender, RoutedEventArgs e)
        {
            using (DataModel db = new DataModel())
            {
                //Add MedicalDoc
                if (IdMedicalDoc == 0)
                {
                    MedicalDoc medicalDoc = new MedicalDoc
                    {
                        Name             = TxBxName.Text.Trim(),
                        PatientId        = IdPacient,
                        MedicalDocTypeId = db.MedicalDocTypes.Where(a => a.Name == ComboType.SelectedValue.ToString()).FirstOrDefault().Id,
                        BeginTime        = (DateTime)DateBegin.SelectedDate,
                        EndTime          = DateEnd.SelectedDate,
                        Info             = TxBxInfo.Text.Trim()
                    };
                    db.MedicalDocs.Add(medicalDoc);
                }
                else
                {
                    //Edit MedicalDoc
                    db.MedicalDocs.Where(x => x.Id == IdMedicalDoc).FirstOrDefault().Name             = (TxBxName.Text).Trim();
                    db.MedicalDocs.Where(x => x.Id == IdMedicalDoc).FirstOrDefault().MedicalDocTypeId = db.MedicalDocTypes.Where(a => a.Name == ComboType.SelectedValue.ToString()).FirstOrDefault().Id;
                    db.MedicalDocs.Where(x => x.Id == IdMedicalDoc).FirstOrDefault().BeginTime        = (DateTime)DateBegin.SelectedDate;
                    db.MedicalDocs.Where(x => x.Id == IdMedicalDoc).FirstOrDefault().EndTime          = DateEnd.SelectedDate;
                    db.MedicalDocs.Where(x => x.Id == IdMedicalDoc).FirstOrDefault().Info             = TxBxInfo.Text.Trim();
                }
                db.SaveChanges();
            }

            this.DialogResult = true;

            Close();
        }
Beispiel #2
0
 private void Test()
 {
     using (DataModel db = new DataModel())
     {
         MedicalDoc doc = db.MedicalDocs.FirstOrDefault(d => d.Id == 1);
         MessageBox.Show(doc.Patient.FirstName);
     }
 }
 //init windows with two parameters
 private void InitEdit()
 {
     using (DataModel db = new DataModel())
     {
         //check the patient's presence
         Patient pac = new Patient();
         pac = db.Pacients.Where(a => a.Id == IdPacient).FirstOrDefault();
         if (pac == null)
         {
             MessageBox.Show("Pacient not found");
             Close();
         }
         //init combo Type
         foreach (var item in db.MedicalDocTypes.ToList())
         {
             ComboType.Items.Add(item.Name);
         }
         //document verification
         MedicalDoc medicalDocType = new MedicalDoc();
         medicalDocType = db.MedicalDocs.Where(a => a.Id == IdMedicalDoc).FirstOrDefault();
         if (medicalDocType == null)
         {
             MessageBox.Show("document not found");
             Close();
         }
         //filling fields
         foreach (var item in ComboType.Items)
         {
             if (item.ToString() == db.MedicalDocTypes.Where(a => a.Id == medicalDocType.MedicalDocTypeId).FirstOrDefault().Name)
             {
                 ComboType.SelectedItem = item as ComboBoxItem;
                 ComboType.Text         = item.ToString();
             }
         }
         TxBxName.Text          = medicalDocType.Name;
         TxBxInfo.Text          = medicalDocType.Info;
         DateBegin.SelectedDate = medicalDocType.BeginTime;
         DateEnd.SelectedDate   = medicalDocType.EndTime;
     }
 }