public virtual void CheckPatientVisitsForArchived(string login)
{
using (SurgeryModel sm = new SurgeryModel())
{
var patient = (from pt in sm.Patients
where pt.PatientAccount_Login == login
select pt).First();
DateTime dtp = DateTime.Now.AddDays(14);
var visits = (from vt in sm.VisitTimes
where vt.PatientId == patient.Id && vt.Date < dtp
select vt).ToList();
DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
foreach (VisitTime visit in visits)
{
if (visit.Date <= DateTime.Now)
{
ArchivedVisit av = new ArchivedVisit()
{
Patient = visit.Patient,
Doctor = visit.Doctor,
Date = visit.Date
};
sm.ArchivedVisits.Add(av);
sm.VisitTimes.Remove(visit);
}
}
sm.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
ArchivedVisit archivedVisit = db.ArchivedVisits.Find(id);
db.ArchivedVisits.Remove(archivedVisit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,Date,DoctorId,PatientId,Rating")] ArchivedVisit archivedVisit)
{
if (ModelState.IsValid)
{
db.ArchivedVisits.Add(archivedVisit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DoctorId = new SelectList(db.Doctors, "Id", "Name", archivedVisit.DoctorId);
ViewBag.PatientId = new SelectList(db.Patients, "Id", "Name", archivedVisit.PatientId);
return(View(archivedVisit));
}
// GET: ArchivedVisits/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ArchivedVisit archivedVisit = db.ArchivedVisits.Find(id);
if (archivedVisit == null)
{
return(HttpNotFound());
}
return(View(archivedVisit));
}
// GET: ArchivedVisits/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ArchivedVisit archivedVisit = db.ArchivedVisits.Find(id);
if (archivedVisit == null)
{
return(HttpNotFound());
}
ViewBag.DoctorId = new SelectList(db.Doctors, "Id", "Name", archivedVisit.DoctorId);
ViewBag.PatientId = new SelectList(db.Patients, "Id", "Name", archivedVisit.PatientId);
return(View(archivedVisit));
}
public ActionResult Edit([Bind(Include = "Id,Date,DoctorId,PatientId,Rating")] ArchivedVisit archivedVisit)
{
var visit = (from av in db.ArchivedVisits
where av.Id == archivedVisit.Id
select av).FirstOrDefault();
int?oldrating = visit.Rating;
visit.Rating = archivedVisit.Rating.Value;
int countErrors = 0;
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
countErrors++;
}
}
if (countErrors == 2)
{
db.Entry(visit).State = EntityState.Modified;
db.Entry(visit.Patient).State = EntityState.Unchanged;
db.Entry(visit.Doctor).State = EntityState.Unchanged;
db.SaveChanges();
db.Entry(visit.Patient).State = EntityState.Unchanged;
db.Entry(visit).State = EntityState.Unchanged;
SetRating(visit.DoctorId, visit.Doctor.RatingsCount, oldrating, archivedVisit.Rating.Value);
return(RedirectToAction("Main", "Patients", new { id = visit.PatientId }));
}
ViewBag.DoctorId = new SelectList(db.Doctors, "Id", "Name", archivedVisit.DoctorId);
ViewBag.PatientId = new SelectList(db.Patients, "Id", "Name", archivedVisit.PatientId);
return(View(archivedVisit));
}
