public string GetDistrictRestriction(int userID, string appName) { PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext(); clsDistrictRestriction oDist = (from data in prContext.GetTable <tblPI_ApplicationDistrictRestriction>() join users in prContext.GetTable <tblPI_ApplicationUser>() on data.idPI_ApplicationUser equals users.idPI_ApplicationUser join app in prContext.GetTable <tblPI_Application>() on users.idPI_Application equals app.idPI_Application join emp in prContext.GetTable <tblEmployee>() on users.idEmployee equals emp.idEmployee where app.ApplicationName == appName where data.idPI_ApplicationUser == userID orderby data.District select new clsDistrictRestriction { District = data.District }).FirstOrDefault(); return(oDist.District); }
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; }
private void getPieChartData() { ClsPieChart pc = new ClsPieChart(); string userRole = Session["userRole"].ToString().ToLower(); string userLogin = Session["userName"].ToString(); List <ClsPieChart> pieChartdata = new List <ClsPieChart>(); if (userRole == "sales") { pieChartdata = pc.getOnboardingPhaseCountSales(userLogin); PieChart1.DataSource = pieChartdata; } if (userRole == "salesdm") { clsDistrictRestriction RestrictedDistricts = new clsDistrictRestriction(); string district = RestrictedDistricts.GetDistrictRestriction(Session["userName"].ToString(), Session["appName"].ToString()); pieChartdata = pc.getOnboardingPhaseCountDistrict(district); PieChart1.DataSource = pieChartdata; } if (userRole == "salesmanager") { pieChartdata = pc.getOnboardingPhaseCountAll(); PieChart1.DataSource = pieChartdata; } if (userRole == "itba" || userRole == "itadmin" || userRole == "admin") { pieChartdata = pc.getOnboardingPhaseCountITBA(userLogin); PieChart1.DataSource = pieChartdata; } if (userRole == "itmanager") { pieChartdata = pc.getOnboardingPhaseCountAll(); PieChart1.DataSource = pieChartdata; } PieChart1.DataBind(); }
private void getRevChartData() { ClsProjRevChart pr = new ClsProjRevChart(); string userRole = Session["userRole"].ToString().ToLower(); string userLogin = Session["userName"].ToString(); List <ClsProjRevChart> revChartData = new List <ClsProjRevChart>(); if (userRole == "sales") { revChartData = pr.getProjectedRevenueSales(userLogin); ColumnChart.DataSource = revChartData; } if (userRole == "salesdm") { clsDistrictRestriction RestrictedDistricts = new clsDistrictRestriction(); string district = RestrictedDistricts.GetDistrictRestriction(Session["userName"].ToString(), Session["appName"].ToString()); revChartData = pr.getProjectedRevenueDistrict(district); ColumnChart.DataSource = revChartData; } if (userRole == "salesmanager") { revChartData = pr.getProjectedRevenueAll(); ColumnChart.DataSource = revChartData; } if (userRole == "itba" || userRole == "itadmin" || userRole == "admin") { revChartData = pr.getProjectedRevenueITBA(userLogin); ColumnChart.DataSource = revChartData; } if (userRole == "itmanager") { revChartData = pr.getProjectedRevenueAll(); ColumnChart.DataSource = revChartData; } ColumnChart.DataBind(); }
protected void rgUsers_ItemDataBound(object sender, GridItemEventArgs e) { try { var msg = ""; if (e.Item is GridEditFormInsertItem || e.Item is GridDataInsertItem) { UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); //Users RadComboBox cbxUsers = userControl.FindControl("cbxUsers") as RadComboBox; ClsEmployee emp = new ClsEmployee(); List <ClsEmployee> listUsers = emp.GetListClsEmployees(); cbxUsers.DataTextField = "UserName"; cbxUsers.DataValueField = "idEmployee"; cbxUsers.DataSource = listUsers; cbxUsers.DataBind(); //Role string UserRoleHidden = (userControl.FindControl("hdnUserRole") as HiddenField).Value; RadComboBox cbxUserRoles = userControl.FindControl("cbxUserRole") as RadComboBox; String strConnString = ConfigurationManager.ConnectionStrings["PurolatorReportingConnectionString"].ConnectionString; List <clsPI_ApplicationRole> listRoles = clsPI_ApplicationRole.GetApplicationRoles(strConnString, idPI_Application); cbxUserRoles.DataTextField = "RoleName"; cbxUserRoles.DataValueField = "ApplicationRoleId"; cbxUserRoles.DataSource = listRoles; cbxUserRoles.DataBind(); //District RadComboBox cbxDistrict = userControl.FindControl("cbxDistrict") as RadComboBox; List <ClsDistrict> listDistricts = rep.GetDistricts(); cbxDistrict.DataTextField = "District"; cbxDistrict.DataValueField = "District"; cbxDistrict.DataSource = listDistricts; cbxDistrict.DataBind(); } else { if ((e.Item is GridEditFormItem) && (e.Item.IsInEditMode)) { //************First calling dropdown list values selected in pop up edit form**************/ UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); string UserHidden = (userControl.FindControl("hdnUser") as HiddenField).Value; //USER NAME try { RadComboBox cbxUsers = userControl.FindControl("cbxUsers") as RadComboBox; ClsEmployee emp = new ClsEmployee(); List <ClsEmployee> listUsers = emp.GetListClsEmployees(); cbxUsers.DataTextField = "UserName"; cbxUsers.DataValueField = "idEmployee"; cbxUsers.DataSource = listUsers; cbxUsers.DataBind(); cbxUsers.SelectedValue = UserHidden; cbxUsers.Enabled = false; } catch (Exception ex) { msg = ex.Message; } //USER ROLE try { string UserRoleHidden = (userControl.FindControl("hdnUserRole") as HiddenField).Value; RadComboBox cbxUserRoles = userControl.FindControl("cbxUserRole") as RadComboBox; List <clsPI_ApplicationRole> listRoles = clsPI_ApplicationRole.GetApplicationRoles(strConnString, idPI_Application); cbxUserRoles.DataTextField = "RoleName"; cbxUserRoles.DataValueField = "ApplicationRoleId"; cbxUserRoles.DataSource = listRoles; cbxUserRoles.DataBind(); cbxUserRoles.SelectedValue = UserRoleHidden; } catch (Exception ex) { msg = ex.Message; } //User Restrictions try { RadComboBox cbxDistrict = userControl.FindControl("cbxDistrict") as RadComboBox; List <ClsDistrict> listDistricts = rep.GetDistricts(); cbxDistrict.DataTextField = "District"; cbxDistrict.DataValueField = "District"; cbxDistrict.DataSource = listDistricts; cbxDistrict.DataBind(); RequiredFieldValidator rfDistrict = userControl.FindControl("rfDistrict") as RequiredFieldValidator; Label lblDistrict = userControl.FindControl("lblDistrict") as Label; RadComboBox cbxUserRoles = userControl.FindControl("cbxUserRole") as RadComboBox; string UserRoleText = cbxUserRoles.SelectedItem.Text; HiddenField hdApplicationUser = userControl.FindControl("hdnApplicationUser") as HiddenField; int idPI_ApplicationUser = Convert.ToInt16(hdApplicationUser.Value); string appname = Session["appName"].ToString(); switch (UserRoleText.ToLower()) { case "salesdm": string district = ""; //Get District for user if this a Sales District Manager clsDistrictRestriction dr = new clsDistrictRestriction(); district = dr.GetDistrictRestriction(idPI_ApplicationUser, appname); if (district != "") { cbxDistrict.SelectedValue = district; } cbxDistrict.Visible = true; rfDistrict.Enabled = true; lblDistrict.Visible = true; break; default: cbxDistrict.Visible = false; rfDistrict.Enabled = false; lblDistrict.Visible = false; break; } } catch (Exception ex) { msg = ex.Message; } } } } catch (Exception ex) { pnlDanger.Visible = true; lblDanger.Text = GetCurrentMethod() + " - " + ex.Message.ToString(); } }