private void BindGrid()
        {
            OpenTyreDAL objDrivMast = new OpenTyreDAL();
            var         lstGridData = objDrivMast.SelectForSearch(Convert.ToInt32(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : ddlDateRange.SelectedValue), Convert.ToInt32(string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : ddlLocation.SelectedValue));

            objDrivMast = null;
            if (lstGridData != null && lstGridData.Count > 0)
            {
                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;
            }
        }
        private void RecordCount()
        {
            OpenTyreDAL objTyreMast = new OpenTyreDAL();
            var         Rec         = objTyreMast.SelectForSearch(Convert.ToInt32(ddlDateRange.SelectedValue), 0);

            objTyreMast = null;
            if (Rec.Count > 0)
            {
                lblTotalRecord.Text = "T. Record (s): " + Rec.Count;
                imgBtnExcel.Visible = false;
            }
            else
            {
                lblTotalRecord.Text = "T. Record (s): 0 ";
            }
        }