protected void btnUpdate_Click(object sender, EventArgs e) { Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); _Bill_Sys_invoice.Updateinvoicepaymnettransaction(txtChequeAmount.Text, txtpaymentdate.Text, txtChequeNumber.Text, txtDescription.Text, txtsoftwarepaymnetid.Text); string szinvoiceid = ""; string ids = txtTransInvoiceId.Text; string[] arrrInvoiceId = ids.Split(','); for (int i = 0; i < arrrInvoiceId.Length; i++) { if (szinvoiceid == "") { szinvoiceid = "'" + arrrInvoiceId[i].ToString() + "'"; } else { szinvoiceid = szinvoiceid + "," + "'" + arrrInvoiceId[i].ToString() + "'"; } } DataSet dspaymentamount = new DataSet(); dspaymentamount = _Bill_Sys_invoice.GetInvoicepaymnetDetails(szinvoiceid); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; ModalPopupExtender1.Show(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["InvoiceID"] != null) { invoiceid = Request.QueryString["InvoiceID"].ToString(); companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; Bill_Sys_invoice _Bill_Sys_Invoice_Generate = new Bill_Sys_invoice(); DataSet dsinvoice = _Bill_Sys_Invoice_Generate.GetInvoicegenerateDetails(invoiceid, companyid); grdinvoicegenerate.DataSource = dsinvoice; grdinvoicegenerate.DataBind(); } }
protected void btndelete_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string szinvoicetransid; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); for (int i = 0; i < grdInvoiceTransaction.Rows.Count; i++) { CheckBox chk = (CheckBox)grdInvoiceTransaction.Rows[i].FindControl("ChkDelete"); if (chk.Checked == true) { szinvoicetransid = grdInvoiceTransaction.DataKeys[i]["INVOICE_TRANS_ID"].ToString(); _Bill_Sys_invoice.deleteinvoiceTransaction(txtCompanyID.Text, szinvoicetransid); } } btninvoiceupdate.Enabled = false; ClearControl(); grdInvoiceTransaction.XGridBindSearch(); usrMessage.PutMessage("Invoice Transaction Deleted successfully"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnSave_Click(object sender, EventArgs e) { string sztotalpaymnetamount; string szinvoiceid = ""; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); string ids = txtTransInvoiceId.Text; string[] arrrInvoiceId = ids.Split(','); ArrayList arrIds = new ArrayList(); for (int i = 0; i < arrrInvoiceId.Length; i++) { arrIds.Add(arrrInvoiceId[i].ToString()); if (szinvoiceid == "") { szinvoiceid = "'" + arrrInvoiceId[i].ToString() + "'"; } else { szinvoiceid = szinvoiceid + "," + "'" + arrrInvoiceId[i].ToString() + "'"; } } hdnBal.Value = lblBalance.Text; sztotalpaymnetamount = _Bill_Sys_invoice.Saveinvoicepaymenttransaction(txtChequeAmount.Text, txtChequeNumber.Text, txtDescription.Text, txtpaymentdate.Text, utxtUserId.Text, arrIds, txtCompanyID.Text, lblBalance.Text); string[] values = sztotalpaymnetamount.Split(','); string returnvalue = values[0]; string szsoftwarepaymentid = values[1]; txtsoftwarepaymnetid.Text = szsoftwarepaymentid; DataSet dspaymentamount = new DataSet(); dspaymentamount = _Bill_Sys_invoice.GetInvoicepaymnetDetails(szinvoiceid); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; ModalPopupExtender1.Show(); grdInvoicegenerate.XGridBindSearch(); grdPaymentTransaction.Visible = true; }
protected void btnupdate_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string sztransid = txtinvoicetransid.Text; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); _Bill_Sys_invoice.UpdateinvoiceTransaction(txtCompanyID.Text, sztransid, txttransactionname.Text, txttransactioncost.Value, ddltype.SelectedItem.ToString()); ClearControl(); grdInvoiceTransaction.XGridBindSearch(); usrMessage.PutMessage("Invoice Transaction Update successfully"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnYes_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string szreturn = ""; hdnPOMValue.Value = "Yes"; string szfilename = ""; string szBillno = ""; string sz_caseid = ""; string szRemoteAddr = Page.Request.ServerVariables["REMOTE_ADDR"].ToString(); btnYes.Attributes.Add("onclick", "YesMassage"); Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); ArrayList arrinvoicebill = new ArrayList(); szfilename = getFileName(); sz_file_path = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_NAME + "/Comman Folder/"; string strBill = ""; DataSet dsinvoiceinfo = new DataSet(); DataSet dsinvoicetransinfo = new DataSet(); dsinvoicetransinfo = _Bill_Sys_invoice.GetInvoiceTransdetails(txtCompanyID.Text, "Software"); double l = 0; for (int i = 0; i < grdInvoice.Rows.Count; i++) { CheckBox chk = (CheckBox)grdInvoice.Rows[i].FindControl("ChkDelete"); if (chk.Checked == true) { szBillno = grdInvoice.DataKeys[i]["SZ_BILL_NUMBER"].ToString(); arrinvoicebill.Add(szBillno); if (strBill == "") { strBill = "'" + grdInvoice.DataKeys[i]["SZ_BILL_NUMBER"].ToString() + "'"; } else { strBill = strBill + "," + "'" + grdInvoice.DataKeys[i]["SZ_BILL_NUMBER"].ToString() + "'"; } if (i == 0) { l = Convert.ToDouble(dsinvoicetransinfo.Tables[0].Rows[0]["mn_cost"]); } else { l = l + Convert.ToDouble(dsinvoicetransinfo.Tables[0].Rows[0]["mn_cost"]); } } } Bill_Sys_invoice _Bill_Sys_invoiceinfo = new Bill_Sys_invoice(); dsinvoiceinfo = _Bill_Sys_invoiceinfo.GetInvoiceInfo(strBill); szreturn = _Bill_Sys_invoice.Saveinvoice(txtCompanyID.Text, utxtUserId.Text, arrinvoicebill, sz_file_path, szfilename, l.ToString(), ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME, szRemoteAddr); if (szreturn == "fail") { } else { string[] values = szreturn.Split(','); string returnvalue = values[0]; string szinvoiceid = values[1]; InvoiceTest(dsinvoiceinfo, szinvoiceid, sz_file_path, szfilename); grdInvoice.XGridBindSearch(); usrMessage.PutMessage("Invoice Status Generated successfully"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void InvoiceTest(DataSet dsinvoiceinfo, string szinvoiceid, string szFilePath, string szFileName) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); DataSet dsinvoicetransinfo = new DataSet(); dsinvoicetransinfo = _Bill_Sys_invoice.GetInvoiceTransdetails(txtCompanyID.Text, "Software"); DataSet dscompanyinfo = new DataSet(); dscompanyinfo = _Bill_Sys_invoice.Getcompanydetails(txtCompanyID.Text); DataSet dscompanyaddrss = new DataSet(); dscompanyaddrss = _Bill_Sys_invoice.Getcompanyaddress("Software"); string strBill = ""; string szfilename; MemoryStream m = new MemoryStream(); iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4, 36, 36, 20, 36); //create pdf float[] widthbase = { 4f }; PdfPTable tblBase = new PdfPTable(widthbase); tblBase.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; tblBase.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; tblBase.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_TOP; tblBase.DefaultCell.Colspan = 1; PdfWriter writer = PdfWriter.GetInstance(document, m); document.Open(); float[] width3 = { 4f }; PdfPTable heading3 = new PdfPTable(width3); heading3.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading3.DefaultCell.Border = Rectangle.NO_BORDER; heading3.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading3.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading3.DefaultCell.Colspan = 1; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_INFO"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 12, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_ADDR"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_ZIP"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase("Phone : " + dscompanyaddrss.Tables[0].Rows[0]["SZ_PHONE_NO"].ToString() + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase("Tax Id : " + dscompanyaddrss.Tables[0].Rows[0]["SZ_TAX_ID"].ToString() + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading3.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_COMPANY_NAME"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 12, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_ADDRESS_STREET"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_COMPANY_ADD"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.DefaultCell.Border = Rectangle.BOTTOM_BORDER; heading3.AddCell(new Phrase("")); tblBase.AddCell(heading3); float[] width2 = { 2f }; PdfPTable heading2 = new PdfPTable(width2); heading2.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading2.DefaultCell.Border = Rectangle.NO_BORDER; heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading2.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_MIDDLE; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading2.AddCell(new Phrase("Invoice Id : " + szinvoiceid + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); //heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; //heading2.AddCell(new Phrase("Date : " + currentdate + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.AddCell(heading2); float[] width1 = { 1f, 3f, 2f, 3f, 3f, 2f }; PdfPTable heading1 = new PdfPTable(width1); heading1.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_MIDDLE; heading1.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_TOP; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading1.DefaultCell.Border = Rectangle.BOX; heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.DefaultCell.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY; heading1.AddCell(new Phrase("Bill Number", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Patient Name[Case No]", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Bill Date", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Date of Service", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Transaction Description", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Cost", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.BackgroundColor = iTextSharp.text.Color.WHITE; int j = 0; double n = 0; for (int i = 0; i < dsinvoiceinfo.Tables[0].Rows.Count; i++) { for (int k = 0; k < dsinvoicetransinfo.Tables[0].Rows.Count; k++) { if (j >= 40) { #region New Page Code j = 0; tblBase.AddCell(heading1); tblBase.WriteSelectedRows(0, -1, document.LeftMargin, document.PageSize.Height - document.TopMargin - heading2.TotalHeight - 1, writer.DirectContent); tblBase = new PdfPTable(widthbase); tblBase.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; tblBase.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; tblBase.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_TOP; tblBase.DefaultCell.Colspan = 1; document.NewPage(); heading3 = new PdfPTable(width3); heading3.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading3.DefaultCell.Border = Rectangle.NO_BORDER; heading3.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading3.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_LEFT; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_INFO"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 12, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_ADDR"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyaddrss.Tables[0].Rows[0]["SZ_COMPANY_ZIP"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase("Phone : " + dscompanyaddrss.Tables[0].Rows[0]["SZ_PHONE_NO"].ToString() + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase("Tax Id : " + dscompanyaddrss.Tables[0].Rows[0]["SZ_TAX_ID"].ToString() + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading3.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_COMPANY_NAME"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 12, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_ADDRESS_STREET"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading3.AddCell(new Phrase(dscompanyinfo.Tables[0].Rows[0]["SZ_COMPANY_ADD"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.DefaultCell.Border = Rectangle.BOTTOM_BORDER; heading3.AddCell(new Phrase("")); tblBase.AddCell(heading3); heading2 = new PdfPTable(width2); heading2.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading2.DefaultCell.Border = Rectangle.NO_BORDER; heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading2.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_MIDDLE; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading2.AddCell(new Phrase("Invoice Id : " + szinvoiceid + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); //heading2.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; //heading2.AddCell(new Phrase("Date : " + currentdate + " ", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.AddCell(heading2); heading1 = new PdfPTable(width1); heading1.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_MIDDLE; heading1.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_TOP; tblBase.DefaultCell.Border = Rectangle.NO_BORDER; heading1.DefaultCell.Border = Rectangle.BOX; heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.DefaultCell.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY; heading1.AddCell(new Phrase("Bill Number", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Patient Name[Case No]", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Bill Date", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Date of Service", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Transaction Description", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase("Cost", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.BackgroundColor = iTextSharp.text.Color.WHITE; #endregion } double sztotalcost = Convert.ToDouble(dsinvoicetransinfo.Tables[0].Rows[k]["mn_cost"]); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading1.AddCell(new Phrase(dsinvoiceinfo.Tables[0].Rows[i]["SZ_BILL_NUMBER"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); heading1.AddCell(new Phrase(dsinvoiceinfo.Tables[0].Rows[i]["SZ_PATIENT_NAME"].ToString() + " " + "[" + dsinvoiceinfo.Tables[0].Rows[i]["SZ_CASE_NO"].ToString() + "]", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.AddCell(new Phrase(dsinvoiceinfo.Tables[0].Rows[i]["DT_BILL_DATE"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; heading1.AddCell(new Phrase(dsinvoiceinfo.Tables[0].Rows[i]["SZ_SERVICE_DATE"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading1.AddCell(new Phrase(dsinvoicetransinfo.Tables[0].Rows[k]["sz_transaction_desc"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading1.AddCell(new Phrase(sztotalcost.ToString("0.00"), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); if (i == 0) { n = Convert.ToDouble(dsinvoicetransinfo.Tables[0].Rows[k]["mn_cost"]); } else { n = n + Convert.ToDouble(dsinvoicetransinfo.Tables[0].Rows[k]["mn_cost"]); } j++; } } heading1.DefaultCell.Border = Rectangle.NO_BORDER; heading1.AddCell(new Phrase("")); heading1.AddCell(new Phrase("")); heading1.AddCell(new Phrase("")); heading1.AddCell(new Phrase("")); heading1.DefaultCell.Border = Rectangle.RECTANGLE; heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; heading1.AddCell(new Phrase("Total Software Cost", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); heading1.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; heading1.AddCell(new Phrase(n.ToString("0.00"), iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.AddCell(heading1); tblBase.WriteSelectedRows(0, -1, document.LeftMargin, document.PageSize.Height - document.TopMargin - heading2.TotalHeight - 1, writer.DirectContent); document.Close(); if (!Directory.Exists(ApplicationSettings.GetParameterValue("PhysicalBasePath") + szFilePath)) { Directory.CreateDirectory(ApplicationSettings.GetParameterValue("PhysicalBasePath") + szFilePath); } //if (!Directory.Exists(sz_file_path)) // Directory.CreateDirectory(sz_file_path); string szSavePath = ApplicationSettings.GetParameterValue("PhysicalBasePath") + szFilePath + szFileName; string szOpenPath = ApplicationSettings.GetParameterValue("DocumentManagerURL") + szFilePath + szFileName; System.IO.File.WriteAllBytes(szSavePath, m.GetBuffer()); ScriptManager.RegisterClientScriptBlock(this, GetType(), "Done", "window.open('" + szOpenPath + "');", true); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } finally { } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btninvoice_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { double blTotalInvoiceAmount = 0; string szinvoiceid = ""; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); ArrayList arrInvoiceid = new ArrayList(); for (int i = 0; i < grdInvoicegenerate.Rows.Count; i++) { CheckBox chk = (CheckBox)grdInvoicegenerate.Rows[i].FindControl("ChkDelete"); if (chk.Checked == true) { if (szinvoiceid == "") { szinvoiceid = grdInvoicegenerate.DataKeys[i]["i_invoice_id"].ToString(); Session["InvoiceID"] = szinvoiceid; } else { szinvoiceid = szinvoiceid + "," + grdInvoicegenerate.DataKeys[i]["i_invoice_id"].ToString(); } blTotalInvoiceAmount = blTotalInvoiceAmount + (Convert.ToDouble(grdInvoicegenerate.DataKeys[i]["MN_INVOICE_AMOUNT"].ToString())); } } if (ddlsoftwarefee.SelectedItem.Text == "Paid") { DataSet dspaymentamount = new DataSet(); dspaymentamount = _Bill_Sys_invoice.GetInvoicepaymnetDetails(szinvoiceid); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); btnSave.Enabled = true; btnUpdate.Enabled = false; txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; } else { txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; grdPaymentTransaction.DataSource = null; grdPaymentTransaction.DataBind(); btnUpdate.Enabled = false; btnSave.Enabled = true; } txtTransInvoiceId.Text = szinvoiceid; lblBalance.Text = blTotalInvoiceAmount.ToString("0.00"); sztotalamount.Text = lblBalance.Text; hdnBal.Value = lblBalance.Text; ModalPopupExtender1.Show(); grdInvoicegenerate.XGridBindSearch(); //usrMessage.PutMessage("Payment Status Update successfully"); //usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); //usrMessage.Show(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnUploadFile_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string sz_file_path = ""; string szfilename = ""; Bill_Sys_invoice objInvoice = new Bill_Sys_invoice(); DataSet dsinvoiceid = new DataSet(); DataSet dspaymentamount = new DataSet(); Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); FileUpload _FileUpload = new FileUpload(); ArrayList arr = new ArrayList(); if (!fuUploadReport.HasFile) { ScriptManager.RegisterClientScriptBlock(this, GetType(), "mm", " alert('please select file from upload Report !');showUploadFilePopup();", true); return; } dsinvoiceid = objInvoice.GetsoftwareInvoiceId(Session["payment_No"].ToString(), txtCompanyID.Text); string strBillNo = ""; string strCaseID = ""; string strsSpecID = ""; sz_file_path = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_NAME + "/Comman Folder/"; if (dsinvoiceid.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsinvoiceid.Tables[0].Rows.Count; i++) { strBillNo = dsinvoiceid.Tables[0].Rows[i][0].ToString(); strCaseID = dsinvoiceid.Tables[0].Rows[i][1].ToString(); strsSpecID = dsinvoiceid.Tables[0].Rows[i][2].ToString(); Bill_Sys_SoftwareInVoice_UploadFile _objUploadFile = new Bill_Sys_SoftwareInVoice_UploadFile(); _objUploadFile.sz_bill_no = strBillNo; _objUploadFile.sz_case_id = strCaseID; _objUploadFile.sz_company_id = txtCompanyID.Text; _objUploadFile.sz_FileName = fuUploadReport.FileName; _objUploadFile.sz_UserId = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString(); _objUploadFile.sz_UserName = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME.ToString(); _objUploadFile.sz_StatusCode = ""; _objUploadFile.sz_flag = "PAY"; _objUploadFile.sz_payment_id = Session["payment_No"].ToString(); _objUploadFile.sz_speciality_id = strsSpecID; _objUploadFile.sz_File_PhysicalPath = sz_file_path; arr.Add(_objUploadFile); } } _FileUpload.InvoiceUploadFile(arr); if (!Directory.Exists(ApplicationSettings.GetParameterValue("BASEPATH") + sz_file_path)) { Directory.CreateDirectory(ApplicationSettings.GetParameterValue("BASEPATH") + sz_file_path); } fuUploadReport.SaveAs(ApplicationSettings.GetParameterValue("BASEPATH") + sz_file_path + fuUploadReport.FileName); dspaymentamount = _Bill_Sys_invoice.GetInvoicepaymnetDetails(Session["InvoiceID"].ToString()); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); usrMessage.PutMessage("File Upload Successfully"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); ModalPopupExtender1.Show(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btndelete_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string szinvoiceidtype = ""; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); for (int i = 0; i < grdInvoicegenerate.Rows.Count; i++) { CheckBox chk = (CheckBox)grdInvoicegenerate.Rows[i].FindControl("ChkDelete"); if (chk.Checked == true) { if (ddlsoftwarefee.SelectedItem.Text == "Paid") { if (szinvoiceidtype == "") { szinvoiceidtype = "'" + grdInvoicegenerate.DataKeys[i]["i_invoice_id"].ToString() + "'"; } else { szinvoiceidtype = szinvoiceidtype + "," + "'" + grdInvoicegenerate.DataKeys[i]["i_invoice_id"].ToString() + "'"; } usrMessage.PutMessage(szinvoiceidtype + " You Can not delete this Paid Invoice..."); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); //string sztype = grdInvoicegenerate.DataKeys[i]["PAID_STATUS"].ToString(); } else { string szinvoiceid = grdInvoicegenerate.DataKeys[i]["i_invoice_id"].ToString(); _Bill_Sys_invoice.deletesoftwareinvoice(szinvoiceid, txtCompanyID.Text); usrMessage.PutMessage("Deleted successfully ..."); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } } } grdInvoicegenerate.XGridBindSearch(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnPaymentDelete_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); for (int i = 0; i < grdPaymentTransaction.Items.Count; i++) { CheckBox chkDelete1 = (CheckBox)grdPaymentTransaction.Items[i].FindControl("chkDelete"); if (chkDelete1.Checked) { _Bill_Sys_invoice.deletesoftwarepaymentTransaction(grdPaymentTransaction.Items[i].Cells[1].Text, txtCompanyID.Text); } } usrMessage.PutMessage("Payment deleted successfully ..."); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); string szinvoiceid = ""; string ids = txtTransInvoiceId.Text; string[] arrrInvoiceId = ids.Split(','); ArrayList arrIds = new ArrayList(); for (int i = 0; i < arrrInvoiceId.Length; i++) { if (szinvoiceid == "") { szinvoiceid = "'" + arrrInvoiceId[i].ToString() + "'"; } else { szinvoiceid = szinvoiceid + "," + "'" + arrrInvoiceId[i].ToString() + "'"; } } DataSet dspaymentamount = new DataSet(); dspaymentamount = _Bill_Sys_invoice.GetInvoicepaymnetDetails(szinvoiceid); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; ModalPopupExtender1.Show(); grdInvoicegenerate.XGridBindSearch(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnSave_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { string sztotalpaymnetamount; string szStorageinvoiceid = ""; Bill_Sys_invoice _Bill_Sys_invoice = new Bill_Sys_invoice(); string ids = txtTranstorageId.Text; string[] arrrStorageInvoiceId = ids.Split(','); ArrayList arrIds = new ArrayList(); for (int i = 0; i < arrrStorageInvoiceId.Length; i++) { arrIds.Add(arrrStorageInvoiceId[i].ToString()); if (szStorageinvoiceid == "") { szStorageinvoiceid = "'" + arrrStorageInvoiceId[i].ToString() + "'"; } else { szStorageinvoiceid = szStorageinvoiceid + "," + "'" + arrrStorageInvoiceId[i].ToString() + "'"; } } szbalance.Text = lblBalance.Text; sztotalpaymnetamount = _Bill_Sys_invoice.Savestoragepaymenttransaction(txtChequeAmount.Text, txtChequeNumber.Text, txtDescription.Text, txtpaymentdate.Text, utxtUserId.Text, arrIds, txtCompanyID.Text, lblBalance.Text); string[] values = sztotalpaymnetamount.Split(','); string returnvalue = values[0]; string szstoragepaymentid = values[1]; txtstoragepaymnetid.Text = szstoragepaymentid; DataSet dspaymentamount = new DataSet(); dspaymentamount = _Bill_Sys_invoice.GetStorageInvoicepaymnetDetails(szStorageinvoiceid); grdPaymentTransaction.DataSource = dspaymentamount; grdPaymentTransaction.DataBind(); usrMessage.PutMessage("Your payment saved"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); txtChequeNumber.Text = ""; txtpaymentdate.Text = ""; txtChequeAmount.Text = ""; txtDescription.Text = ""; ModalPopupExtender1.Show(); grdStoragegenerate.XGridBindSearch(); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }