private void BindGridViewRegion(string search)
{
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForRegionInFilters(LoggedInUser);
DataTable dt = qb.GetValuesfromDB("select * from Region "+query+" order by RegionName asc");
List<Region> _View = dt.ToList<Region>();
GridViewRegion.DataSource = _View.Where(aa => aa.RegionName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewRegion.DataBind();
}
