private void BindCity()
{
PrtyDetlDAL obj = new PrtyDetlDAL();
var FrmCity = obj.BindFromCity();
drpBaseCity.DataSource = FrmCity;
drpBaseCity.DataTextField = "City_Name";
drpBaseCity.DataValueField = "City_Idno";
drpBaseCity.DataBind();
drpBaseCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindSenderName()
{
PrtyDetlDAL obj = new PrtyDetlDAL();
DataTable SenderName = obj.BindPartynew("BindPartynew", ApplicationFunction.ConnectionString());
ddlParty.DataSource = SenderName;
ddlParty.DataTextField = "Acnt_Name";
ddlParty.DataValueField = "Acnt_Idno";
ddlParty.DataBind();
ddlParty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindGrid()
{
PrtyDetlDAL obj = new PrtyDetlDAL();
DataTable dt = obj.SelectPartyNetBalance("SelectRep", txtDateFrom.Text.Trim(), txtDateTo.Text.Trim(), Convert.ToInt64(ddlParty.SelectedValue), Convert.ToInt64(drpBaseCity.SelectedValue), Convert.ToInt64(ddllorrytype.SelectedValue), ApplicationFunction.ConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
grdMain.DataSource = dt;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record:(" + Convert.ToInt64(dt.Rows.Count) + ")";
imgBtnExcel.Visible = true;
ViewState["Data"] = dt;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record:(0)";
imgBtnExcel.Visible = false;
ViewState["Data"] = null;
}
}
