private void buttonDelete_Click(object sender, RoutedEventArgs e) { var row = (Patient)dataGridViewResult.SelectedItem; if (row == null) { return; } if (MessageBox.Show("Вы действительно хотите удалить этого пациента ? ", "Подтверждение удаления", MessageBoxButton.OKCancel) != MessageBoxResult.OK)//messageboxresult System.Windows.Forms.DialogResult { return; } try { //var patient = (Patient)row; //int patientId = patient.Id; UsersDataAccess.DeleteUserByPatientId(row.Id); dataGridViewResult.ItemsSource = PatientsDataAccess.GetPatients(); } catch (Exception ex) { string errorMessage = string.Format("При удалении объекта произошла ошибка!\n {0}", ex.Message); //this.Message = errorMessage; MessageBox.Show(errorMessage); } }
public Patients() { InitializeComponent(); dataGridViewResult.ItemsSource = PatientsDataAccess.GetPatients(); if (Membership.CurrentUser.RoleID == 2) { buttonAdd.Visibility = Visibility.Collapsed; buttonDelete.Visibility = Visibility.Collapsed; } }
/// <summary> /// Filters patients by name and number and sets the datagrdview source /// </summary> /// <param name="name"></param> /// <param name="number"></param> public void LoadPatientsByCriterias(string name, string number) { try { IQueryable <Patient> patientsQuery; patientsQuery = PatientsDataAccess.GetPatients(); if (!string.IsNullOrEmpty(name)) { patientsQuery = patientsQuery.Where(p => p.Name.Contains(name)); } if (!string.IsNullOrEmpty(number)) { patientsQuery = patientsQuery.Where(p => p.Number.Contains(number)); } this.Patients = patientsQuery.ToList(); } catch (Exception e) { this.Message = "Ошибка при запросе базы данных!Вызовите администратора!"; } }
/// <summary> /// Filters patients by name and number and sets the datagrdview source /// </summary> /// <param name="name"></param> /// <param name="number"></param> public void LoadPatientsByCriterias(string name, string number) { try { IQueryable <Patient> patientsQuery; patientsQuery = PatientsDataAccess.GetPatients(); if (!string.IsNullOrEmpty(name)) { patientsQuery = patientsQuery.Where(p => p.Name.Contains(name)); } if (!string.IsNullOrEmpty(number)) { patientsQuery = patientsQuery.Where(p => p.Number.Contains(number)); } this.Patients = patientsQuery.ToList(); } catch (Exception e) { this.Message = "Грешка при заявка към базатa от данни!Обадете се на администратор!"; } }
private void buttonSearch_Click(object sender, RoutedEventArgs e) { collection = from t in PatientsDataAccess.GetPatients() select t; if (!String.IsNullOrEmpty(Name.Text)) { collection = from t in collection where t.Name.Contains(Name.Text) select t; } if (!String.IsNullOrEmpty(Address.Text)) { collection = from t in collection where t.Address.Contains(Address.Text) select t; } if (dateTimePickerFrom.SelectedDate != null) { collection = from t in collection where t.Birthdate > BirthdateSearchFrom select t; } if (dateTimePickerTo.SelectedDate != null) { collection = from t in collection where t.Birthdate < BirthdateSearchTo select t; } dataGridViewResult.ItemsSource = collection; return; }