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();
}
}
