private void save_Click(object sender, RoutedEventArgs e) { var name = txName.Text.Trim(); var surname = txSurname.Text.Trim(); var phone = txPhone.Text.Trim(); var adres = txAdress.Text.Trim(); var tc = txTc.Text.Trim(); if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(surname) || string.IsNullOrEmpty(phone) || string.IsNullOrEmpty(adres) || string.IsNullOrEmpty(tc) || string.IsNullOrEmpty(pickbirthDay.Text)) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } var birthday = DateTime.ParseExact(pickbirthDay.Text.ToString(), "d.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture); ProgressOn(); using (var db = new DentistDbEntities()) { //insert if (updateDoktor.ID == 0) { var model = db.Doctors.Add(db.Doctors.Create()); model.NAME = name; model.SURNAME = surname; model.BIRTHDAY = birthday; model.PHONE = phone; model.ADRESS = adres; model.PERSONELID = tc; db.SaveChanges(); } //update else { var model = db.Doctors.SingleOrDefault(row => row.ID == updateDoktor.ID); model.NAME = name; model.SURNAME = surname; model.BIRTHDAY = birthday; model.PHONE = phone; model.ADRESS = adres; model.PERSONELID = tc; db.SaveChanges(); } } ProgressOf(); DialogHost.CloseDialogCommand.Execute(false, null); }
private void Delete_Click(object sender, RoutedEventArgs e) { ProgressOn(); Patient clickedDoctor = ((FrameworkElement)sender).DataContext as Patient; using (var db = new DentistDbEntities()) { var query = db.Patients.SingleOrDefault(x => x.ID == clickedDoctor.ID); query.ISDELETE = true; db.SaveChanges(); } ProgressOf(); getList(); }
private void Delete_Click(object sender, RoutedEventArgs e) { ProgressOn(); VW_Appointment clickedDoctor = ((FrameworkElement)sender).DataContext as VW_Appointment; using (var db = new DentistDbEntities()) { var query = db.Appointments.SingleOrDefault(x => x.ID == clickedDoctor.ID); db.Appointments.Attach(query); db.Appointments.Remove(query); db.SaveChanges(); } ProgressOf(); getList(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(txEmail.Text) || string.IsNullOrEmpty(txName.Text) || string.IsNullOrEmpty(txSurname.Text) || string.IsNullOrEmpty(txUsername.Text)) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } ProgressOn(); using (var db = new DentistDbEntities()) { var model = db.Users.SingleOrDefault(row => row.ID == user.ID); model.NAME = txName.Text; model.SURNAME = txSurname.Text; model.USERNAME = txUsername.Text; model.EMAIL = txEmail.Text; db.SaveChanges(); user = Shared.OnlineUser = model; MessageBox.Show("Başarılı İşlem.", ""); } ProgressOf(); }
private void save_Click(object sender, RoutedEventArgs e) { if ((comboDoctor.SelectedItem) == null) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } if ((comboHasta.SelectedItem) == null) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } if ((comboType.SelectedItem) == null) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } if ((comboHour.SelectedItem) == null) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } var price = txPrice.Text.Trim(); var desc = txDescription.Text.Trim(); var doctor = ((SimpleModel)comboDoctor.SelectedItem).ID; var patient = ((SimpleModel)comboHasta.SelectedItem).ID; var type = ((SimpleModel)comboType.SelectedItem).NAME; var hour = ((SimpleModel)comboHour.SelectedItem).ID; var isPaid = chPaid.IsChecked; var isCame = chCame.IsChecked; if (string.IsNullOrEmpty(price) || string.IsNullOrEmpty(desc) || string.IsNullOrEmpty(pickerDate.Text)) { MessageBox.Show("Lütfen Bütün Alanları Doldurunuz.", ""); return; } var date = DateTime.ParseExact(pickerDate.Text.ToString(), "d.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture); ProgressOn(); using (var db = new DentistDbEntities()) { //insert if (updateAppointment.ID == 0) { var model = db.Appointments.Add(db.Appointments.Create()); model.DOCTORID = doctor; model.PATIENTID = patient; model.DATE = date; model.HOUR = hour; model.PRICE = decimal.Parse(price); model.ISCAME = (bool)isCame; model.ISPAID = (bool)isPaid; model.TYPE = type; model.DESCRIPTION = desc; db.SaveChanges(); } //update else { var model = db.Appointments.SingleOrDefault(row => row.ID == updateAppointment.ID); model.DOCTORID = doctor; model.PATIENTID = patient; model.DATE = date; model.HOUR = hour; model.PRICE = decimal.Parse(price); model.ISCAME = (bool)isCame; model.ISPAID = (bool)isPaid; model.TYPE = type; model.DESCRIPTION = desc; db.SaveChanges(); } } ProgressOf(); DialogHost.CloseDialogCommand.Execute(false, null); }