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