protected override void Execute(CodeActivityContext context) { ITracingService tracingService = (ITracingService)context.GetExtension <ITracingService>(); IWorkflowContext workflowContext = (IWorkflowContext)context.GetExtension <IWorkflowContext>(); IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)context.GetExtension <IOrganizationServiceFactory>(); IOrganizationService service = serviceFactory.CreateOrganizationService(workflowContext.UserId); tracingService.Trace("Patient Details using input and output parameters Workflow Started."); var patientName = PatientName.Get(context); var dateOfBirth = DateOfBirth.Get(context); var hospital = ((EntityReference)(Hospital.Get(context))).Id; var hospitalid = ((EntityReference)(Hospital.Get(context))).Name; var patientStatus = PatientStatus.Get(context); var hospitalizationRequired = HospitalizationRequired.Get(context); var patientAge = PatientAge.Get(context); var consultationFee = ConsultationFee.Get(context); var estimatedAmount = EstimatedAmount.Get(context); var treatmentCost = ((OptionSetValue)(TreatmentCost.Get(context))).Value; var patientId = PatientInOut.Get(context); tracingService.Trace($"Patient Name : {patientName}, Date Of Birth : {dateOfBirth}, Hospital : {hospital}, Patient Status : {patientStatus}, Hospitalization Required: {hospitalizationRequired}, Patient Age: {patientAge}, Consultation Fee : {consultationFee}, Estimated Amount : {estimatedAmount}, Treatment Cost : {treatmentCost}, Patient ID : {patientId}"); var patientDetails = $"Patient Name : {patientName}, Date Of Birth : {dateOfBirth}, Hospital : {hospital}, Patient Status : {patientStatus}, Hospitalization Required: {hospitalizationRequired}, Patient Age: {patientAge}, Consultation Fee : {consultationFee}, Estimated Amount : {estimatedAmount}, Treatment Cost : {treatmentCost}, Patient ID : {patientId}"; PatientInOut.Set(context, PatientInOut.ToString()); ShowPatientDetails.Set(context, patientDetails); tracingService.Trace("Patient Details using input and output parameters Workflow Ended."); }
//Get contact by ID public ConsultationFee GetConsultationFee(int consulationID) { ConsultationFee consultationFee = null; using (HISDBEntities dc = new HISDBEntities()) { var v = (from cf in dc.ConsultationFees join ct in dc.ConsultationTypes on cf.ConsultTypeID equals ct.ConsultTypeID join u in dc.Users on cf.DoctorID equals u.UserID where cf.ConsultationID.Equals(consulationID) select new { cf, u, ct.ConsultType, }).FirstOrDefault(); if (v != null) { consultationFee = v.cf; consultationFee.DoctorName = HtmlHelpers.HtmlHelpers.GetFullName(v.u.FirstName, v.u.MiddleName, v.u.LastName); consultationFee.ConsultationTypeName = v.ConsultType; } return(consultationFee); } }
public ActionResult Delete(int id) { using (HISDBEntities db = new HISDBEntities()) { ConsultationFee cf = db.ConsultationFees.Where(x => x.ConsultationID == id) .FirstOrDefault <ConsultationFee>(); db.ConsultationFees.Remove(cf); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddModify(ConsultationFee cf) { using (HISDBEntities db = new HISDBEntities()) { if (cf.ConsultationID == 0) { db.ConsultationFees.Add(cf); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(cf).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }