public void UpdateArrivalStatistics(int patientId, int doctorId, bool isPatientArrived, DateTime date)
{
using (var context = new PolyclinicDBContext())
{
IQueryable query = context.Ticket.AsNoTracking();
var tickets = from t in context.Ticket
where t.PatientsId == patientId
where t.DoctorsId == doctorId
where t.IsArrived == false
where t.VisitingDateAndTime == date
select t;
Ticket ticket = tickets.ToList()[0];
ticket.IsArrived = isPatientArrived;
var statistics = from s in context.VisitorStatistics
where s.DocId == doctorId
select s;
foreach (var statistic in statistics)
{
if (statistic.Date.ToShortDateString() == statistic.Date.ToShortDateString())
{
statistic.ArrivedPatients += isPatientArrived == true ? 1 : 0;
statistic.NonArrivedPatients += isPatientArrived == false ? 1 : 0;
break;
}
}
context.SaveChanges();
}
}
public IEnumerable GetTickets(int doctorsId, string visitingDate)
{
List <string> Patients = new List <string>();
using (var context = new PolyclinicDBContext())
{
IQueryable query = context.Ticket.AsNoTracking();
var tickets = from t in context.Ticket
where t.DoctorsId == doctorsId
join p in context.Patient on t.PatientsId equals p.id
select new
{
PatientsId = p.id,
Surname = p.LastName,
Name = p.FirstName,
Patronymic = p.Patronymic,
Date = t.VisitingDateAndTime,
IsArrived = t.IsArrived,
};
foreach (var ticket in tickets)
{
if (ticket.Date.ToShortDateString() == visitingDate && !ticket.IsArrived)
{
Patients.Add(ticket.PatientsId + "." + ticket.Surname + " " + ticket.Name + " " + ticket.Patronymic + " " + ticket.Date.ToShortTimeString());
}
}
}
return(Patients);
}
public List <int> GetRooms(int specializationId)
{
List <int> rooms = new List <int>();
using (var context = new PolyclinicDBContext())
{
var availableRooms = from r in context.Room.AsNoTracking()
where r.SpecId == specializationId
select r;
foreach (Room room in availableRooms)
{
rooms.Add(room.RoomNumber);
}
}
return(rooms);
}
public void SetRooms(List <int> rooms, int specializationId)
{
if (rooms is null)
{
throw new ArgumentNullException(String.Format("{0} is null", nameof(rooms)));
}
///asdasd
using (var context = new PolyclinicDBContext())
{
foreach (int roomNum in rooms)
{
Room room = new Room {
RoomNumber = roomNum, SpecId = specializationId, RoomId = 0
};
context.Room.Add(room);
}
context.SaveChanges();
}
}
public IEnumerable GetTicketsByPatientsId(int patientId)
{
List <string> tickets = new List <string>();
using (var context = new PolyclinicDBContext())
{
var specialTickets = from t in context.Ticket.AsNoTracking()
where t.PatientsId == patientId
select t;
foreach (Ticket ticket in specialTickets)
{
var doctors = from d in context.Doctor.AsNoTracking()
where d.DocId == ticket.DoctorsId
select d;
Doctor doctor = doctors.ToList()[0];
tickets.Add(String.Format("{0}. {1} {2} {3} {4} {5} {6}", ticket.id, ticket.VisitingDateAndTime.ToShortDateString(), ticket.VisitingDateAndTime.ToShortTimeString(), doctor.DocId, doctor.LastName, doctor.FirstName, doctor.Patronymic));
}
}
return(tickets);
}
