//Method to delete Treatment, with string as return type and treatment business object as paratmeter public string DeleteTreatment_DAL(TreatmentBO treatmentBO) { try { TreatmentBO trmntBO = GetTreatment_DAL(treatmentBO); using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Treatment treatment = new Treatment(); //objHmsDataContext.Treatments.SingleOrDefault(trmnt => (trmnt.Treatment_ID == treatmentBO.treatment_ID)); objHmsDataContext.Treatments.DeleteOnSubmit(ConvertBOToTreatment(treatment, trmntBO)); objHmsDataContext.SubmitChanges(); return("Treatment deleted Successfully"); } } catch (Exception e) { return("Unable to delete treatment"); } }
//Method to insert new Treatment,with treatment business object as return type and parameter public TreatmentBO InsertNewTreatment_DAL(TreatmentBO treatmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Treatment treatment = new Treatment(); objHmsDataContext.Treatments.InsertOnSubmit(ConvertBOToTreatment(treatment, treatmentBO)); objHmsDataContext.SubmitChanges(); } return(GetTreatment_DAL(treatmentBO)); } catch (Exception e) { TreatmentBO treatment_BO = new TreatmentBO(); return(treatment_BO); } }
//Method to Update Treatment, with string as return type and Treatment business object as parameter public string UpdateTreatment_DAL(TreatmentBO treatmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Treatment treatment = new Treatment(); treatment = objHmsDataContext.Treatments.SingleOrDefault(trmnt => ((trmnt.Patient_ID == treatmentBO.patient_ID && trmnt.Date_time == treatment.Date_time) || trmnt.Treatment_ID == treatmentBO.treatment_ID)); Treatment updatedTreatment = ConvertBOToTreatment(treatment, treatmentBO); objHmsDataContext.SubmitChanges(); return("Successfully changes submitted"); } } catch (Exception e) { return("Unable to update changes please try again later"); } }
// DELETE: api/Treatment/5 //Deleter action with int as input parameter and void as return type public void Delete(int id) { TreatmentBO treatmentBO = new TreatmentBO(); TreatmentBLLFactory trmntBLLFactory = new TreatmentBLLFactory(); string dleTreatment = trmntBLLFactory.CreateTreatmentBLL().DeleteTreatmentBLL().CreateTreatmentDAL().DeleteTreatment_DAL(treatmentBO); }
// PUT: api/Treatment/5 //Put action which accepts int and string as input parameter with void as return type public void Put(int id, [FromBody] string value) { TreatmentBO treatmentBO = new TreatmentBO(); TreatmentBLLFactory trmntBLLFactory = new TreatmentBLLFactory(); string updates = trmntBLLFactory.CreateTreatmentBLL().UpdateTreatmentBLL().CreateTreatmentDAL().UpdateTreatment_DAL(treatmentBO); }
//Method to convert Treatment to BO public TreatmentBO ConvertTreatmentToBO(Treatment treatment) { TreatmentBO treatmentBO = new TreatmentBO(treatment.Treatment_ID, treatment.Patient_ID, treatment.Nurse_ID, treatment.Prescription_ID, treatment.Room_ID, treatment.Doctor_ID, Convert.ToString(treatment.Start_Time), Convert.ToString(treatment.End_Time)); return(treatmentBO); }
// GET: api/Treatment/5 //Get action which accepts int as input parameter and treatment business object as return type public TreatmentBO Get(int id) { TreatmentBO treatmentBO = new TreatmentBO(); TreatmentBLLFactory trmntBLLFactory = new TreatmentBLLFactory(); TreatmentBO trmntBO = trmntBLLFactory.CreateTreatmentBLL().GetTreatmentBLL().CreateTreatmentDAL().GetTreatment_DAL(treatmentBO); return(trmntBO); }
// POST: api/Treatment //Post action which accepts treatment business object as input parameter and void as return type public void Post([FromBody] TreatmentBO trmnt) { TreatmentBO treatmentBO = new TreatmentBO(); treatmentBO.doctor_ID = 5006; treatmentBO.patient_ID = 7002; treatmentBO.nurse_ID = 3004; TreatmentBLLFactory trmntBLLFactory = new TreatmentBLLFactory(); TreatmentBO trmntBO = trmntBLLFactory.CreateTreatmentBLL().CreateTreatmentBLL().CreateTreatmentDAL().InsertNewTreatment_DAL(treatmentBO); }
//Method to convert BO to Treatment,with treatment r return type and parameters as treatment object, treatment business object public Treatment ConvertBOToTreatment(Treatment treatment, TreatmentBO treatmentBO) { if (treatmentBO.treatment_ID != 0) { treatment.Treatment_ID = treatmentBO.treatment_ID; } if (treatmentBO.doctor_ID != 0) { treatment.Doctor_ID = treatmentBO.doctor_ID; } if (treatmentBO.patient_ID != 0) { treatment.Patient_ID = treatmentBO.patient_ID; } if (treatmentBO.nurse_ID != 0) { treatment.Nurse_ID = treatmentBO.nurse_ID; } if (treatmentBO.Room_ID != null) { treatment.Room_ID = treatmentBO.Room_ID; } if (treatmentBO.prescription_ID != 0) { treatment.Prescription_ID = treatmentBO.prescription_ID; } if (treatmentBO.date_Time != DateTime.MinValue) { treatment.Date_time = treatmentBO.date_Time; } if (!string.IsNullOrEmpty(treatmentBO.startTime)) { treatment.Start_Time = TimeSpan.Parse(treatmentBO.startTime); } if (!string.IsNullOrEmpty(treatmentBO.endTime)) { treatment.End_Time = TimeSpan.Parse(treatmentBO.endTime); } return(treatment); }
//Method to get Treatment details,with treatment business object as return type and parameter public TreatmentBO GetTreatment_DAL(TreatmentBO treatmentBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Treatment treatment = objHmsDataContext.Treatments.SingleOrDefault(trmnt => ((trmnt.Patient_ID == treatmentBO.patient_ID && trmnt.Date_time == treatmentBO.date_Time) || (trmnt.Treatment_ID == treatmentBO.treatment_ID))); return(ConvertTreatmentToBO(treatment)); } } catch (Exception e) { TreatmentBO treatment_BO = new TreatmentBO(); return(treatment_BO); } }