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;
}
}
