public void FillGrid()
{
DataTable dtEmp = objEmp.GetEmployeeMasterForReport(Session["CompId"].ToString());
dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (Session["SessionDepId"] != null)
{
dtEmp = new DataView(dtEmp, "Department_Id in(" + Session["SessionDepId"].ToString().Substring(0, Session["SessionDepId"].ToString().Length - 1) + ")", "", DataViewRowState.CurrentRows).ToTable();
}
if (dtEmp.Rows.Count > 0)
{
Session["dtEmp"] = dtEmp;
gvEmployee.DataSource = dtEmp;
gvEmployee.DataBind();
lblTotalRecord.Text = Resources.Attendance.Total_Records + " : " + dtEmp.Rows.Count.ToString() + "";
}
}