public IEnumerable GetPatientsByCriterion(int docId, string date) { List <string> recordedPatients = new List <string>(); using (var context = new PolyclinicDBContext()) { var patients = from t in context.Ticket where t.DoctorsId == docId join p in context.Patient on t.PatientsId equals p.id select new { Id = p.id, LastName = p.LastName, FirstName = p.FirstName, Patronymic = p.Patronymic, Date = t.VisitingDateAndTime }; foreach (var p in patients) { if (p.Date.ToShortDateString() == date) { recordedPatients.Add(p.Id + "." + p.LastName + " " + p.FirstName + " " + p.Patronymic + "\t\t" + p.Date.ToShortDateString() + "\t" + p.Date.ToShortTimeString()); } } } return(recordedPatients); }
public List <string> GetDoctorsBySpecialization(int specializationId) { List <string> Doctors = new List <string>(); using (var context = new PolyclinicDBContext()) { int therapistId = iCRUDMethods.GetTherapistId(); var chosenDoctors = from d in context.Doctor.AsNoTracking() where d.Specialization == specializationId select d; foreach (Doctor doctor in chosenDoctors) { if (doctor.Specialization == therapistId) { Doctors.Add(String.Format("{0} {1} {2}; {3}; № кабинета: {4}; Время приёма: {5}; Обслуживаемый участок: {6}", doctor.LastName, doctor.FirstName, doctor.Patronymic, iCRUDMethods.GetSpecializationName(doctor.Specialization), doctor.Room, doctor.Shedule, GetRegionName(doctor.Region.Value))); } else { Doctors.Add(String.Format("{0} {1} {2}; {3}; № кабинета: {4}; Время приёма: {5}", doctor.LastName, doctor.FirstName, doctor.Patronymic, iCRUDMethods.GetSpecializationName(doctor.Specialization), doctor.Room, doctor.Shedule)); } } } return(Doctors); }
public List <string> GetDoctorsByCriterion(int doctorSpecialization) { List <string> Doctors = new List <string>(); using (var context = new PolyclinicDBContext()) { int therapistId = iCRUDMethods.GetTherapistId(); var selectedDoctors = from d in context.Doctor.AsNoTracking() where d.Specialization == doctorSpecialization select d; foreach (Doctor doctor in selectedDoctors) { if (doctor.Specialization != therapistId) { Doctors.Add(String.Format("{0}.{1} {2} {3}; {4}; № кабинета {5}; Время приёма: {6}", doctor.DocId, doctor.LastName, doctor.FirstName, doctor.Patronymic, iCRUDMethods.GetSpecializationName(doctorSpecialization), doctor.Room, doctor.Shedule)); } else { Doctors.Add(String.Format("{0}.{1} {2} {3}; {4}; № кабинета {5}; № участка: {6}; Время приёма: {7}", doctor.DocId, doctor.LastName, doctor.FirstName, doctor.Patronymic, iCRUDMethods.GetSpecializationName(doctorSpecialization), doctor.Room, GetRegionName(doctor.Region.Value), doctor.Shedule)); } } } return(Doctors); }
public void DiagnosisAdd(string diagnosisName, string description) { if (description is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(description))); } if (diagnosisName is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(diagnosisName))); } using (var context = new PolyclinicDBContext()) { IQueryable query = context.Diagnosis; Diagnosis diagnosis = new Diagnosis() { DiagnosisName = diagnosisName, Description = description, }; context.Diagnosis.Add(diagnosis); context.SaveChanges(); } }
public IEnumerable GetRecordedPatients(int docId, DateTime date) { List <string> patients = new List <string>(); using (var context = new PolyclinicDBContext()) { var tickets = from t in context.Ticket where t.DoctorsId == docId join p in context.Patient on t.PatientsId equals p.id select new { id = p.id, LastName = p.LastName, FirstName = p.FirstName, Patronymic = p.Patronymic, VisitingTime = t.VisitingDateAndTime }; foreach (var ticket in tickets) { if (ticket.VisitingTime.ToShortDateString() == date.ToShortDateString()) { patients.Add(ticket.id + ". " + ticket.LastName + " " + ticket.FirstName + " " + ticket.Patronymic + "; Время приёма: " + ticket.VisitingTime.ToShortTimeString()); } } } return(patients); }
public Entities LoginChecker(string enteredLogin) { if (enteredLogin is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(enteredLogin))); } using (PolyclinicDBContext polyclinicDBContext = new PolyclinicDBContext()) { var logins = polyclinicDBContext.Login.AsNoTracking().ToList(); foreach (Login login in logins) { if (login.PolyclinicUser == "Administrator" && enteredLogin == login.UsersLogin) { return(Entities.Administrator); } if (login.PolyclinicUser == "Registrator" && enteredLogin == login.UsersLogin) { return(Entities.Registrator); } if (login.PolyclinicUser == "Doctor" && enteredLogin == login.UsersLogin) { return(Entities.Doctor); } } return(Entities.Empty); } }
public void DrugDescriptionChanged(string drugName, string description) { if (description is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(description))); } if (drugName is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(drugName))); } using (var context = new PolyclinicDBContext()) { IQueryable query = context.Drug; var drugs = from d in context.Drug where d.DrugName == drugName select d; var list = drugs.ToList(); list[0].Description = description; context.SaveChanges(); } }
public void CheckStreets(string streetName, int regionNumber) { if (streetName is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(streetName))); } bool exists = false; using (var context = new PolyclinicDBContext()) { IQueryable <Street> streetQuery = context.Street; List <Street> streets = streetQuery.ToList(); foreach (Street street in streets) { if (streetName == street.StreetName && regionNumber == street.RegionNumber) { exists = true; break; } } if (!exists) { context.Street.Add(new Street() { RegionNumber = regionNumber, StreetName = streetName }); } context.SaveChanges(); } }
public void DrugAdd(string drugName, string description) { if (description is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(description))); } if (drugName is null) { throw new ArgumentNullException(String.Format("{0} is null", nameof(drugName))); } using (var context = new PolyclinicDBContext()) { IQueryable query = context.Drug; Drug drug = new Drug() { DrugName = drugName, Description = description, }; context.Drug.Add(drug); context.SaveChanges(); } }
public IEnumerable GetDoctors() { List <Doctor> doctors; using (var context = new PolyclinicDBContext()) { IQueryable <Doctor> query = context.Doctor.AsNoTracking(); doctors = query.ToList(); } return(doctors); }
public IEnumerable GetSpecializations() { List <Specialization> specializations; using (var context = new PolyclinicDBContext()) { IQueryable <Specialization> query = context.Specialization.AsNoTracking(); specializations = query.ToList(); } return(specializations); }
public int GetTherapistId() { int id = 0; using (var context = new PolyclinicDBContext()) { var specialization = context.Specialization.Where(s => s.SpecializationName == "Терапевт"); id = specialization.ToList()[0].id; } return(id); }
public IEnumerable GetPatients() { List <Patient> patients; using (var context = new PolyclinicDBContext()) { IQueryable <Patient> query = context.Patient.AsNoTracking(); patients = query.ToList(); } return(patients); }
public Doctor GetDoctorById(int id) { Doctor doctor; using (var context = new PolyclinicDBContext()) { var query = context.Doctor.Where(d => d.DocId == id); doctor = query.ToList()[0]; } return(doctor); }
public int GetPatientsRegion(int patientsId) { int patientsRegion = 0; using (var context = new PolyclinicDBContext()) { var patient = context.Patient.Where(p => p.id == patientsId); patientsRegion = patient.ToList()[0].Region; } return(patientsRegion); }
public IEnumerable GetDoctorsStatistic(int docId) { List <VisitorStatistics> list = new List <VisitorStatistics>(); using (var context = new PolyclinicDBContext()) { IQueryable <VisitorStatistics> query = context.VisitorStatistics.AsNoTracking().Where(v => v.DocId == docId); list = query.ToList(); } return(list); }
public List <PrintedTicket> GetOldPrintedTickets() { List <Ticket> OldTickets = GetOldTickets(); List <PrintedTicket> OldPrintedTickets = new List <PrintedTicket>(); using (var context = new PolyclinicDBContext()) { foreach (Ticket ticket in OldTickets) { OldPrintedTickets.Add(iCRUDMethods.GetFullTicket(ticket.id)); } } return(OldPrintedTickets); }
public void DeleteOldTickets() { List <Ticket> OldTickets = GetOldTickets(); using (var context = new PolyclinicDBContext()) { foreach (Ticket ticket in OldTickets) { context.Ticket.Attach(ticket); context.Ticket.Remove(ticket); } context.SaveChanges(); } }
public string GetPatientsFullInfo(int patientId) { string patientInfo; using (var context = new PolyclinicDBContext()) { var patients = from p in context.Patient.AsNoTracking() where p.id == patientId select p; Patient patient = patients.ToList()[0]; patientInfo = String.Format("ФИО: {0} {1} {2} {8}Пол: {3}{8}Дата рождения: {4}{8}№ участка: {5}, Адрес: {6}{8}Дата регистрации: {7}", patient.LastName, patient.FirstName, patient.Patronymic, patient.Gender == false ? "Женский" : "Мужской", patient.Birth.ToShortDateString(), patient.Region, patient.Address, patient.RegistrationDate.Value.ToShortDateString(), Environment.NewLine); } return(patientInfo); }
public string GetSpecializationName(int specializationId) { string specializationName; using (var context = new PolyclinicDBContext()) { var specializationNames = from s in context.Specialization.AsNoTracking() where s.id == specializationId select s; specializationName = specializationNames.ToList()[0].SpecializationName; } return(specializationName); }
private string GetRegionName(int regionId) { string regionName; using (var context = new PolyclinicDBContext()) { var regions = from r in context.Region.AsNoTracking() where r.RegionNumber == regionId select r; regionName = regions.ToList()[0].RegionName; } return(regionName); }
public void AddTicketToStorage(int patientsId, int doctorsId, DateTime visitingDate) { using (var context = new PolyclinicDBContext()) { IQueryable query = context.Ticket; Ticket ticket = new Ticket(); ticket.PatientsId = patientsId; ticket.DoctorsId = doctorsId; ticket.VisitingDateAndTime = visitingDate; ticket.IsArrived = false; context.Ticket.Add(ticket); context.SaveChanges(); } }
public IEnumerable GetRegions() { List <string> regionsNames = new List <string>(); using (var context = new PolyclinicDBContext()) { var regions = context.Region.AsNoTracking(); foreach (var region in regions) { regionsNames.Add(region.RegionNumber + "." + region.RegionName); } } return(regionsNames); }
public IEnumerable GetSpecializationsNamesOnly() { List <string> specializationsList = new List <string>(); using (var context = new PolyclinicDBContext()) { IQueryable <Specialization> query = context.Specialization.AsNoTracking(); foreach (Specialization specialization in query.ToList()) { specializationsList.Add(specialization.SpecializationName); } } return(specializationsList); }
private List <Ticket> GetOldTickets() { DateTime Date = DateTime.Today; DateTime PM = Date.AddDays(-31); List <Ticket> OldTickets; using (var context = new PolyclinicDBContext()) { IQueryable <Ticket> oldTickets = from t in context.Ticket.AsNoTracking() where t.VisitingDateAndTime.CompareTo(PM) < 0 select t; OldTickets = oldTickets.ToList <Ticket>(); } return(OldTickets); }
public IEnumerable GetDoctors() { List <string> doctors = new List <string>(); using (var context = new PolyclinicDBContext()) { IQueryable <Doctor> query = context.Doctor.AsNoTracking(); var docs = query.ToList(); foreach (var doctor in docs) { doctors.Add(String.Format("{0}.{1} {2} {3}", doctor.DocId, doctor.LastName, doctor.FirstName, doctor.Patronymic)); } } return(doctors); }
public List <string> GetRegionInfo(int regionId) { List <string> RegionInfo = new List <string>(); using (var context = new PolyclinicDBContext()) { int therapistId = iCRUDMethods.GetTherapistId(); var theraphists = from d in context.Doctor.AsNoTracking() where d.Specialization == therapistId select d; int i = 0; foreach (Doctor doctor in theraphists) { if (doctor.Region.Value == regionId) { if (i == 0) { RegionInfo.Add("Врачи-терапевты, закреплённые за этим учатском:"); i++; } RegionInfo.Add(String.Format("{0} {1} {2}; № кабинета: {3}", doctor.LastName, doctor.FirstName, doctor.Patronymic, doctor.Room)); } } if (i == 0) { RegionInfo.Add("За этим учатском нет закреплённых терапевтов"); } var addresses = from s in context.Street.AsNoTracking() where s.RegionNumber == regionId select s; RegionInfo.Add("Адреса при участке:"); foreach (Street street in addresses) { RegionInfo.Add(String.Format("Участок №{0}, {1}", street.RegionNumber, street.StreetName)); } } return(RegionInfo); }
public IEnumerable GetRooms(int specializationId) { List <int> Rooms = new List <int>(); using (var context = new PolyclinicDBContext()) { var query = from r in context.Room.AsNoTracking() where r.SpecId == specializationId select r; foreach (Room room in query) { Rooms.Add(room.RoomNumber); } } return(Rooms); }
public IEnumerable GetDoctorsBySpecializationsId(int specializationId) { List <string> doctors = new List <string>(); using (var context = new PolyclinicDBContext()) { var docs = from d in context.Doctor.AsNoTracking() where d.Specialization == specializationId select d; foreach (var doctor in docs) { doctors.Add(String.Format("{0}.{1} {2} {3}", doctor.DocId, doctor.LastName, doctor.FirstName, doctor.Patronymic)); } } return(doctors); }
public void DoctorCreate(PolyclinicBL.Doctor doctor) { using (var context = new PolyclinicDBContext()) { Doctor newDoctor = new Doctor(); newDoctor.LastName = doctor.LastName; newDoctor.FirstName = doctor.FirstName; newDoctor.Patronymic = doctor.Patronymic; newDoctor.Specialization = doctor.Specialization; newDoctor.Region = doctor.Region; newDoctor.Room = doctor.Room; newDoctor.Shedule = doctor.Schedule; newDoctor.Interval = doctor.Interval; context.Doctor.Add(newDoctor); context.SaveChanges(); } }