private void buttonDelete_Click(object sender, RoutedEventArgs e)
{
var selectedDoctor = this.GetSelectedDoctor();
if (selectedDoctor == null)
{
return;
}
if (MessageBox.Show("Вы действительно хотите удалить этого врача?", "Подтверждение удаления", MessageBoxButton.OKCancel) != MessageBoxResult.OK)//messageboxresult System.Windows.Forms.DialogResult
{
return;
}
try
{
int doctorId = selectedDoctor.DoctorId;
DoctorDataAccess.DeleteDoctorById(doctorId);
this.Presenter.LoadAllDoctors();
}
catch (Exception ex)
{
string errorMessage = string.Format("При удалении объекта произошла ошибка!\n {0}", ex.Message);
this.Message = errorMessage;
}
}
public Menu()
{
_doctorDataAccess = new DoctorDataAccess();
_patientDataAccess = new PatientDataAccess();
_timetableDataAccess = new TimetableDataAccess();
_doctorsSpecializationDataAccess = new DoctorsSpecializationDataAccess();
}
//private Doctor GetSelectedDoctor()
//{
// //var row = this.dataGridViewResult.SelectedItem;//currentrow было вместо колумна
// //if (row == null)
// //{
// // return null;
// //}
// //var doctor = (Doctor)row;//row.DataBoundItem;
// //return doctor;
//}
private void buttonEdit_Click(object sender, RoutedEventArgs e)
{
var row = (System.Data.DataRowView)dataGridViewResult.SelectedItems[0];
var editDoctor = new EditDoctor(DoctorDataAccess.GetDoctorById(Convert.ToInt32(row.Row.ItemArray[0].ToString())));
editDoctor.ShowDialog();
//this.Presenter.LoadDoctorsByCriterias();
}
private void buttonLoadDoctor_Click(object sender, RoutedEventArgs e)
{
Visit.Doctor = DoctorDataAccess.SelectDoctorByName(textBoxDoctorName.Text);
if (Visit.Patient != null)
{
MessageBox.Show("Доктор найден");
}
else
{
MessageBox.Show("Доктор не найден, попробуйте еще раз");
}
}
public void Load(int doctorId)
{
try
{
if (doctorId == 0)
{
throw new ArgumentNullException("doctorId должен отличаться от 0!");
}
var doctor = DoctorDataAccess.GetDoctorById(doctorId);
this.Doctor = doctor;
this.FillView();
}
catch (Exception e)
{
string message = "Ошибка!:" + e.Message;
View.Message = message;
}
}
/// <summary>
/// Filters doctors by name and number and sets the datagrdview source
/// </summary>
/// <param name="name"></param>
/// <param name="number"></param>
public void LoadDoctorsByCriterias(string name)
{
try
{
IQueryable <Doctor> doctorsQuery;
doctorsQuery = DoctorDataAccess.GetDoctors();
if (!string.IsNullOrEmpty(name))
{
doctorsQuery = doctorsQuery.Where(d => d.Name.Contains(name));
}
this.Doctors = doctorsQuery.ToList();
}
catch (Exception e)
{
this.Message = "Ошибка при запросе базы данных! Вызовите администратора!\n" + e.Message;
}
}
protected void FillView()
{
int doctorId = Diagnosis.DoctorId.HasValue ? Diagnosis.DoctorId.Value : 0;
View.DoctorId = doctorId;
var consultationDoctor = DoctorDataAccess.GetDoctorById(doctorId);
if (consultationDoctor != null)
{
View.DoctorName = consultationDoctor.Name;
}
else
{
View.DoctorName = "Не выбран врач";
}
int patientId = Diagnosis.PatientId.HasValue ? Diagnosis.PatientId.Value : 0;
View.PatientId = patientId;
var consultationPatient = PatientsDataAccess.GetPatientById(patientId);
if (consultationPatient != null)
{
View.PatientName = consultationPatient.Name;
View.PatientNumber = consultationPatient.Number;
}
else
{
View.PatientName = "Не выбран пациент";
View.PatientNumber = string.Empty;
}
DateTime scheduleDate = Diagnosis.DiagnosticationDate.HasValue ? Diagnosis.DiagnosticationDate.Value : DateTime.Now;
View.DiagnosticationDate = scheduleDate;
View.Notes = Diagnosis.Notes;
View.Subject = Diagnosis.Subect;
View.Prescription = Diagnosis.Prescription;
View.DiagnoseId = Diagnosis.DiagnoseId;
}
private void SaveModel(Doctor model)
{
try
{
if (Doctor.DoctorId == 0)
{
DoctorDataAccess.InsertDoctor(Doctor);
}
else
{
DoctorDataAccess.UpdateDoctor(Doctor);
}
View.Message = "Успешная запись!";
}
catch (Exception e)
{
var message = String.Format("Ошибка хранилища!Позвоните администратору!/ n [0] ", e.Message);
View.Message = message;
}
}
protected bool IsDataValid(out string message)
{
message = string.Empty;
bool isValid = true;
string _regex = @"\d{12}";
if (String.IsNullOrEmpty(textBoxName.Text))
{
message += String.Format("Поле '{0}' пусто!\n", "Имя");
isValid = false;
}
if (String.IsNullOrEmpty(textBoxAddress.Text))
{
message += String.Format("Поле '{0}' пусто!\n", "Адрес");
isValid = false;
}
//if (String.IsNullOrEmpty(Doctor.Skils))
//{
// message += String.Format("Поле '{0}' пусто!\n", "Опыт");
// isValid = false;
//}
if (!Regex.IsMatch(textBoxPhone.Text, _regex))
{
message += String.Format("Неверный формат телефона");
isValid = false;
}
Doctor.Name = textBoxName.Text;
Doctor.Phone = textBoxPhone.Text;
Doctor.Address = textBoxAddress.Text;
Category category = new Category(DoctorDataAccess.SelectCatIdByCat(textBoxCat.SelectedValue.ToString()), textBoxCat.SelectedValue.ToString());
Specialization specialization = new Specialization(DoctorDataAccess.SelectSpecIdByName(textBoxSpec.Text), textBoxSpec.Text);
Doctor.Category1 = category;
Doctor.Specialization1 = specialization;
return(isValid);
}
protected void FillView()
{
int doctorId = Consultation.DoctorId.HasValue ? Consultation.DoctorId.Value : 0;
View.DoctorId = doctorId;
var consultationDoctor = DoctorDataAccess.GetDoctorById(doctorId);
if (consultationDoctor != null)
{
View.DoctorName = consultationDoctor.Name;
}
else
{
View.DoctorName = "Не выбран пациент";
}
int patientId = Consultation.PatientId.HasValue ? Consultation.PatientId.Value : 0;
View.PatientId = patientId;
var consultationPatient = PatientsDataAccess.GetPatientById(patientId);
if (consultationPatient != null)
{
View.PatientName = consultationPatient.Name;
View.PatientNumber = consultationPatient.Number;
}
else
{
View.PatientName = "Не выбран пациент";
View.PatientNumber = string.Empty;
}
DateTime scheduleDate = Consultation.ScheduleDate.HasValue ? Consultation.ScheduleDate.Value : DateTime.Now;
TimeSpan scheduleTime = Consultation.ScheduleTime.HasValue ? Consultation.ScheduleTime.Value : TimeSpan.MinValue;
View.ScheduleDate = scheduleDate;
View.ScheduleTime = scheduleTime;
View.Notes = Consultation.Notes;
View.Reason = Consultation.Reason;
View.Conclusion = Consultation.Conclusion;
View.ConsultationId = Consultation.ConsultationId;
}
private void buttonSearch_Click(object sender, RoutedEventArgs e)
{
try
{
if (Category.SelectedItem != null && Category.SelectedItem.ToString() != "")
{
dataGridViewResult.ItemsSource = DoctorDataAccess.GetDoctorsByCat(Category.SelectedItem.ToString());
return;
}
if (!String.IsNullOrEmpty(Spec.Text))
{
dataGridViewResult.ItemsSource = DoctorDataAccess.GetDoctorsBySpec(Spec.Text);
return;
}
if (Category.SelectedItem.ToString() == "" && String.IsNullOrEmpty(Spec.Text))
{
dataGridViewResult.ItemsSource = DoctorDataAccess.GetDoctors();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DoctorBusiness()
{
_doctorDataMapper = new DoctorDataAccess();
_policlinicDataMapper = new PoliclinicDataMapper();
}
//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;
}
private void SelectAllDoctors()
{
dataGridViewResult.ItemsSource = DoctorDataAccess.GetDoctors();
//throw new NotImplementedException();
}
public Menu()
{
_patientDataAccess = new PatientDataAccess();
_doctorDataAccess = new DoctorDataAccess();
_scheduleDataAccess = new ScheduleDataAccess();
}
static void Main(string[] args)
{
InitConfiguration();
CultureInfo enUS = new CultureInfo("en-US");
var doctors = new List <Doctor>
{
new Doctor
{
FullName = "Ivan Ivanov",
SpecialId = Guid.Parse("6E5D08FA-9E66-4639-9742-06F9DF4197A7"),
ScheduleId = Guid.Parse("A30B3F5A-7744-4B6D-B99A-1D15848A5B3A"),
},
new Doctor
{
FullName = "Boris Borisov",
SpecialId = Guid.Parse("627CEDC2-530D-4B35-9BEB-08E3B7E07F79"),
ScheduleId = Guid.Parse("37D70B5B-4F33-4D07-B834-211C40C3C5EE")
}
};
var patients = new List <Patient>
{
new Patient
{
FullName = "Ivan Ivanov",
TimeOfVisitId = Guid.Parse("8E070ED1-E5B1-4BC5-8176-39B4C53FBD37")
},
new Patient
{
FullName = "Boris Borisov",
TimeOfVisitId = Guid.Parse("D8E21FB5-EBF6-45AD-AC09-59123ED3389B")
}
};
var visits = new List <TimesToVisits>
{
new TimesToVisits
{
Id = Guid.Parse("D8E21FB5-EBF6-45AD-AC09-59123ED3389B"),
TimeOfVisit = DateTime.ParseExact("11:00", "HH:mm", enUS)
},
new TimesToVisits
{
Id = Guid.Parse("8E070ED1-E5B1-4BC5-8176-39B4C53FBD37"),
TimeOfVisit = DateTime.ParseExact("15:00", "HH:mm", enUS)
},
};
var scheduls = new List <Schedule>
{
new Schedule
{
Id = Guid.Parse("A30B3F5A-7744-4B6D-B99A-1D15848A5B3A"),
TimesOfVisitsId = new List <Guid>
{
Guid.Parse("D8E21FB5-EBF6-45AD-AC09-59123ED3389B")
}
},
new Schedule
{
Id = Guid.Parse("37D70B5B-4F33-4D07-B834-211C40C3C5EE"),
TimesOfVisitsId = new List <Guid>
{
Guid.Parse("8E070ED1-E5B1-4BC5-8176-39B4C53FBD37")
}
}
};
var therapist = new Special
{
Id = Guid.Parse("6E5D08FA-9E66-4639-9742-06F9DF4197A7"),
Name = "Терапевт"
};
var surgeon = new Special
{
Id = Guid.Parse("627CEDC2-530D-4B35-9BEB-08E3B7E07F79"),
Name = "Хирург"
};
var doctorAccess = new DoctorDataAccess();
var listOfDoc = doctorAccess.Select().ToList();
Console.WriteLine("Выберите врача");
var choose = new List <int>();
int number = 0;
foreach (var doc in listOfDoc)
{
choose.Add(number);
Console.Write(doc.FullName);
Console.Write(" - ");
Console.WriteLine(choose[number]);
}
int.TryParse(Console.ReadLine(), out int numberOfDoc);
var scheduleAccess = new ScheduleDataAccess();
var listOfSchedules = scheduleAccess.Select().ToList();
var visitAccess = new TimesToVisitsDataAccess();
var listOfVisits = visitAccess.Select().ToList();
choose = null;
number = 0;
Doctor DocOfPatient = null;
foreach (var doc in doctors)
{
choose.Add(number);
if (numberOfDoc == choose[number])
{
DocOfPatient = doc;
}
foreach (var schedule in listOfSchedules)
{
if (schedule.Id == DocOfPatient.ScheduleId && schedule.TimesOfVisitsId == listOfVisits[number])
{
Console.WriteLine(visits[number]);
}
}
}
int.TryParse(Console.ReadLine(), out int numberOfVisit);
var patientAccess = new PatientDataAccess();
var listOfPatient = patientAccess.Select().ToList();
Console.WriteLine("Введите имя");
string nameOfPatient = Console.ReadLine();
var newPatient = new Patient
{
FullName = nameOfPatient,
TimeOfVisitId =
};
listOfPatient.Add(newPatient);
}
static void Main(string[] args)
{
ConfigurationService.Init();
ICollection <Doctor> doctors;
ICollection <VisitHistory> visitTime;
using (var doctorDataAccess = new DoctorDataAccess())
{
doctors = doctorDataAccess.Select();
}
Console.WriteLine(@" *********************************************
* *
* *
* Welcome to the Hospital System! *
* *
* *
*********************************************");
var patient = new Patient();
while (true)
{
Console.Write("Enter your Full name:\n");
using (var patientDataAccess = new PatientDataAccess())
{
patient.FullName = Console.ReadLine();
patientDataAccess.Insert(patient);
visitTime = patientDataAccess.SelectVisitTime();
}
Console.Clear();
Console.Write("\n1. Sign up for an appointment\n\n0. Exit\nChoose: ");
switch (Console.ReadLine())
{
case "1":
Console.Write("Choose doctor's direction: \n");
var direction = Console.ReadLine();
foreach (var doctor in doctors)
{
if (doctor.Direction.Name.Contains(direction))
{
using (var patientDataAccess = new PatientDataAccess())
{
foreach (var date in visitTime)
{
if (date.DoctorId == doctor.Id && date.VisitDate.Hour <= DateTime.Now.Hour)
{
doctor.IsFree = true;
}
}
if (doctor.Schedule.StartTime.Hour >= DateTime.Now.Hour &&
(doctor.Schedule.EndTime.Hour - 1) <= DateTime.Now.Hour &&
doctor.IsFree == true)
{
patientDataAccess.InsertHistory(doctor, patient);
}
}
}
}
break;
case "0":
return;
}
}
}
static void Main(string[] args)
{
var nowDay = new DateTime(2021, 3, 19, 8, 0, 0);
var fullTimeToRecords = new List <DayRecords>
{
new DayRecords
{
RecordsDateTimeStart = nowDay,
RecordsDateTimeEnd = nowDay.AddMinutes(30)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(30),
RecordsDateTimeEnd = nowDay.AddMinutes(60)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(60),
RecordsDateTimeEnd = nowDay.AddMinutes(90)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(90),
RecordsDateTimeEnd = nowDay.AddMinutes(120)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(120),
RecordsDateTimeEnd = nowDay.AddMinutes(150)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(150),
RecordsDateTimeEnd = nowDay.AddMinutes(180)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(180),
RecordsDateTimeEnd = nowDay.AddMinutes(210)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(210),
RecordsDateTimeEnd = nowDay.AddMinutes(240)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(240),
RecordsDateTimeEnd = nowDay.AddMinutes(270)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(270),
RecordsDateTimeEnd = nowDay.AddMinutes(300)
},
new DayRecords
{
RecordsDateTimeStart = nowDay.AddMinutes(300),
RecordsDateTimeEnd = nowDay.AddMinutes(330)
},
};
InitConfiguration();
var user = new User
{
Id = new Guid("6b017401-fd94-4710-8bf8-f9e0b40803a2"),
Login = "******",
Password = "******",
FullName = "Человечкова Алина Кадаржановна",
IIN = "12345678987"
};
Console.WriteLine("1.понедельник\n2.вторник\n3.среда\n4.четверг\n5.пятница");
Console.Write("Введите день недели для записи: ");
var day = Console.ReadLine();
Day dayId = new Day();
switch (day)
{
case "1":
dayId.Id = new Guid("d0e91b3a-9ead-4c96-b69e-82b8420c8b4f");
break;
}
var dayRecords = new List <DayRecords>();
using (var recordDataAccess = new RecordDataAccess())
{
dayRecords = recordDataAccess.GetDayRecords(dayId.Id).ToList();
}
Console.WriteLine("Занятое время");
foreach (var rec in dayRecords)
{
fullTimeToRecords.Remove(rec);
}
var record = new Record();
record.Id = Guid.NewGuid();
record.UserId = user.Id;
Console.WriteLine("Введите номер врача: ");
var doctors = new List <Doctor>();
int chetchik = 1;
using (var doctorDataAccess = new DoctorDataAccess())
{
doctors = doctorDataAccess.SelectAllDoctors().ToList();
foreach (var doctor in doctors)
{
doctor.Specialization = doctorDataAccess.GetSpecialization(doctor.SpecializationId);
Console.WriteLine($"{chetchik++}. {doctor.FullName} {doctor.Specialization.Specialty}");
}
}
var doctorNum = int.Parse(Console.ReadLine());
switch (doctorNum)
{
case 1:
record.DoctorId = doctors[doctorNum - 1].Id;
break;
}
Console.WriteLine("Введите время для записи");
int i = 1;
foreach (var dayrecord in fullTimeToRecords)
{
Console.WriteLine($"{i++}. {dayrecord.RecordsDateTimeStart.TimeOfDay} | {dayrecord.RecordsDateTimeEnd.TimeOfDay}");
}
var timeToRecords = int.Parse(Console.ReadLine());
switch (timeToRecords)
{
case 1:
record.RecordDateTimeStart = fullTimeToRecords[timeToRecords - 1].RecordsDateTimeStart;
record.RecordDateTimeEnd = fullTimeToRecords[timeToRecords - 1].RecordsDateTimeEnd;
break;
}
using (var recorddata = new RecordDataAccess())
{
recorddata.Insert(record);
}
}
