Exemplo n.º 1
0
    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);
    }
Exemplo n.º 2
0
    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;
    }
Exemplo n.º 3
0
    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();
    }
Exemplo n.º 4
0
    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();
    }
Exemplo n.º 5
0
    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();
        }
    }