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