internal int InsertPatientSummary(HMS_PatientCollectionSummary objSummary) { try { _context.HMS_PatientCollectionSummary.AddObject(objSummary); _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void btnBillAdd_Click(object sender, EventArgs e) { if (txtReceiveAmt.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please input Receive Amount !!')", true); } else if (txtCollectionDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please input Collection Date !!')", true); } else { int patId = Convert.ToInt32(txtId.Text); var visDate = (from date in _context.HMS_PatientInfo where date.PatientID == patId select date).First(); HMS_PatientCollectionSummary objBill = new HMS_PatientCollectionSummary(); objBill.OCODE = ((SessionUser)Session["SessionUser"]).OCode; objBill.PatientID = Convert.ToInt32(txtId.Text); objBill.CollectionDate = Convert.ToDateTime(txtCollectionDate.Text); objBill.CollectionAmount = Convert.ToDecimal(txtReceiveAmt.Text); objBill.ServiceCharge_Percent = Convert.ToDecimal(txtServiceAmt.Text); objBill.Discount_Percent = Convert.ToDecimal(txtDiscountAmt.Text); if (txtDischargDate.Text != "") { DateTime dischrg = Convert.ToDateTime(txtDischargDate.Text); objBill.DisChargeDate = dischrg; TimeSpan difference = dischrg - Convert.ToDateTime(visDate.VisitDate); var days = difference.TotalDays; objBill.Duration = days.ToString(); } objBill.Create_User = ((SessionUser)Session["SessionUser"]).UserId; objBill.Create_Date = DateTime.Now; int result = obj_Bll.InsertCollectionBill(objBill); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully !')", true); int pat_Id = Convert.ToInt32(txtId.Text); BillCalculation(pat_Id); ClearBillUi(); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (btnSubmit.Text == "Submit") { if (txtPatientName.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Patient Name !!')", true); } else if (ddlGender.SelectedItem.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Gender !!')", true); } else if (ddlBloodGrp.SelectedItem.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Blood Group !!')", true); } else if (txtAge.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Age!!')", true); } else if (txtMobile.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Mobile !!')", true); } else if (txtVisitDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Visit Date!!')", true); } else { HMS_PatientInfo objPatient = new HMS_PatientInfo(); objPatient.OCODE = ((SessionUser)Session["SessionUser"]).OCode; objPatient.PatientName = txtPatientName.Text; objPatient.Age = txtAge.Text; objPatient.M_Y_D = ddlAgeFormat.SelectedItem.Text; objPatient.Gender = ddlGender.SelectedItem.Text; objPatient.BloodGroup = ddlBloodGrp.SelectedItem.Text; objPatient.MaritalStatus = ddlMarital.SelectedItem.Text; objPatient.Mobile = txtMobile.Text; objPatient.Address = txtAddress.Text; objPatient.GuardianName = txtGuardian.Text; objPatient.GuardianContactNo = txtEmerContact.Text; objPatient.VisitDate = Convert.ToDateTime(txtVisitDate.Text); objPatient.BillCategoryId = Convert.ToInt32(ddlCategory.SelectedValue.ToString()); objPatient.BillHeadId = Convert.ToInt32(ddlHead.SelectedValue.ToString()); objPatient.Amount = Convert.ToDecimal(txtAmount.Text); objPatient.Bed_CabinNo = txtBedNo.Text; objPatient.RefdBy = txtRefdBy.Text; objPatient.Remarks = txtRemarks.Text; objPatient.Create_User = ((SessionUser)Session["SessionUser"]).UserId; objPatient.Create_Date = DateTime.Now; int result = objPatient_Bll.InsertPatient(objPatient); if (result == 1) { HMS_PatientCollectionSummary objSummary = new HMS_PatientCollectionSummary(); Session["Patient_Id"] = objPatient.PatientID; objSummary.PatientID = objPatient.PatientID; objSummary.CollectionDate = Convert.ToDateTime(txtVisitDate.Text); objSummary.CollectionAmount = Convert.ToDecimal(txtAmount.Text); objSummary.AdvanceAmount = Convert.ToDecimal(txtAmount.Text); objSummary.Discount_Percent = 0; objSummary.ServiceCharge_Percent = 0; objSummary.Create_User = ((SessionUser)Session["SessionUser"]).UserId; objSummary.Create_Date = DateTime.Now; objSummary.OCODE = ((SessionUser)Session["SessionUser"]).OCode; int aResult = objPatient_Bll.InsertPatientSummary(objSummary); //---------------------------------------------------------- HMS_PatientBillInfo objBill = new HMS_PatientBillInfo(); objBill.PatientId = objPatient.PatientID; objBill.Bill_Category_Id = Convert.ToInt32(ddlCategory.SelectedValue.ToString());; objBill.Bill_Head_Id = Convert.ToInt32(ddlHead.SelectedValue.ToString()); objBill.CollectionDate = Convert.ToDateTime(txtVisitDate.Text); objBill.Amount = Convert.ToDecimal(txtAmount.Text); objBill.Qty = 1; objBill.TotalAmount = Convert.ToDecimal(txtAmount.Text); objBill.Create_User = ((SessionUser)Session["SessionUser"]).UserId; objBill.Create_Date = DateTime.Now; objBill.OCODE = ((SessionUser)Session["SessionUser"]).OCode; int bResult = objPatient_Bll.InsertPatientBill(objBill); //--------------------------------------------------------------- if (bResult == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully !')", true); btnSubmit.Text = "Print"; } } } } else { gridPatient.Visible = false; string OCODE = ((SessionUser)Session["SessionUser"]).OCode; int _patientId = Convert.ToInt32(Session["Patient_Id"]); var Patient = objPatient_Bll.GetPatientInfoForReport(_patientId, OCODE).ToList(); if (Patient.Count > 0) { Session["rptDs"] = "ds_PatientInfo"; Session["rptDt"] = Patient; Session["rptFile"] = "/HMS/reports/HMS_Rpt_PatientInfo.rdlc"; // Session["rptTitle"] = "Patient Money Receipt"; string rptDs = Convert.ToString(Session["rptDs"]); var reportDataSource = new ReportDataSource { Name = rptDs, Value = Session["rptDt"] }; ReportViewer2.LocalReport.DataSources.Clear(); ReportViewer2.LocalReport.DataSources.Add(reportDataSource); ReportViewer2.LocalReport.ReportPath = Server.MapPath(Convert.ToString(Session["rptFile"])); //ReportParameter prm_1 = new ReportParameter("datePrint", Convert.ToString(DateTime.Now.Date)); //ReportParameter prm_2 = new ReportParameter("rptTitle", Convert.ToString(Session["rptTitle"])); //ReportViewer2.LocalReport.SetParameters(new ReportParameter[] { prm_1, prm_2 }); ReportViewer2.LocalReport.Refresh(); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No data found!')", true); } } GetPatientInfo(); ClearPatientInfo(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int InsertCollectionBill(HMS_PatientCollectionSummary objColBill) { return(objBill_DAL.InsertCollectionBill(objColBill)); }
internal int InsertPatientSummary(HMS_PatientCollectionSummary objSummary) { return(objPatient_DAL.InsertPatientSummary(objSummary)); }