protected void Page_Load(object sender, EventArgs e) { string rcpt_no = ""; string rcpt_Online_no = ""; string date = ""; string cashier_name = ""; string address = ""; string company = ""; string lco_code = ""; string lco_name = ""; string amount = ""; string pay_mode = ""; string cheque_no = ""; string bank_name = ""; string remark = ""; string username = ""; string base_amt = ""; string st = ""; string st_smt = ""; string ec = ""; string ec_amt = ""; string hec = ""; string hec_amt = ""; string et = ""; string et_amt = ""; if (Session["username"] != null && Session["username"] != "") { username = Session["username"].ToString(); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); } if (Session["rcpt_pt_rcptno1"] == null || Session["rcpt_pt_date1"] == null || Session["rcpt_pt_lcocd1"] == null || Session["rcpt_pt_amt1"] == null) { if (Session["rcpt_pt_paymode1"] != null) { if (Session["rcpt_pt_paymode1"].ToString() == "Online") { Response.Redirect("~/Transaction/TransHwayOnlinePayResponse.aspx"); } else { Response.Redirect("~/Transaction/TransHwayLcoPayment.aspx"); } } } if (Session["rcpt_pt_rcptno1"] != null) { rcpt_no = Session["rcpt_pt_rcptno1"].ToString(); } if (Session["rcpt_pt_rcptno2"] != null) { rcpt_Online_no = Session["rcpt_pt_rcptno2"].ToString(); } if (Session["rcpt_pt_date1"] != null) { date = Session["rcpt_pt_date1"].ToString(); } if (Session["rcpt_pt_cashiername"] != null) { cashier_name = Session["rcpt_pt_cashiername"].ToString(); } if (Session["rcpt_pt_address"] != null) { address = Session["rcpt_pt_address"].ToString(); } if (Session["rcpt_pt_company"] != null) { company = Session["rcpt_pt_company"].ToString(); } if (Session["rcpt_pt_lcocd1"] != null) { lco_code = Session["rcpt_pt_lcocd1"].ToString(); } if (Session["rcpt_pt_lconm1"] != null) { lco_name = Session["rcpt_pt_lconm1"].ToString(); } if (Session["rcpt_pt_amt1"] != null) { amount = Session["rcpt_pt_amt1"].ToString(); } if (Session["rcpt_pt_paymode1"] != null) { pay_mode = Session["rcpt_pt_paymode1"].ToString(); } if (Session["rcpt_pt_cheqno1"] != null) { cheque_no = Session["rcpt_pt_cheqno1"].ToString(); } if (Session["rcpt_pt_bnknm1"] != null) { bank_name = Session["rcpt_pt_bnknm1"].ToString(); } if (Session["rcpt_pt_premark1"] != null) { remark = Session["rcpt_pt_premark1"].ToString(); } //if (Session["rcpt_pt_details"] != null) //{ // details = Session["rcpt_pt_details"].ToString(); //} //Session["cashier"] = Session["name"].ToString(); if (pay_mode.Trim() == "Cash") { bank_name = "N/A"; cheque_no = "N/A"; } if (pay_mode.Trim() == "Online") { tdOnline1.Visible = true; tdOnline2.Visible = true; tdOnline3.Visible = true; tdOnline4.Visible = true; tdOnline5.Visible = true; tdOnline6.Visible = true; lblonlineReceipt1.Text = rcpt_Online_no; lblonlineReceipt.Text = rcpt_Online_no; lblonlineR2.Text = rcpt_Online_no; lblonlineR1.Text = rcpt_Online_no; trOnline1.Visible = true; trOnline.Visible = true; trCash.Visible = false; trCash1.Visible = false; lblReceiptTitle.Text = "RECEIPT"; lblReceiptTitle1.Text = "RECEIPT"; lblCashier.Visible = false; lblCashierName.Visible = false; lblCashier1.Visible = false; lblCashierName2.Visible = false; } else { tdOnline1.Visible = false; tdOnline2.Visible = false; tdOnline3.Visible = false; tdOnline4.Visible = false; tdOnline5.Visible = false; tdOnline6.Visible = false; lblonlineReceipt.Text = "N/A"; lblCashierName.Visible = true; lblCashier.Visible = true; lblCashier1.Visible = true; lblCashierName2.Visible = true; lblReceiptTitle.Text = "RECEIPT cum INVOICE"; lblReceiptTitle1.Text = "RECEIPT cum INVOICE"; trOnline1.Visible = false; trCash1.Visible = true; trCash.Visible = true; } lblCompanyName.Text = company; lblCompanyName2.Text = company; lblRemark.Text = remark; lblRemark2.Text = remark; lblBankName.Text = bank_name; lblBankName2.Text = bank_name; lblChequeDDNo.Text = cheque_no; lblChequeDDNo2.Text = cheque_no; lblPaymentMode.Text = pay_mode; lblPaymentMode2.Text = pay_mode; lblAmount.Text = amount; lblAmount2.Text = amount; lblAmout2.Text = amount; hdnAmount.Value = amount; lblAmout1.Text = amount; lblLcoCode.Text = lco_code; lblLcoCode2.Text = lco_code; lblLcoName.Text = lco_name; lblLcoName2.Text = lco_name; lblAddress.Text = address; lblAddress2.Text = address; lblCashierName.Text = cashier_name; lblCashierName2.Text = cashier_name; lblRcptDate.Text = date; lblRcptDate2.Text = date; lblRcptNo.Text = rcpt_no; lblRcptNo2.Text = rcpt_no; Cls_BLL_TransHwayLcoPayment objpan = new Cls_BLL_TransHwayLcoPayment(); string[] details = objpan.getPanDetails(username, company); if (details != null) { try { lblCIN.Text = details[0]; lblCIN2.Text = details[0]; lblPAN.Text = details[1]; lblPAN2.Text = details[1]; lblSTNO.Text = details[2]; lblSTNO2.Text = details[2]; lblCompanyName.Text = details[3]; lblCompanyName2.Text = details[3]; address = details[3]; lblAddress12.Text = address; lblAddress13.Text = address; lblAddress22.Text = address; lblAddress23.Text = address; } catch (Exception ex) { } } Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); string[] tax_det = obj.getTaxDetails(username, rcpt_no); base_amt = tax_det[8]; st = tax_det[2]; st_smt = tax_det[3]; ec = tax_det[4]; ec_amt = tax_det[5]; hec = tax_det[6]; hec_amt = tax_det[7]; et = tax_det[0]; et_amt = tax_det[1]; lblBaseAmt.Text = base_amt; lblBaseAmt2.Text = base_amt; lblST.Text = (Convert.ToDouble(st) * 100).ToString(); lblST2.Text = (Convert.ToDouble(st) * 100).ToString(); lblSTAmt.Text = st_smt; lblSTAmt2.Text = st_smt; lblHEC.Text = (Convert.ToDouble(hec) * 100).ToString(); lblHEC2.Text = (Convert.ToDouble(hec) * 100).ToString(); lblHECAmt.Text = hec_amt; lblHECAmt2.Text = hec_amt; lblEC.Text = (Convert.ToDouble(ec) * 100).ToString(); lblEC2.Text = (Convert.ToDouble(ec) * 100).ToString(); lblECAmt.Text = ec_amt; lblECAmt2.Text = ec_amt; lblET.Text = (Convert.ToDouble(et) * 100).ToString(); lblET2.Text = (Convert.ToDouble(et) * 100).ToString(); lblETAmt.Text = et_amt; lblETAmt2.Text = et_amt; if (et == "0") { tr1.Visible = false; trET.Visible = false; } else { tr1.Visible = true; trET.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { String TransId = ""; lblmsg.Visible = false; try { if (Request.QueryString["transid"].ToString() == "") { lblmsg.Visible = true; lblmsg.Text = "Transaction id cannot be null"; return; } } catch { lblmsg.Visible = true; lblmsg.Text = "Invalid URL"; return; } TransId = Request.QueryString["transid"].ToString(); string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim(); OracleConnection con = new OracleConnection(strCon); try { double Amount = 0; string User = ""; string lcoCode = ""; string Remark = ""; string username = ""; string rcptno = ""; string BillDeskRef = ""; string Name = ""; try { string str = "select var_lcopay_receiptno , var_billdesk_ref_no, var_lcopay_insby username , b.var_user_userowner," + "a.num_lcopay_amount,a.var_lcopay_remark from aoup_lcopre_lco_online_pay_det a " + "inner join aoup_user_def b on a.var_lcopay_insby=b.var_user_username where trim(var_billdesk_ref_no)=trim('" + TransId + "')"; OracleCommand cmd = new OracleCommand(str, con); con.Open(); OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { username = dr["username"].ToString(); Amount = Convert.ToDouble(dr["num_lcopay_amount"].ToString()); Remark = dr["var_lcopay_remark"].ToString(); BillDeskRef = dr["var_billdesk_ref_no"].ToString(); rcptno = dr["var_lcopay_receiptno"].ToString(); Name = dr["var_user_userowner"].ToString(); } } else { return; } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } Session["rcpt_pt_rcptno1"] = rcptno; Session["rcpt_pt_rcptno2"] = BillDeskRef; Session["rcpt_pt_date1"] = DateTime.Now.ToString("dd/MM/yyyy"); Session["rcpt_pt_cashiername"] = "N/A"; Session["rcpt_pt_address"] = ""; Session["rcpt_pt_company"] = ""; Session["rcpt_pt_lcocd1"] = username; Session["rcpt_pt_lconm1"] = Name; Session["rcpt_pt_amt1"] = Amount; Session["rcpt_pt_paymode1"] = "Online"; Session["rcpt_pt_cheqno1"] = "N/A"; Session["rcpt_pt_bnknm1"] = "N/A"; Session["rcpt_pt_premark1"] = Remark.ToString(); string rcpt_no = ""; string rcpt_Online_no = ""; string date = ""; string cashier_name = ""; string address = ""; string company = ""; string lco_code = ""; string lco_name = ""; string amount = ""; string pay_mode = ""; string cheque_no = ""; string bank_name = ""; string remark = ""; string base_amt = ""; string st = ""; string st_smt = ""; string ec = ""; string ec_amt = ""; string hec = ""; string hec_amt = ""; string et = ""; string et_amt = ""; if (Session["rcpt_pt_rcptno1"] != null) { rcpt_no = Session["rcpt_pt_rcptno1"].ToString(); } if (Session["rcpt_pt_rcptno2"] != null) { rcpt_Online_no = Session["rcpt_pt_rcptno2"].ToString(); } if (Session["rcpt_pt_date1"] != null) { date = Session["rcpt_pt_date1"].ToString(); } if (Session["rcpt_pt_cashiername"] != null) { cashier_name = Session["rcpt_pt_cashiername"].ToString(); } if (Session["rcpt_pt_address"] != null) { address = Session["rcpt_pt_address"].ToString(); } if (Session["rcpt_pt_company"] != null) { company = Session["rcpt_pt_company"].ToString(); } if (Session["rcpt_pt_lcocd1"] != null) { lco_code = Session["rcpt_pt_lcocd1"].ToString(); } if (Session["rcpt_pt_lconm1"] != null) { lco_name = Session["rcpt_pt_lconm1"].ToString(); } if (Session["rcpt_pt_amt1"] != null) { amount = Session["rcpt_pt_amt1"].ToString(); } if (Session["rcpt_pt_paymode1"] != null) { pay_mode = Session["rcpt_pt_paymode1"].ToString(); } if (Session["rcpt_pt_cheqno1"] != null) { cheque_no = Session["rcpt_pt_cheqno1"].ToString(); } if (Session["rcpt_pt_bnknm1"] != null) { bank_name = Session["rcpt_pt_bnknm1"].ToString(); } if (Session["rcpt_pt_premark1"] != null) { remark = Session["rcpt_pt_premark1"].ToString(); } //if (Session["rcpt_pt_details"] != null) //{ // details = Session["rcpt_pt_details"].ToString(); //} //Session["cashier"] = Session["name"].ToString(); if (pay_mode.Trim() == "Cash") { bank_name = "N/A"; cheque_no = "N/A"; } if (pay_mode.Trim() == "Online") { tdOnline1.Visible = true; tdOnline2.Visible = true; tdOnline3.Visible = true; tdOnline4.Visible = true; tdOnline5.Visible = true; tdOnline6.Visible = true; lblonlineReceipt1.Text = rcpt_Online_no; lblonlineReceipt.Text = rcpt_Online_no; lblonlineR2.Text = rcpt_Online_no; lblonlineR1.Text = rcpt_Online_no; trOnline1.Visible = true; trOnline.Visible = true; trCash.Visible = false; trCash1.Visible = false; lblReceiptTitle.Text = "RECEIPT"; lblReceiptTitle1.Text = "RECEIPT"; lblCashier.Visible = false; lblCashierName.Visible = false; lblCashier1.Visible = false; lblCashierName2.Visible = false; } else { tdOnline1.Visible = false; tdOnline2.Visible = false; tdOnline3.Visible = false; tdOnline4.Visible = false; tdOnline5.Visible = false; tdOnline6.Visible = false; lblonlineReceipt.Text = "N/A"; lblCashierName.Visible = true; lblCashier.Visible = true; lblCashier1.Visible = true; lblCashierName2.Visible = true; lblReceiptTitle.Text = "RECEIPT cum INVOICE"; lblReceiptTitle1.Text = "RECEIPT cum INVOICE"; trOnline1.Visible = false; trCash1.Visible = true; trCash.Visible = true; } lblCompanyName.Text = company; lblCompanyName2.Text = company; lblRemark.Text = remark; lblRemark2.Text = remark; lblBankName.Text = bank_name; lblBankName2.Text = bank_name; lblChequeDDNo.Text = cheque_no; lblChequeDDNo2.Text = cheque_no; lblPaymentMode.Text = pay_mode; lblPaymentMode2.Text = pay_mode; lblAmount.Text = amount; lblAmount2.Text = amount; lblAmout2.Text = amount; //hdnAmount.Value = amount; lblAmout1.Text = amount; lblLcoCode.Text = lco_code; lblLcoCode2.Text = lco_code; lblLcoName.Text = lco_name; lblLcoName2.Text = lco_name; lblAddress.Text = address; lblAddress2.Text = address; lblCashierName.Text = cashier_name; lblCashierName2.Text = cashier_name; lblRcptDate.Text = date; lblRcptDate2.Text = date; lblRcptNo.Text = rcpt_no; lblRcptNo2.Text = rcpt_no; Cls_BLL_TransHwayLcoPayment objpan = new Cls_BLL_TransHwayLcoPayment(); string[] details = objpan.getPanDetails(username, company); if (details != null) { try { lblCIN.Text = details[0]; lblCIN2.Text = details[0]; lblPAN.Text = details[1]; lblPAN2.Text = details[1]; lblSTNO.Text = details[2]; lblSTNO2.Text = details[2]; lblCompanyName.Text = details[3]; lblCompanyName2.Text = details[3]; address = details[3]; lblAddress12.Text = address; lblAddress13.Text = address; lblAddress22.Text = address; lblAddress23.Text = address; } catch (Exception ex) { } } Cls_BLL_TransHwayLcoPayment obj = new Cls_BLL_TransHwayLcoPayment(); string[] tax_det = obj.getTaxDetails(username, rcpt_no); base_amt = tax_det[8]; st = tax_det[2]; st_smt = tax_det[3]; ec = tax_det[4]; ec_amt = tax_det[5]; hec = tax_det[6]; hec_amt = tax_det[7]; et = tax_det[0]; et_amt = tax_det[1]; lblBaseAmt.Text = base_amt; lblBaseAmt2.Text = base_amt; lblST.Text = (Convert.ToDouble(st) * 100).ToString(); lblST2.Text = (Convert.ToDouble(st) * 100).ToString(); lblSTAmt.Text = st_smt; lblSTAmt2.Text = st_smt; lblHEC.Text = (Convert.ToDouble(hec) * 100).ToString(); lblHEC2.Text = (Convert.ToDouble(hec) * 100).ToString(); lblHECAmt.Text = hec_amt; lblHECAmt2.Text = hec_amt; lblEC.Text = (Convert.ToDouble(ec) * 100).ToString(); lblEC2.Text = (Convert.ToDouble(ec) * 100).ToString(); lblECAmt.Text = ec_amt; lblECAmt2.Text = ec_amt; lblET.Text = (Convert.ToDouble(et) * 100).ToString(); lblET2.Text = (Convert.ToDouble(et) * 100).ToString(); lblETAmt.Text = et_amt; lblETAmt2.Text = et_amt; if (et == "0") { tr1.Visible = false; trET.Visible = false; } else { tr1.Visible = true; trET.Visible = true; } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } Pnltopdf(); }