public ActionResult Edit(int id) { var appointment = AppointmentBO.GetById(id); if (appointment == null) { return(RedirectToAction("NotFound", "Home")); } appointment.Attendees = AppointmentBO.GetUsers(appointment.Id); var model = new AppointmentModel { Id = appointment.Id, Title = appointment.Title, Description = appointment.Description, StartAndEndDate = appointment.StartDate.ToString(Helper.FormatDateTime) + " - " + appointment.EndDate.ToString(Helper.FormatDateTime), Attendees = appointment.Attendees != null?appointment.Attendees.Select(u => u.Id).ToList() : new List <int>() }; ViewBag.Count = AppointmentBO.CountCommentAccepted(model.Id); ViewBag.DisplayReject = CurrentUser.Id != appointment.CreateBy && AppointmentBO.CommentCheckExisted(model.Id, CurrentUser.Id) == null; ViewBag.DisplaySave = CurrentUser.Id == appointment.CreateBy; PreparingData(); return(View("Create", model)); }
public AppointmentBO BookAppointment(AppointmentBO appointmentBO) { try { if (checkAppointemnt(appointmentBO)) { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Appointment app = new Appointment(); Appointment newAppointment = ConvertBOToAppt(app, appointmentBO); objHmsDataContext.Appointments.InsertOnSubmit(newAppointment); objHmsDataContext.SubmitChanges(); } } else { AppointmentBO app_BO = null; return(app_BO); } AppointmentBO appBO = GetAppointment(appointmentBO); return(appBO); } catch (Exception e) { AppointmentBO app_BO = new AppointmentBO(); return(app_BO); } }
public AppointmentBO GetAppointmentByID(AppointmentBO appointmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } AppointmentBO apmntBO = objHmsDataContext.Appointments.Where(apmnt => (apmnt.Appointment_ID == appointmentBO.appointment_ID)) .Join(objHmsDataContext.Patients, a => a.Patient_ID, p => p.Patient_ID, (a, p) => new AppointmentBO { appointment_ID = a.Appointment_ID, patientName = p.First_Name, paitent_ID = a.Patient_ID, appointment_Date = a.Appointment_Date, timings = a.Timings, doctor_ID = a.Doctor_ID, }).First(); return(apmntBO); } } catch (Exception e) { AppointmentBO app_BO = new AppointmentBO(); return(app_BO); } }
//Method to update Appointment, with return type string public AppointmentBO UpdateApmnt(AppointmentBO appointmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Appointment apmnt = objHmsDataContext.Appointments.SingleOrDefault(appmt => (appmt.Appointment_ID == appointmentBO.appointment_ID || (appmt.Patient_ID == appointmentBO.paitent_ID && appmt.Appointment_Date == appointmentBO.appointment_Date))); Appointment updateApmnt = ConvertBOToAppt(apmnt, appointmentBO); objHmsDataContext.SubmitChanges(); } return(GetAppointment(appointmentBO)); } catch (Exception e) { throw new Exception("unable to update appointment now"); //return "Unable to update appointment please try again later"; } }
public List <string> GetAvailableTimingsForPatient(AppointmentBO appointmentBo) { try { using (HospitalManagementSystemDataContext ObjHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (ObjHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { ObjHmsDataContext.Connection.Open(); } IEnumerable <AppointmentBO> doctorsAppointmentsList = ObjHmsDataContext.Appointments.Where(a => a.Appointment_Date == appointmentBo.appointment_Date && a.Patient_ID == appointmentBo.paitent_ID && a.Cancelled == false) .Select(t => new AppointmentBO { timings = t.Timings }).ToList(); List <string> timingsList = new List <string>(); foreach (var d in doctorsAppointmentsList) { timingsList.Add(d.timings.ToString(@"hh\:mm")); } return(timingsList); } } catch (Exception ex) { List <string> timingsList = null; return(timingsList); } }
public IEnumerable <int> GetPaitentsListByDate(AppointmentBO app) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } IEnumerable <int> patientsList = objHmsDataContext.Patients.Distinct().Select(p => p.Patient_ID).ToArray(); // IEnumerable<int> patients = objHmsDataContext.Appointments.Where(a =>a.Appointment_Date == app.appointment_Date && a.); //foreach () //{ //} return(patientsList); } } catch (Exception e) { return(null); } }
public bool checkAppointemnt(AppointmentBO apmnt) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Appointment appointment = new Appointment(); Appointment appointmentUpdate = ConvertBOToAppt(appointment, apmnt); var checkExistingAppointments = objHmsDataContext.Appointments.Select(checkApmnt => (checkApmnt.Doctor_ID == apmnt.doctor_ID && checkApmnt.Patient_ID == apmnt.paitent_ID && checkApmnt.Appointment_Date == apmnt.appointment_Date && checkApmnt.Timings == apmnt.timings)); if (checkExistingAppointments != null) { return(true); } return(false); } } catch { return(false); } }
//Method to delete Appointment, with return type string public string DeleteAppointment(AppointmentBO apmntBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Appointment apmnt = objHmsDataContext.Appointments.SingleOrDefault(appmnt => (appmnt.Appointment_ID == apmntBO.appointment_ID && appmnt.Patient_ID == apmntBO.paitent_ID)); Appointment converted_Apmnt = ConvertBOToAppt(apmnt, apmntBO); objHmsDataContext.Appointments.DeleteOnSubmit(converted_Apmnt); objHmsDataContext.SubmitChanges(); return("Appointment Deleted successfully"); } } catch (Exception e) { return("Unable to Delete Appointment Please try again later"); } }
public IEnumerable <AppointmentBO> GetAppointmentsWithNoBilling() { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } List <int> appts = objHmsDataContext.Appointments.Where(a => a.Cancelled == false).Select(a => a.Appointment_ID).ToList(); List <int> accBO = objHmsDataContext.Accounts.Select(a => a.Appointment_ID).ToList(); appts = appts.Except(accBO).ToList(); List <AppointmentBO> result = new List <AppointmentBO>(); AppointmentBO app = new AppointmentBO(); foreach (var a in appts) { app.appointment_ID = a; var r = GetAppointmentByID(app); result.Add(r); } return(result); } } catch (Exception e) { IEnumerable <AppointmentBO> app_BO = null; return(app_BO); } }
public IEnumerable <ReportBO> ReqNewReport(AppointmentBO appBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Appointment appt = objHmsDataContext.Appointments.SingleOrDefault(rprt => (rprt.Appointment_ID == appBO.appointment_ID)); appt.RequestedReport = true; appt.RequestedReportNotes = appBO.reqReportNotes; objHmsDataContext.SubmitChanges(); return(GetAllPatientsReports_DAL()); } } catch (Exception e) { return(null); } }
public IEnumerable <int> GetPaitentsListByDate(AppointmentBO app) { PatientBLLFactory patientBBLFactory = new PatientBLLFactory(); var patientsList = patientBBLFactory.CreatePatientBLL().GetPatientBLL().CreatePatientDAL().GetPatientsList(); return(patientsList); }
public ActionResult Reject(int id) { var app = AppointmentBO.GetById(id); ViewBag.Appointment = app; return(View()); }
public void cancelAllAppointmentByDate(AppointmentBO appBO) { DoctorBLLFactory docBLLFactory = new DoctorBLLFactory(); var patIDs = docBLLFactory.CreateDoctorBLL().GetDocAppointments().CreateDoctorDAL().cancelAllAppointmentByDate(appBO); EmailController emails = new EmailController(); emails.SendAppCancelledEmail(patIDs.ToList()); }
public List <string> GetAvailableTimingsForPatient(AppointmentBO appointmentBO) { DoctorBLLFactory getDoctors = new DoctorBLLFactory(); var val = getDoctors.CreateDoctorBLL().GetDoctorsListBLL().CreateDoctorDAL().GetAvailableTimingsForPatient(appointmentBO); return(val); }
public AppointmentBO GetApmntByID(AppointmentBO appBO) { AppointmentBLLFactory appBLLFactory = new AppointmentBLLFactory(); AppointmentBO app_BO = appBLLFactory.CreateAppointmentBLL().GetAppointment().CreateAppointmentDAL().GetAppointment(appBO); return(app_BO); }
public AppointmentBO PatientBookAppointment(AppointmentBO bookAppointment) { AppointmentBLLFactory appBLLFactory = new AppointmentBLLFactory(); AppointmentBO newAppointment = appBLLFactory.CreateAppointmentBLL().GetAppointment().CreateAppointmentDAL().BookAppointment(bookAppointment); return(newAppointment); }
//Method to get appointment details, with return type appointmet Business object public AppointmentBO GetAppointment(AppointmentBO appointmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } AppointmentBO apmntBO = null; if (appointmentBO.appointment_Date != DateTime.MinValue) { apmntBO = objHmsDataContext.Appointments.Where(apmnt => ((apmnt.Patient_ID == appointmentBO.paitent_ID && apmnt.Date_Time == appointmentBO.date) || (apmnt.Patient_ID == appointmentBO.paitent_ID && apmnt.Appointment_Date == appointmentBO.appointment_Date)) || (apmnt.Appointment_ID == appointmentBO.appointment_ID)) .Join(objHmsDataContext.Patients, a => a.Patient_ID, p => p.Patient_ID, (a, p) => new AppointmentBO { appointment_ID = a.Appointment_ID, patientName = p.First_Name, paitent_ID = a.Patient_ID, appointment_Date = a.Appointment_Date, timings = a.Timings, doctor_ID = a.Doctor_ID, reqReportNotes = a.RequestedReportNotes != null ? a.RequestedReportNotes : "N/A" }).First(); } else { apmntBO = objHmsDataContext.Appointments.Where(apmnt => (apmnt.Appointment_ID == appointmentBO.appointment_ID)) .Join(objHmsDataContext.Patients, a => a.Patient_ID, p => p.Patient_ID, (a, p) => new AppointmentBO { appointment_ID = a.Appointment_ID, patientName = p.First_Name, paitent_ID = a.Patient_ID, appointment_Date = a.Appointment_Date, timings = a.Timings, doctor_ID = a.Doctor_ID, reqReportNotes = a.RequestedReportNotes != null ? a.RequestedReportNotes : "N/A" }).First(); } apmntBO.doctorName = objHmsDataContext.Doctors.Where(d => d.Doctor_ID == apmntBO.doctor_ID).Select(dn => dn.First_Name).FirstOrDefault(); return(apmntBO); } } catch (Exception e) { AppointmentBO app_BO = new AppointmentBO(); return(app_BO); } }
// // GET: /Appointment/ public ActionResult Index() { var user = CurrentUser; var appointments = AppointmentBO.GetByUserId(user.Id); if (appointments != null && appointments.Count > 0) { } return(View(appointments)); }
public ReportBO GetReportsByAppt(AppointmentBO app) { //ReportBO reportBO = new ReportBO(); //reportBO.report_ID = app.appointment_ID; ReportBLLFactory rprtBLLFactory = new ReportBLLFactory(); ReportBO rprtBO = rprtBLLFactory.CreateReportBLL().GetReportBLL().CreateReportDAL().GetReportsByAppt(app.appointment_ID); return(rprtBO); }
protected void Button1_Click(object sender, EventArgs e) { AppointmentBO appointmentbo = new AppointmentBO(); long l = Convert.ToInt64((TextBox1.Text.Trim())); GridView1.VirtualItemCount = appointmentbo.Count(x => x.AppointmentId.Equals(l)); GridView1.DataSource = appointmentbo.Find(x => x.AppointmentId.Equals(l), 0, GridView1.PageSize) .ToList(); GridView1.DataBind(); Button1.Enabled = true; }
// GET: api/Appointment/5 //Get Action which accepts integer as parameter and appointment Business object as return type public AppointmentBO Get(int id) { AppointmentBO appBO = new AppointmentBO(); appBO.appointment_ID = id; AppointmentBLLFactory appBLLFactory = new AppointmentBLLFactory(); AppointmentBO app_BO = appBLLFactory.CreateAppointmentBLL().GetAppointment().CreateAppointmentDAL().GetAppointment(appBO); return(app_BO); }
public IEnumerable <AppointmentBO> GetAppointmentsForBookedRooms(int id) { AppointmentBO appBO = new AppointmentBO(); appBO.paitent_ID = id; AppointmentBLLFactory appBLLFactory = new AppointmentBLLFactory(); IEnumerable <AppointmentBO> app_BO = appBLLFactory.CreateAppointmentBLL().GetAppointment().CreateAppointmentDAL().GetAppointmentsForBookedRooms(appBO); return(app_BO); }
// PUT: api/Appointment/5 //Put action which accepts integer and appointment business object as parameter with void return type public void DeleteAppointment(AppointmentBO appointmentBO) { //sample input values are provided appointmentBO.appointment_ID = 12004; appointmentBO.paitent_ID = 7002; appointmentBO.doctor_ID = 5006; appointmentBO.date = DateTime.Parse("2010/03/02"); appointmentBO.timings = TimeSpan.Parse("20:20:20"); appointmentBO.appointment_Date = DateTime.Parse("2222/02/02"); AppointmentBLLFactory appntBLLFactory = new AppointmentBLLFactory(); string deleteApp = appntBLLFactory.CreateAppointmentBLL().DeleteAppointmentBLL().CreateAppointmentDAL().DeleteAppointment(appointmentBO); }
public JsonResult Reject(AppointmentComment comment) { if (comment != null) { comment.CommentType = CommentType.Rejected; comment.CreateBy = CurrentUser.Id; comment.CreateDate = DateTime.Now; comment.ModifyBy = CurrentUser.Id; comment.ModifyDate = DateTime.Now; AppointmentBO.AppointmentCommentInsert(comment); } return(Json(1, JsonRequestBehavior.AllowGet)); }
public JsonResult Accept(int id) { AppointmentBO.AppointmentCommentInsert(new AppointmentComment { CommentType = (int)CommentType.Accepted, Comments = "Accepted", CreateBy = CurrentUser.Id, CreateDate = DateTime.Now, ModifyBy = CurrentUser.Id, ModifyDate = DateTime.Now, AppointmentId = id }); return(Json(1, JsonRequestBehavior.AllowGet)); }
// POST: api/Appointment // Post action which accepts Appointment Business object as parameter and same as return type public AppointmentBO BookAppointment(AppointmentBO appointmentBO) { AppointmentBLLFactory appntBLLFactory = new AppointmentBLLFactory(); //appointmentBO.paitent_ID = 7002; //appointmentBO.doctor_ID = 5006; //appointmentBO.date = DateTime.Parse("2000/10/15"); //appointmentBO.appointment_Date = DateTime.Parse("2010/2/3"); //appointmentBO.timings = TimeSpan.Parse("08:00:00"); AppointmentBO appBO = appntBLLFactory.CreateAppointmentBLL().CreateAppointmentBLL().CreateAppointmentDAL().NewAppointment(appointmentBO); return(appBO); }
//Method to convert Appointment to AppointmentBO, with return type appointmet Business object public AppointmentBO ConvertApmntToBO(Appointment apmnt) { try { AppointmentBO apmntBO = new AppointmentBO(apmnt.Appointment_ID, apmnt.Patient_ID, apmnt.Appointment_Date, apmnt.Timings, apmnt.Doctor_ID, apmnt.Date_Time, apmnt.RequestedReport, apmnt.RequestedReportNotes); return(apmntBO); } catch (Exception e) { AppointmentBO appBO = new AppointmentBO(); return(appBO); } }
protected void btUpdateA_Click(object sender, EventArgs e) { if (Page.IsPostBack) { AppointmentBO AppointmentBO = new AppointmentBO(); DataLayer.Appointment editAppointment = new DataLayer.Appointment(); int AppointmentId = Convert.ToInt32(Session["PrimaryKeyAppointment"]); editAppointment = AppointmentBO.Get(AppointmentId); if (editAppointment == null) { string str = string.Format("Appointment with Id {0} not found for Update.", AppointmentId); lblMsg.Text = str; return; } string AStartFrom = txtAStartFrom.Text.Trim(); if (!string.IsNullOrEmpty(AStartFrom)) { editAppointment.StartFrom = DateTime.Parse(AStartFrom); editAppointment.EndTo = DateTime.Parse(txtAEndTo.Text.Trim()); editAppointment.AppointmentId = long.Parse(ddAppointmentId.SelectedValue); editAppointment.PatientId = long.Parse(ddPatientId.SelectedValue); editAppointment.NoShow = cbANoShow.Checked; editAppointment.Cancelled = cbACancelled.Checked; editAppointment.Active = cbAActive.Checked; editAppointment.DateEntered = DateTime.Now; editAppointment.UserIdEntered = 0; AppointmentBO.Edit(editAppointment); AppointmentBO.Save(); string msg = string.Format("Appointment {0} Updated.", AStartFrom); Response.Redirect("~/AppointmentPages/AppointmentList.aspx?msg=" + msg); } else { string str = string.Format("First Name field Can't be empty."); lblMsg.Text = str; return; } } }
public ActionResult ListOfComment(int id) { var listcomments = AppointmentBO.GetCommentByAppointmentId(id); if (listcomments != null && listcomments.Count > 0) { for (int i = 0; i < listcomments.Count; i++) { listcomments[i].User = UserBO.GetById(listcomments[i].CreateBy); } } else { listcomments = new List <AppointmentComment>(); } return(View(listcomments)); }
public int UpdateAppointment(AppointmentBO AppointmentBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(AppointmentBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_SaveAppointment"; sqlHelper.AddParameter(command, "@userId", AppointmentBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@AppointmentDate", AppointmentBO.AppointmentDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Description", AppointmentBO.AppointmentDescription, ParameterDirection.Input); sqlHelper.AddParameter(command, "@latitude", AppointmentBO.Latitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@longitude", AppointmentBO.Longitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@processName", AppointmentBO.ProcessName, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Source", AppointmentBO.Source, ParameterDirection.Input); sqlHelper.AddParameter(command, "@mobileSyncDate", AppointmentBO.mobileSyncDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@MobileReferenceNo", AppointmentBO.MobReferenceNo, ParameterDirection.Input); return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command))); }