protected void btndoc_Click(object sender, EventArgs e)
{
string BnkCode = txtbankcoder.Text.Trim();
DataTable dt = new DataTable();
dt = Bank.Idev_Chetana_BankReceipt_Report(BnkCode, Convert.ToInt32(txtdoc123.Text.Trim().ToString()), strFY).Tables[0];
// Bank.Get_BankPaymentReport(BnkCode, Convert.ToInt32(txtdoc123.Text.Trim().ToString()), strFY).Tables[0];
if (dt.Rows.Count > 0)
{
GrdBankRDetails.DataSource = dt;
string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower();
if (page != "bankreceipt.aspx")
{
// GrdBankRDetails.DataSource = dt;
GrdBankRDetails.Columns[7].Visible = false;
}
GrdBankRDetails.DataBind();
PnlBankRDetails.Visible = true;
}
else
{
PnlBankRDetails.Visible = false;
MessageBox("Records Not Available ");
}
}
public void BindBankRDetails()
{
string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower();
if (page != "bankreceipt.aspx")
{
GrdBankRDetails.DataSource = BankReceipt.GetBankReceipt((txtbankcoder.Text.Trim()), fdt, tdt);
GrdBankRDetails.Columns[7].Visible = false;
}
GrdBankRDetails.DataBind();
}
protected void btnget_Click(object sender, EventArgs e)
{
//Response.Write("Hello");
string BnkCode = txtbankcoder.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 = BankReceipt.GetBankReceipt(BnkCode, fdt, tdt);
if (ds.Tables[0].Rows.Count > 0)
{
GrdBankRDetails.DataSource = ds;
string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString().ToLower();
if (page != "bankreceipt.aspx")
{
GrdBankRDetails.Columns[7].Visible = false;
}
GrdBankRDetails.DataBind();
PnlBankRDetails.Visible = true;
}
else
{
PnlBankRDetails.Visible = false;
MessageBox("Records Not Available ");
}
}
else
{
PnlBankRDetails.Visible = false;
MessageBox("From Date is greater than To Date");
}
txtbankcoder.Focus();
UpdatePanel4.Update();
}
protected void btn_Save_Click(object sender, EventArgs e)
{
int srcptno;
docdate = txtdocDate.Text.Split('/')[2] + "/" + txtdocDate.Text.Split('/')[1] + "/" + txtdocDate.Text.Split('/')[0];
ddt = Convert.ToDateTime(docdate);
string BankCode = txtbankcode.Text.Trim();
if (txtSrcptno.Text.Trim() == "")
{
txtSrcptno.Text = "0";
}
srcptno = Convert.ToInt32(txtSrcptno.Text.Trim());
BankReceipt obBnkrcpt = new BankReceipt();
txtdocno.Text = BankReceipt.Get_BankPaymentDocNo(BankCode);
#region Xml Cash Grid Data Insert With XML Formate
if (PanelPopup.Visible == true)
{
string XMlData;
XmlDocument doc = new XmlDocument();
XmlNode note = doc.CreateElement("r");
XmlNode nd = doc.CreateElement("t");
for (int i = 0; i < grdPopup.Rows.Count; i++)
{
XmlNode elem = doc.CreateElement("d");
HtmlInputCheckBox ch = (HtmlInputCheckBox)grdPopup.Rows[i].FindControl("chk");
if (ch.Checked)
{
nd = doc.CreateElement("n");
nd.InnerText = Convert.ToInt32(ch.Checked).ToString();
elem.AppendChild(nd);
note.AppendChild(elem);
nd = doc.CreateElement("i");
nd.InnerText = Convert.ToInt32(((HiddenField)grdPopup.Rows[i].FindControl("hiddenId")).Value).ToString();
elem.AppendChild(nd);
note.AppendChild(elem);
}
}
obBnkrcpt.UpdatedBy = "!" + note.OuterXml.ToString();
}
#endregion
if (Session["UserName"] != null)
{
try
{
obBnkrcpt.BankReceiptID = Convert.ToInt32(LblBankRID.Text);
obBnkrcpt.BankCode = txtbankcode.Text.Trim();
obBnkrcpt.DocumentNo = Convert.ToInt32(txtdocno.Text.Trim());
obBnkrcpt.SerialNo = 1;
obBnkrcpt.DocumentDate = ddt;
obBnkrcpt.AccountCode = txtAccode.Text.Trim();;
obBnkrcpt.PersonInCharge = txtperson.Text.Trim();
obBnkrcpt.ReportCode = txtreportcode.Text.Trim();
obBnkrcpt.SalesmanReceiptNo = srcptno;
obBnkrcpt.Cash_Cheque_DD = DDLCCDD.SelectedItem.Text;
// obBnkrcpt.Type = txtType.Text.Trim();
obBnkrcpt.Cheque_DD_NO = txtCCDDNo.Text.Trim();
obBnkrcpt.Amount = Convert.ToDecimal(txtAmt.Text.Trim());
obBnkrcpt.DrawnOn = txtDrawnon.Text.Trim();
obBnkrcpt.Remarks = txtRemark.Text.Trim();
obBnkrcpt.Isactive = CheckActive.Checked;
obBnkrcpt.CreatedBy = Session["UserName"].ToString();
obBnkrcpt.strFY = Convert.ToInt32(strFY);
obBnkrcpt.Save(out DocNo);
string AccountName = "";
string Amount = "";
AccountName = txtbankcode.Text.Trim();
partyName = lblaccname.Text.ToString();
Amount = txtAmt.Text.Trim();
docdate1 = txtdocDate.Text.ToString();
if (DocNo.ToString() == "-3")
{
MessageBox("Receipt No Already Used.");
}
else if (DocNo.ToString() == "-2")
{
MessageBox("Receipt No Not allocated to any SalesMan.");
}
else
{
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);
GrdBankRDetails.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 = "";
txtSrcptno.Text = "";
DDLCCDD.SelectedIndex = 0;
// txtType.Text = "";
txtCCDDNo.Text = "";
txtAmt.Text = "";
txtDrawnon.Text = "";
lblDrawnonname.Text = "";
txtRemark.Text = "";
CheckActive.Checked = true;
btn_Save.Text = "Save";
PnlAddBankR.Visible = true;
Pnldate.Visible = false;
PnlBankRDetails.Visible = false;
PanelPopup.Visible = false;
btnCashEntry.Visible = false;
ddlMonth.Visible = false;
if (lblPhone.Text != "")
{
Phone = lblPhone.Text;
}
if (Phone != null)
{
GetHtmlStringA(Phone, Convert.ToString(obBnkrcpt.SalesmanReceiptNo), AccountName, Amount);
}
}
BnkCode = txtbankcoder.Text.Trim();
//Response.Redirect("SendSms.aspx?Phone='8356029474'&DocNo=" + Convert.ToString(DocNo) + "&AccountName='" + AccountName + "'&Amount='" + Amount + "'&BnkCode='" + BnkCode + "'");
}
catch
{
}
}
}
