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;
}
