public ActionResult Profile(string message) { ViewBag.PatientProfile = "active"; ViewBag.UpdateMessage = message; int pid = (int)Session["PatientId"]; List <DoctorAppointmentView> ProfileList = new List <DoctorAppointmentView>(); Patient p = new Patient(); using (var ctx = new HospitalContext()) { List <Appointment> lap = (from a in ctx.Appointment where a.PatientId == pid && a.IsSeen == 2 select a).ToList(); foreach (Appointment q in lap) { q.IsSeen = 1; } ctx.SaveChanges(); Session["PatientNotify"] = 0; var data = (from a in ctx.Appointment join d in ctx.Doctor on a.DoctorId equals d.Id where a.PatientId == pid select new { aDate = a.Date, aApproval = a.Approval, aName = d.Name, aPrescription = a.Prescription, aDesignation = d.Designation, aSerial = a.SerialNo }); foreach (var d in data) { DoctorAppointmentView dc = new DoctorAppointmentView(); dc.Name = baseControl.Decrypt(d.aName); dc.Designation = baseControl.Decrypt(d.aDesignation); dc.Approval = d.aApproval; dc.Date = d.aDate; dc.Prescription = d.aPrescription; dc.Serial = d.aSerial; ProfileList.Add(dc); } // int id = Convert.ToInt32(Session["PatientId"]); var k = ctx.Patient.Where(e => e.Id == pid).Select(c => new { c.Name, c.Age, c.Address, c.PhoneNo }); foreach (var i in k) { p.Name = baseControl.Decrypt(i.Name); p.Address = baseControl.Decrypt(i.Address); p.Age = i.Age; p.PhoneNo = baseControl.Decrypt(i.PhoneNo); } ViewBag.Patient = p; } return(View(ProfileList)); }
public ActionResult Information() { ViewBag.Information = "active"; int id = Convert.ToInt32(Session["PatientId"]); List <DoctorAppointmentView> appointmentList = new List <DoctorAppointmentView>(); using (var db = new MedicalContext()) { List <PatientAppointmentModel> lappoint = (from a in db.Appointment where a.PatientId == id && a.Accepted == 3 select a).ToList(); foreach (PatientAppointmentModel p in lappoint) { p.Accepted = 1; } db.SaveChanges(); Session["PatientNotification"] = 0; var q = (from ab in db.Doctors join p in db.Specialist on ab.SpecialistId equals p.Id join a in db.Appointment on ab.Id equals a.DoctorId where a.DoctorId == ab.Id && a.PatientId == id select new { appointmentDate = a.Date, appointmentName = ab.Name, appointmentSpecialist = p.Specialist, appointmentPrescription = a.Prescription }); foreach (var d in q) { DoctorAppointmentView ap = new DoctorAppointmentView(); ap.DoctorName = privacy.Decrypt(d.appointmentName); ap.Date = d.appointmentDate; ap.Specialist = d.appointmentSpecialist; ap.Prescription = d.appointmentPrescription; appointmentList.Add(ap); } } return(View(appointmentList)); }