public void EmailBooking(AppointmentModel app) { try { Email_Api emailApi = new Email_Api(); Appointment_Api aptms = new Appointment_Api(); var apppointment = aptms.GetAllAppointments().Where(a => a.appointment_ID == app.appointment_ID).First(); var patients = emailApi.GetPatientsAppointments(); Admin_Api adminApi = new Admin_Api(); var patDetails = (adminApi.GetAllPatients()).Where(p => p.pid == apppointment.paitent_ID).First(); MailMessage mailMessage = new MailMessage("*****@*****.**", patDetails.emailID); // Specify the email body mailMessage.Body = "Dear Patient you have booked appointment with Doctor " + app.doctorName + " Appointment ID is " + app.appointment_ID + " appointment time is " + app.timings; mailMessage.Subject = "Success Booking"; SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587); smtpClient.Credentials = new System.Net.NetworkCredential() { UserName = "******", Password = "******" }; smtpClient.EnableSsl = true; smtpClient.Send(mailMessage); } catch (Exception ex) { Utils.Logging(ex, 2); } }
public ActionResult EditAppointment(AppointmentModel appModel) { if (Convert.ToString(Session["key"]) != "patient") { return(RedirectToAction("Login", "Home")); } Appointment_Api apmtApi = new Appointment_Api(); apmtApi.UpdateApnmt_Api(appModel); return(Json("success", JsonRequestBehavior.AllowGet)); }
public JsonResult fillPatientList(string text) { Appointment_Api app = new Appointment_Api(); TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRoomRecs().Where(t => (t.date == DateTime.Parse(text) && t.isBooked == true)).GroupBy(g => g.patient_ID).Select(s => s.First()).ToList(); var allAptmts = app.GetAllAppointments(); var apps = allAptmts.Where(a => a.appointment_Date > DateTime.Now).GroupBy(g => g.paitent_ID).Select(s => s.First()).ToList(); TreatmentRoomModel trModelPats = new TreatmentRoomModel(); TreatmentRoomModel trModel = new TreatmentRoomModel(); //var allApts = app.GetAllAppointments(); foreach (var p in model) { trModelPats.patientDropDown.Add(new SelectListItem { Text = p.patientFirstName, Value = Convert.ToString(p.patient_ID) }); } foreach (var p in apps) { trModel.patientDropDown.Add(new SelectListItem { Text = p.patientName, Value = Convert.ToString(p.paitent_ID) }); } trModel.patientDropDown = (from t in trModel.patientDropDown where trModelPats.patientDropDown.All(o => o.Text != t.Text) select t).ToList(); List <SelectListItem> patientList = new List <SelectListItem>(); foreach (var p in trModel.patientDropDown) { patientList.Add(p); } foreach (var t in trModel.patientDropDown) { if ((GetApptsForRooms(Convert.ToInt32(t.Value))).Count() == 0) { patientList.Remove(t); } } return(Json(patientList, JsonRequestBehavior.AllowGet)); }
//Used to get aptmts for patients with no room booking public List <SelectListItem> GetApptsForRooms(int patientID) { Patient_Api patientApi = new Patient_Api(); Appointment_Api app = new Appointment_Api(); IEnumerable <AppointmentModel> patientAppointments = patientApi.GetAppointmentsForBookedRooms(patientID).Where(a => a.appointment_Date > DateTime.Now && a.cancelled == false); //apts with no rooms IEnumerable <AppointmentModel> patAptsNoBilling = app.GetAppointmentsWithNoBilling().Where(a => (a.paitent_ID == patientID && a.appointment_Date > DateTime.Now && a.cancelled == false)); //not billed apts List <int> aptsInt = new List <int>(); foreach (var a in patientAppointments) { aptsInt.Add(a.appointment_ID); } List <int> aptsIntNoBilling = new List <int>(); foreach (var a in patAptsNoBilling) { aptsIntNoBilling.Add(a.appointment_ID); } PatientModel patModel = new PatientModel(); patModel.pid = patientID; TreatmentRoom_Api trApi = new TreatmentRoom_Api(); var bookedAppointments = trApi.GetBookedRooms(patModel); //apts with room booked List <int> bookedaptsInt = new List <int>(); foreach (var a in bookedAppointments) { bookedaptsInt.Add(a.appointment_ID); } IEnumerable <int> finalApts = aptsIntNoBilling.Concat(aptsInt);//aptsIntNoBilling.Except(bookedaptsInt).ToList(); finalApts = finalApts.Except(bookedaptsInt).ToList(); List <SelectListItem> appts = new List <SelectListItem>(); foreach (var a in finalApts) { appts.Add(new SelectListItem { Text = a.ToString(), Value = a.ToString() }); } return(appts); }
public ActionResult GetReqReportNotes(int aptId) { if (Convert.ToString(Session["key"]) != "labIncharge") { return(RedirectToAction("Login", "Home")); } Patient_Api patientApi = new Patient_Api(); Appointment_Api appApi = new Appointment_Api(); AppointmentModel appModel = new AppointmentModel(); appModel.appointment_ID = aptId; var appDetails = appApi.GetApnmt_Api(appModel); return(Json(appDetails.reqReportNotes, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAppointmentsWithNoBilling(int patientID) { //int id = (int)Session["UserId"]; Appointment_Api app = new Appointment_Api(); IEnumerable <int> patientAppointments = app.GetAppointmentsWithNoBilling().Where(a => (a.paitent_ID == patientID && a.appointment_Date < DateTime.Now)).Select(a => a.appointment_ID); //apts with no billing TreatmentRoom_Api trApi = new TreatmentRoom_Api(); PatientModel patModel = new PatientModel(); patModel.pid = patientID; var AptWithRoomInFuture = trApi.GetBookedRooms(patModel).Where(t => t.date > DateTime.Now).Select(t => t.appointment_ID); //apts with rooms in future patientAppointments = patientAppointments.Except(AptWithRoomInFuture); List <SelectListItem> appts = new List <SelectListItem>(); foreach (var a in patientAppointments) { appts.Add(new SelectListItem { Text = a.ToString(), Value = a.ToString() }); } return(Json(appts, JsonRequestBehavior.AllowGet)); }