protected void btndoc_Click(object sender, EventArgs e) { string BnkCode = txtbankcodep.Text.Trim(); DataTable dt = new DataTable(); dt = Bank.Get_BankPaymentReport(BnkCode, Convert.ToInt32(txtdoc123.Text.Trim().ToString()), strFY).Tables[0]; if (dt.Rows.Count > 0) { GrdBankPDetails.DataSource = dt; string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower(); if (page != "bankpayment.aspx") { GrdBankPDetails.Columns[7].Visible = false; } GrdBankPDetails.DataBind(); PnlBankPDetails.Visible = true; } else { PnlBankPDetails.Visible = false; MessageBox("Records Not Available "); } }
public void BindBankPDetails() { GrdBankPDetails.DataSource = BankPayment.GetBankPayment((txtbankcodep.Text.Trim()), fdt, tdt); string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower(); if (page != "bankpayment.aspx") { GrdBankPDetails.Columns[7].Visible = false; } GrdBankPDetails.DataBind(); }
protected void btnget_Click(object sender, EventArgs e) { string BnkCode = txtbankcodep.Text.Trim(); frdate = txtFromDate.Text.Split('/')[2] + "/" + txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0]; todate = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0]; tdt = Convert.ToDateTime(todate); fdt = Convert.ToDateTime(frdate); if (tdt >= fdt) { DataSet ds = new DataSet(); ds = BankPayment.GetBankPayment(BnkCode, fdt, tdt); if (ds.Tables[0].Rows.Count > 0) { GrdBankPDetails.DataSource = BankPayment.GetBankPayment(BnkCode, fdt, tdt); string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower(); if (page != "bankpayment.aspx") { GrdBankPDetails.Columns[7].Visible = false; } GrdBankPDetails.DataBind(); PnlBankPDetails.Visible = true; } else { PnlBankPDetails.Visible = false; MessageBox("Records Not Available "); } } else { PnlBankPDetails.Visible = false; MessageBox("From Date is greater than To Date"); } }
protected void btn_Save_Click(object sender, EventArgs e) { docdate = txtdocDate.Text.Split('/')[2] + "/" + txtdocDate.Text.Split('/')[1] + "/" + txtdocDate.Text.Split('/')[0]; ddt = Convert.ToDateTime(docdate); string BankCode = txtbankcode.Text.Trim(); //BankPayment obBnkpay = new BankPayment(); Other_Z.OtherBAL.SaveBankPay obBnkpay = new Other_Z.OtherBAL.SaveBankPay(); Other_Z.OtherBAL ObjBal = new Other_Z.OtherBAL(); // txtdocno.Text = BankPayment.Get_BankPaymentDocNo(BankCode); // txtdocDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); if (Session["UserName"] != null) { try { obBnkpay.BankPaymentID = Convert.ToInt32(LblBankPID.Text); obBnkpay.BankCode = txtbankcode.Text.Trim(); // obBnkpay.DocumentNo = 0; obBnkpay.Serialno = 1; obBnkpay.DocumentDate = ddt; obBnkpay.AccountCode = txtAccode.Text.Trim();; obBnkpay.PersonInCharge = txtperson.Text.Trim(); obBnkpay.ReportCode = txtreportcode.Text.Trim(); obBnkpay.Cash_Cheque_DD = DDLCCDD.SelectedItem.Text; // obBnkpay.Type = txtType.Text.Trim(); obBnkpay.Cheque_DD_NO = txtCCDDNo.Text.Trim(); obBnkpay.Amount = Convert.ToDecimal(txtAmt.Text.Trim()); obBnkpay.DrawnOn = txtDrawnon.Text.Trim(); obBnkpay.Remarks = txtRemark.Text.Trim(); obBnkpay.IsActive = true; obBnkpay.IsChequeBounce = CheckActive.Checked; obBnkpay.CreatedBy = Session["UserName"].ToString(); obBnkpay.strFY = Convert.ToInt32(strFY); if (Session["url"] != null) { obBnkpay.Paymode = "Addcomision"; } else { obBnkpay.Paymode = ""; } //obBnkpay.Save(out DocNo); ObjBal.SaveBankPayment(obBnkpay, out DocNo); txtdocno.Text = Convert.ToString(DocNo); // MessageBox("Record saved successfully"); MessageBox(Constants.save + "\\r\\n Document No: " + (txtdocno.Text)); loder("Last saved Document no. : " + txtdocno.Text); GrdBankPDetails.DataBind(); txtbankcode.Text = ""; lblbankname.Text = ""; txtdocno.Text = ""; txtdocDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); // txtsrno.Text = ""; txtAccode.Text = ""; lblaccname.Text = ""; txtperson.Text = ""; txtreportcode.Text = ""; lblacname.Text = ""; DDLCCDD.SelectedIndex = 0; //txtType.Text = ""; txtCCDDNo.Text = ""; txtAmt.Text = ""; txtDrawnon.Text = ""; lblDrawnonname.Text = ""; txtRemark.Text = ""; Session["url"] = null; CheckActive.Checked = false; lblCustOS.Text = ""; btn_Save.Text = "Save"; PnlAddBankP.Visible = true; Pnldate.Visible = false; PnlBankPDetails.Visible = false; } catch { } } }