protected void rgRequests_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { PuroTouchRepository rep = new PuroTouchRepository(); string userName = Session["userName"].ToString(); string userRole = Session["userRole"].ToString().ToLower(); List <ClsDiscoveryRequest> oDRList; //if (userRole == "sales" || userRole == "salesdm" || userRole == "itadmin") switch (userRole) { case "salesdm": clsDistrictRestriction RestrictedDistricts = new clsDistrictRestriction(); string district = RestrictedDistricts.GetDistrictRestriction(Session["userName"].ToString(), Session["appName"].ToString()); oDRList = rep.GetAllDiscoveryRequestsForDistrict(district); break; case "sales": oDRList = rep.GetAllDiscoveryRequestsForSP(userName); break; case "salesmanager": oDRList = rep.GetAllDiscoveryRequests(); break; case "itmanager": oDRList = rep.GetUnassignedDiscoveryRequests(); break; case "itadmin": oDRList = rep.GetAllDiscoveryRequests(); break; default: oDRList = rep.GetAllDiscoveryRequests(userName); break; } rgRequests.DataSource = oDRList; }