private void buttonDelete_Click(object sender, RoutedEventArgs e)
{
var row = (System.Data.DataRowView)dataGridViewResult.SelectedItems[0];
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;
VisitsDataAccess.DeleteVisitById(Convert.ToInt32((row.Row.ItemArray[0].ToString())));
GetAllVisits();
}
catch (Exception ex)
{
string errorMessage = string.Format("При удалении объекта произошла ошибка!\n {0}", ex.Message);
MessageBox.Show(errorMessage);
}
}
private void GetAllVisits()
{
if (Membership.CurrentUser.RoleID == 1)
{
dataGridViewResult.ItemsSource = VisitsDataAccess.GetVisits();
}
else if (Membership.CurrentUser.RoleID == 2)
{
dataGridViewResult.ItemsSource = VisitsDataAccess.GetVisitsByDoctorId(Membership.CurrentUser.Doctor.Id);
}
else if (Membership.CurrentUser.RoleID == 3)
{
dataGridViewResult.ItemsSource = VisitsDataAccess.GetVisitsByPatientId(Membership.CurrentUser.Patient.Id);//throw new NotImplementedException();
}
var list = dataGridViewResult.Columns;
}
public void Load(int visit)
{
try
{
if (visit == 0)
{
throw new ArgumentNullException("visit должен отличаться от 0!");
}
Visit = VisitsDataAccess.GetVisitByID(visit);
this.FillView();
}
catch (Exception e)
{
string message = "Ошибка!:" + e.Message;
MessageBox.Show(message);
}
}
public void Save()
{
//this.FillVisit();
bool isValid = IsValid();
if (isValid)
{
Visit.Diagnosis = textBoxDiagnosis.Text;
Visit.Prescription = textBoxPrescription.Text;
Visit.Symthoms = textBoxSymptoms.Text;
Visit.DateTime = dateTimePickerVisitDate.SelectedDate.Value.AddHours(dateTimePickerVisitTime.SelectedTime.Value.Hour).AddMinutes(dateTimePickerVisitTime.SelectedTime.Value.Minute);;
Visit.Notes = textBoxNotes.Text;
Visit.Room = new Room(textboxRoom.Text, null);
Visit.Type = VisitsDataAccess.GetTypeByName(Type.SelectedValue.ToString());
SaveModel(Visit);
}
}
private void SaveModel(Visit model)
{
try
{
if (Flag == false)
{
VisitsDataAccess.InsertVisit(Visit);
}
else
{
VisitsDataAccess.UpdateVisit(Visit);
}
//View.Message = "Успешная запись!";
}
catch (Exception e)
{
var message = String.Format("Ошибка хранилища! Позвоните администратору!/n {0} ", e.Message);
MessageBox.Show(message);
}
}
public void LoadVisit(int patientId)
{
try
{
//if (this.Patient == null || this.Patient.Id == 0)
//{
// return;
//}
//int patientId = this.Patient.Id;
var visits = VisitsDataAccess.GetVisitsByPatientId(patientId);
Flag = true;
//this.View.Visits = visits;
}
catch (Exception e)
{
string message = "Ошибка при загрузке диагнозов для пациента!\n" + e.Message;
MessageBox.Show(message);
}
}
public void Load(int patientId)
{
try
{
if (patientId == 0)
{
throw new ArgumentNullException("patientId должен отличаться от 0!");
}
patient = PatientsDataAccess.GetPatientById(patientId);
textBoxAddress.Text = patient.Address;
textBoxName.Text = patient.Name;
textBoxPhone.Text = patient.Phone;
dateTimePickerBirthdate.SelectedDate = patient.Birthdate;
dataGridViewVisits.ItemsSource = VisitsDataAccess.GetVisitsByPatientId(patientId);
Flag = true;
}
catch (Exception e)
{
string message = "Ошибка!:" + e.Message;
MessageBox.Show(message);
}
}
//public ConsultationsPresenter Presenter { get; set; }
private void buttonSearch_Click(object sender, RoutedEventArgs e)
{
dataGridViewResult.Columns.Clear();
List <Visit> visits = new List <Visit>();
if (Membership.CurrentUser.RoleID == 1)
{
for (int i = 0; i < VisitsDataAccess.GetVisits().Count; i++)
{
var row = VisitsDataAccess.GetVisits()[i];
visits.Add(new Visit(Convert.ToInt32(row.Row.ItemArray[0]),
DoctorDataAccess.GetDoctorByName(row.Row.ItemArray[1].ToString()),
PatientsDataAccess.GetPatientByName(row.Row.ItemArray[2].ToString()),
Convert.ToDateTime(row.Row.ItemArray[3]),
VisitsDataAccess.GetTypeByName(row.Row.ItemArray[4].ToString()),
row.Row.ItemArray[5].ToString(),
row.Row.ItemArray[6].ToString(),
row.Row.ItemArray[7].ToString(),
row.Row.ItemArray[8].ToString(),
new Room(row.Row.ItemArray[9].ToString(), null),
(row.Row.ItemArray[10].ToString() == "") ? null : (byte[])row.Row.ItemArray[10]
));
}
}
else if (Membership.CurrentUser.RoleID == 2)
{
for (int i = 0; i < VisitsDataAccess.GetVisitsByDoctorId(Membership.CurrentUser.Doctor.Id).Count; i++)
{
var row = VisitsDataAccess.GetVisitsByDoctorId(Membership.CurrentUser.Doctor.Id)[i];
visits.Add(new Visit(Convert.ToInt32(row.Row.ItemArray[0]),
DoctorDataAccess.GetDoctorByName(row.Row.ItemArray[1].ToString()),
PatientsDataAccess.GetPatientByName(row.Row.ItemArray[2].ToString()),
Convert.ToDateTime(row.Row.ItemArray[3]),
VisitsDataAccess.GetTypeByName(row.Row.ItemArray[4].ToString()),
row.Row.ItemArray[5].ToString(),
row.Row.ItemArray[6].ToString(),
row.Row.ItemArray[7].ToString(),
row.Row.ItemArray[8].ToString(),
new Room(row.Row.ItemArray[9].ToString(), null),
(row.Row.ItemArray[10].ToString() == "") ? null : (byte[])row.Row.ItemArray[10]
));
}
}
dataGridViewResult.AutoGenerateColumns = false;
DataGridTextColumn id = new DataGridTextColumn();
id.Header = "ID";
id.Binding = new Binding("ID");
dataGridViewResult.Columns.Add(id);
DataGridTextColumn doctor = new DataGridTextColumn();
doctor.Header = "Доктор";
doctor.Binding = new Binding("Doctor.Name");
dataGridViewResult.Columns.Add(doctor);
DataGridTextColumn patient = new DataGridTextColumn();
patient.Header = "Пациент";
patient.Binding = new Binding("Patient.Name");
dataGridViewResult.Columns.Add(patient);
DataGridTextColumn datetime = new DataGridTextColumn();
datetime.Header = "Дата/время";
datetime.Binding = new Binding("DateTime");
dataGridViewResult.Columns.Add(datetime);
DataGridTextColumn type = new DataGridTextColumn();
type.Header = "Тип";
type.Binding = new Binding("Type.Type");
dataGridViewResult.Columns.Add(type);
DataGridTextColumn sympthoms = new DataGridTextColumn();
sympthoms.Header = "Симптомы";
sympthoms.Binding = new Binding("Symthoms");
dataGridViewResult.Columns.Add(sympthoms);
DataGridTextColumn diagnosis = new DataGridTextColumn();
diagnosis.Header = "Диагноз";
diagnosis.Binding = new Binding("Diagnosis");
dataGridViewResult.Columns.Add(diagnosis);
DataGridTextColumn prescription = new DataGridTextColumn();
prescription.Header = "Назначения";
prescription.Binding = new Binding("Prescription");
dataGridViewResult.Columns.Add(prescription);
DataGridTextColumn notes = new DataGridTextColumn();
notes.Header = "Заметки";
notes.Binding = new Binding("Notes");
dataGridViewResult.Columns.Add(notes);
DataGridTextColumn room = new DataGridTextColumn();
room.Header = "Кабинет";
room.Binding = new Binding("Room.Number");
dataGridViewResult.Columns.Add(room);
IEnumerable <Visit> result = visits;
if (dateTimePickerFrom.SelectedDate != null)
{
result = result.Where(el => (el.DateTime > dateTimePickerFrom.SelectedDate)).Select(el => el);
}
if (dateTimePickerTo.SelectedDate != null)
{
result = result.Where(el => (el.DateTime < dateTimePickerTo.SelectedDate)).Select(el => el);
}
if (!String.IsNullOrEmpty(Patient.Text))
{
result = result.Where(el => (el.Patient.Name.Contains(Patient.Text))).Select(el => el);
}
if (!String.IsNullOrEmpty(Doctor.Text))
{
result = result.Where(el => (el.Doctor.Name.Contains(Doctor.Text))).Select(el => el);
}
if (!String.IsNullOrEmpty(Diagnosis.Text))
{
result = result.Where(el => (el.Diagnosis.Contains(Patient.Text))).Select(el => el);
}
if (VisitType.SelectedItem != null && VisitType.SelectedItem.ToString() != "")
{
result = result.Where(el => (el.Type.Type == VisitType.SelectedItem.ToString())).Select(el => el);
}
dataGridViewResult.ItemsSource = result;
SelectFlag = true;
}
