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