protected void Page_Load(object sender, EventArgs e) { if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null) { if (Session["FY"] != "" || Session["FY"] != null) { strChetanaCompanyName = Session["ChetanaCompanyName"].ToString(); strFY = Session["FY"].ToString(); } else { Session.Clear(); } } if (!IsPostBack) { txtcustomerid.Focus(); DataSet ds1 = new DataSet(); ds1 = LeadgerDetails.Get_LedgerDetails("CustCode", "All", "fromno", "tono", Convert.ToInt32(strFY)); flag1 = "CustCode"; flag2 = "All"; flag3 = "fromno"; flag4 = "tono"; // ds1 = null; gvLedger.DataSource = ds1; gvLedger.DataBind(); pnlfalse.Visible = true; } }
protected void txtcustomerid_TextChanged(object sender, EventArgs e) { string CustCode = txtcustomerid.Text.ToString().Split(':')[0].Trim(); if (CustCode != "") { DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomerid.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); txtcustomerid.Focus(); DataSet ds = new DataSet(); ds = LeadgerDetails.Get_LedgerDetails(CustCode, "customer", "fromno", "tono", Convert.ToInt32(strFY)); if (ds.Tables[0].Rows.Count > 0) { gvLedger.DataSource = ds; gvLedger.DataBind(); Button1.Visible = true; btnPrint.Visible = true; } else { gvLedger.DataSource = null; gvLedger.DataBind(); MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; } } else { lblCustName.Text = "No such Customer code"; txtcustomerid.Focus(); txtcustomerid.Text = ""; } } else { lblCustName.Text = ""; DataSet ds1 = new DataSet(); ds1 = LeadgerDetails.Get_LedgerDetails("CustCode", "All", "fromno", "tono", Convert.ToInt32(strFY)); gvLedger.DataSource = ds1; gvLedger.DataBind(); } }
protected void btnget_Click(object sender, EventArgs e) { string from = txtFromDate.Text.Split('/')[1].ToString() + "/" + txtFromDate.Text.Split('/')[0].ToString() + "/" + txtFromDate.Text.Split('/')[2]; string to = txtToDate.Text.Split('/')[1].ToString() + "/" + txtToDate.Text.Split('/')[0].ToString() + "/" + txtToDate.Text.Split('/')[2]; DateTime FromDate = Convert.ToDateTime(from); DateTime ToDate = Convert.ToDateTime(to); DataSet ds = new DataSet(); ds = LeadgerDetails.Get_SalesRegister(ddlDetails.SelectedValue.ToString(), FromDate, ToDate, Convert.ToInt32(strFY), "", ddlstate.SelectedValue.ToString()); Session["salesReg"] = ds.Tables[0]; Bind(ds.Tables[0]); }
//string date; #endregion protected void Page_Load(object sender, EventArgs e) { if (Convert.ToDateTime(Request.QueryString["flag6"]) != Convert.ToDateTime(Func.getMonthInNameDate(DateTime.Now.ToString("dd/MM/yyyy")))) { DataSet ds = new DataSet(); ds = LeadgerDetails.Get_LedgerDetails(Request.QueryString["flag1"].ToString().Trim(), Request.QueryString["flag2"].ToString().Trim(), Request.QueryString["flag3"].ToString().Trim() , Request.QueryString["flag4"].ToString().Trim(), Convert.ToInt32(Request.QueryString["flag41"].ToString().Trim()), Convert.ToDateTime(Request.QueryString["flag5"].ToString().Trim()), Convert.ToDateTime(Request.QueryString["flag6"].ToString().Trim())); gvLedger.DataSource = ds; gvLedger.DataBind(); } else { DataSet ds1 = new DataSet(); ds1 = LeadgerDetails.Get_LedgerDetails(Request.QueryString["flag1"].ToString().Trim(), Request.QueryString["flag2"].ToString().Trim(), Request.QueryString["flag3"].ToString().Trim() , Request.QueryString["flag4"].ToString().Trim(), Convert.ToInt32(Request.QueryString["flag41"].ToString().Trim())); gvLedger.DataSource = ds1; gvLedger.DataBind(); } }
protected void btnGetData_Click(object sender, EventArgs e) { string CustCode = txtcustomerid.Text.ToString().Split(':')[0].Trim(); FromDate = Convert.ToDateTime(Func.getMonthInNameDate(txtFromDate.Text.Trim())); ToDate = Convert.ToDateTime(Func.getMonthInNameDate(txttoDate.Text.Trim())); if (CustCode != "") { try { DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomerid.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); txtcustomerid.Focus(); DataSet ds = new DataSet(); ds = LeadgerDetails.Get_LedgerDetails(CustCode, "customer", "fromno", "tono", Convert.ToInt32(strFY), FromDate, ToDate); if (ds.Tables[0].Rows.Count > 0) { gvLedger.DataSource = ds; gvLedger.DataBind(); Button1.Visible = true; btnPrint.Visible = true; flag1 = CustCode; flag2 = "customer"; flag3 = "fromno"; flag4 = "tono"; flag5 = FromDate; flag6 = ToDate; } else { gvLedger.DataSource = null; gvLedger.DataBind(); MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; } } else { lblCustName.Text = "No such Customer code"; txtcustomerid.Focus(); txtcustomerid.Text = ""; } } catch (Exception ex) { } } else { lblCustName.Text = ""; DataSet ds1 = new DataSet(); ds1 = LeadgerDetails.Get_LedgerDetails(CustCode, "All", "fromno", "tono", Convert.ToInt32(strFY), FromDate, ToDate); gvLedger.DataSource = ds1; gvLedger.DataBind(); flag1 = CustCode; flag2 = "All"; flag3 = "fromno"; flag4 = "tono"; flag5 = FromDate; flag6 = ToDate; } }