protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.Print == false)
{
imgBtnExcel.Visible = false;
}
//TotalRecords();
this.BindHead();
drpAGrp.Focus();
AcntSubGrpMasterDAL objclsAcntSubGrpMaster = new AcntSubGrpMasterDAL();
var lstGridData = objclsAcntSubGrpMaster.SelectForSearch(Convert.ToString(txtAcntSubGrp.Text.Trim()), Convert.ToInt32(drpAGrp.SelectedValue));
if (lstGridData != null && lstGridData.Count > 0)
{
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
}
}
txtAcntSubGrp.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
}
//private void TotalRecords()
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// lblTotalRecord.Text = "T. Record (s): " + Convert.ToString((from CT in db.AcntSubHeads
// select CT).Count());
// }
//}
private void BindGrid()
{
AcntSubGrpMasterDAL objclsAcntSubGrpMaster = new AcntSubGrpMasterDAL();
var lstGridData = objclsAcntSubGrpMaster.SelectForSearch(Convert.ToString(txtAcntSubGrp.Text.Trim()), Convert.ToInt32(drpAGrp.SelectedValue));
objclsAcntSubGrpMaster = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("S.No", typeof(string));
dt.Columns.Add("Acount Group Name", typeof(string));
dt.Columns.Add("Acount Sub Group Name", typeof(string));
dt.Columns.Add("Status", typeof(string));
int c = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["S.No"] = ++c;
dr["Acount Group Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "ASubHeadName"));
dr["Acount Sub Group Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "AHeadName"));
if (Convert.ToBoolean(DataBinder.Eval(lstGridData[i], "Status")) == true)
{
dr["Status"] = "Active";
}
else
{
dr["Status"] = "Inactive";
}
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}