private void LoadPermissions() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dt = mUserProfile.RetrieveAllPermissions(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { TreeNode childNode = new TreeNode(); childNode.Text = Convert.ToString(dt.Rows[i]["PermissionNo"]); childNode.Value = Convert.ToString(dt.Rows[i]["PermissionId"]); tvPermissions.Nodes.Add(childNode); } } foreach (TreeNode node in tvPermissions.Nodes) { //RemoveNodesLink(node); } }
private void BindReports(int PermissionId) { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mappmanager; // retrieve Reports DataTable dt = mUserProfile.RetrieveUserReportAccess(1, PermissionId); if (dt != null) { tvReports.Nodes.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { TreeNode childNode = new TreeNode(); childNode.Text = Convert.ToString(dt.Rows[i]["Name"]); childNode.Value = Convert.ToString(dt.Rows[i]["ReportId"]); tvReports.Nodes.Add(childNode); } } foreach (TreeNode node in tvReports.Nodes) { RemoveNodesLink(node); } }
private void FillUserProfile() { IUsersProfile mUserProfile = null; try { mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mappmanager; // retrieve List <AccessLevel> AccessLevelList = mUserProfile.SearchAccessLevel("", "Active"); if (AccessLevelList != null) { if (AccessLevelList.Count > 0) { ddlUserProfile.Items.Clear(); ddlUserProfile.DataSource = AccessLevelList; ddlUserProfile.DataTextField = "AccessLevelName"; ddlUserProfile.DataValueField = "Id"; ddlUserProfile.DataBind(); } } ddlUserProfile.Items.Insert(0, new ListItem("-- Select --", "0")); } catch { throw; } }
private void BindReportAccess() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve existing reports DataTable dt = mUserProfile.RetrieveUserReportAccess(1, PermissionId); if (dt != null) { if (dt.Rows.Count > 0) { foreach (TreeNode node in tvReports.Nodes) { node.Checked = true; if (node.ChildNodes.Count > 0) { //Check all the child nodes. foreach (TreeNode childNode in node.ChildNodes) { foreach (DataRow dr in dt.Rows) { if (Convert.ToInt32(childNode.Value) == Convert.ToInt32(dr["ReportId"])) { childNode.Checked = true; } } } } } } } }
private void LoadReports() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dtReports = mUserProfile.RetrieveReports(1); if (dtReports != null) { TreeNode AllNode = new TreeNode(); AllNode.Text = "All Reports"; AllNode.Value = "0"; for (int i = 0; i < dtReports.Rows.Count; i++) { TreeNode childNode = new TreeNode(); childNode.Text = Convert.ToString(dtReports.Rows[i]["Name"]); childNode.Value = Convert.ToString(dtReports.Rows[i]["Id"]); AllNode.ChildNodes.Add(childNode); } AllNode.Expanded = true; tvReports.Nodes.Add(AllNode); } foreach (TreeNode node in tvReports.Nodes) { RemoveNodesLink(node); } }
private void BindLocationsAndDepartments(int PermissionId) { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mappmanager; // retrieve existing locations and departments DataTable dt = mUserProfile.RetrieveUserPermissionAccess(PermissionId); if (dt != null) { if (dt.Rows.Count > 0) { DataTable dtLocations = dt.DefaultView.ToTable(true, "City", "LocationId"); tvLocations.Nodes.Clear(); for (int i = 0; i < dtLocations.Rows.Count; i++) { TreeNode childNode = new TreeNode(); childNode.Text = Convert.ToString(dtLocations.Rows[i]["City"]); childNode.Value = Convert.ToString(dtLocations.Rows[i]["LocationId"]); childNode.Expanded = true; DataRow[] drDept = dt.Select("LocationId = " + Convert.ToString(dtLocations.Rows[i]["LocationId"])); if (drDept.Length > 0) { foreach (DataRow dr in drDept) { TreeNode SubNode = new TreeNode(); SubNode.Text = Convert.ToString(dr["Name"]); SubNode.Value = Convert.ToString(dr["DepartmentId"]); childNode.ChildNodes.Add(SubNode); } } tvLocations.Nodes.Add(childNode); } } } foreach (TreeNode node in tvLocations.Nodes) { RemoveNodesLink(node); } }
private int AddEditAccessLevel() { int id = 0; try { //*** Clients ***// List <AccessLevelDetails> _objAccessLevelList = new List <AccessLevelDetails>(); foreach (TreeNode node in tvPermissions.Nodes) { if (node.Checked == true) { AccessLevelDetails _objAccessLevelDetails = new AccessLevelDetails(AccessLevelId); _objAccessLevelDetails.AccessLevelId = Convert.ToInt32(ddlAccessLevel.SelectedValue); _objAccessLevelDetails.PermissionId = string.IsNullOrEmpty(node.Value) ? 0 : Convert.ToInt32(node.Value); if (UIMODEACCESS == UIMODEACCESS.EDIT) { _objAccessLevelDetails.IsActive = chkActive.Checked; _objAccessLevelDetails.Reason = Convert.ToString(txtReason.Value); } _objAccessLevelDetails.LastUpdateUserId = mAppManager.LoginUser.Id; _objAccessLevelList.Add(_objAccessLevelDetails); } } IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; mUserProfile.AddEditAccessLevelDetails(_objAccessLevelList); id = 1; } catch (ValidationException ve) { throw ve; } catch (Exception ex) { throw ex; } return(id); }
private List <UsersPermission> SearchUsersPermissions() { IUsersProfile service = null; try { //Build the search Entity string Name = txtPermissionNo.Value.Trim(); string Status = ddlStatus.Items[ddlStatus.SelectedIndex].Value; //create a service service = AppService.Create <IUsersProfile>(); service.AppManager = this.mappmanager; this.divMessage.InnerHtml = ""; //Invoke the service method this.UsersPermissionList = service.SearchPermissions(Name, Status); if (UsersPermissionList != null) { // this.ShowHideValidationMessage(false); this.HideIntialView(true); this.hdrGridHeader.InnerText = cntlist + " (" + UsersPermissionList.Count + " " + cntFound + ")"; } } catch (ValidationException ve) { this.DisplayValidationError(ve); this.hdrGridHeader.InnerText = ""; } catch { throw; } finally { if (service != null) { //Dispose the services. service.Dispose(); } } return(UsersPermissionList); }
private void LoadPermission() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dt = mUserProfile.RetrieveUserPermissionById(PermissionId); if (dt != null) { if (dt.Rows.Count > 0) { lblPermissionName.Text = Convert.ToString(dt.Rows[0]["PermissionName"]); this.chkActive.Checked = Convert.ToBoolean(dt.Rows[0]["IsActive"]); } BindPermissonAccess(); BindClientAccess(); BindReportAccess(); } }
private void LoadLocationsAndDepartments() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dtLocations = mUserProfile.RetrieveLocations(); DataTable dtDepts = mUserProfile.RetrieveDepartments(); if (dtLocations != null && dtDepts != null) { for (int i = 0; i < dtLocations.Rows.Count; i++) { TreeNode childNode = new TreeNode(); childNode.Text = Convert.ToString(dtLocations.Rows[i]["City"]); childNode.Value = Convert.ToString(dtLocations.Rows[i]["LocationId"]); childNode.ToolTip = Convert.ToString(dtLocations.Rows[i]["ShortName"]); for (int j = 0; j < dtDepts.Rows.Count; j++) { TreeNode SubNode = new TreeNode(); SubNode.Text = Convert.ToString(dtDepts.Rows[j]["Name"]); SubNode.Value = Convert.ToString(dtDepts.Rows[j]["DepartmentId"]); SubNode.ToolTip = Convert.ToString(dtDepts.Rows[j]["ShortName"]); childNode.ChildNodes.Add(SubNode); } childNode.Expanded = false; tvLocations.Nodes.Add(childNode); } } foreach (TreeNode node in tvLocations.Nodes) { RemoveNodesLink(node); } }
private void LoadAccessLevels() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dt = mUserProfile.RetrieveAllAccessLevel(); if (dt != null) { if (dt.Rows.Count > 0) { ddlAccessLevel.Items.Clear(); ddlAccessLevel.DataSource = dt.DefaultView; ddlAccessLevel.DataTextField = "AccessLevelName"; ddlAccessLevel.DataValueField = "AccessLevelId"; ddlAccessLevel.DataBind(); ddlAccessLevel.Items.Insert(0, new ListItem("-- Select a Access Level --", "0")); } } }
private void LoadAccessLevel() { IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; // retrieve DataTable dt = mUserProfile.RetrieveAccessLevelDetailsById(AccessLevelId); if (dt != null) { if (dt.Rows.Count > 0) { if (Convert.ToInt32(dt.Rows[0]["AccessLevelId"]) != 0) { this.ddlAccessLevel.SelectedValue = Convert.ToString(dt.Rows[0]["AccessLevelId"]); } //this.ddlAccessLevel.Items.FindByValue(Convert.ToString(dt.Rows[0]["AccessLevelId"])).Selected = true; // Checking Permissions List foreach (DataRow dr in dt.Rows) { foreach (TreeNode node in tvPermissions.Nodes) { if (Convert.ToInt32(node.Value) == Convert.ToInt32(dr["PermissionId"])) { node.Checked = true; } } } this.chkActive.Checked = Convert.ToBoolean(dt.Rows[0]["IsActive"]); } } }
private int AddEditPermissions() { int id = 0; try { UsersPermission _objUsersPermission = new UsersPermission(PermissionId); _objUsersPermission.PermissionId = PermissionId; _objUsersPermission.PermissionName = lblPermissionName.Text; _objUsersPermission.LastUpdateUserId = mAppManager.LoginUser.Id; if (UIMODEPERMISSION == UIMODEPERMISSION.EDIT) { _objUsersPermission.IsActive = chkActive.Checked; _objUsersPermission.Reason = Convert.ToString(txtReason.Value); } //*** Locations and Departments ***// List <PermissionAccess> _objPermissionAccessList = new List <PermissionAccess>(); foreach (TreeNode node in tvLocations.Nodes) { //If node has child nodes if (node.Checked == true) //it is better to first check if it is "checked" then proceed to count child nodes { int _objLocationId = string.IsNullOrEmpty(node.Value) ? 0 : Convert.ToInt32(node.Value); if (node.ChildNodes.Count > 0) //check if node has any child nodes { //Check all the child nodes. foreach (TreeNode childNode in node.ChildNodes) { if (childNode.Checked == true) { PermissionAccess _objPermissionAccess = new PermissionAccess(); _objPermissionAccess.LocationId = _objLocationId; _objPermissionAccess.DepartmentId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value); _objPermissionAccessList.Add(_objPermissionAccess); } } } } } //*** Clients ***// List <ClientAccess> _objClientAccessList = new List <ClientAccess>(); foreach (TreeNode node in tvClients.Nodes) { if (node.Checked == true) { if (node.ChildNodes.Count > 0) //check if node has any child nodes { //Check all the child nodes. foreach (TreeNode childNode in node.ChildNodes) { if (childNode.Checked == true) { _objClientAccessList.Add(new ClientAccess { ClientId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value) }); } } } } } //*** Reports ***// List <ReportAccess> _objReportAccessList = new List <ReportAccess>(); foreach (TreeNode node in tvReports.Nodes) { if (node.Checked == true) { if (node.ChildNodes.Count > 0) //check if node has any child nodes { //Check all the child nodes. foreach (TreeNode childNode in node.ChildNodes) { if (childNode.Checked == true) { _objReportAccessList.Add(new ReportAccess { ReportId = string.IsNullOrEmpty(childNode.Value) ? 0 : Convert.ToInt32(childNode.Value) }); } } } } } IUsersProfile mUserProfile = null; mUserProfile = AppService.Create <IUsersProfile>(); mUserProfile.AppManager = this.mAppManager; mUserProfile.AddEditUserPermissions(_objUsersPermission, _objPermissionAccessList, _objClientAccessList, _objReportAccessList); id = 1; } catch (ValidationException ve) { throw ve; } catch (Exception ex) { throw ex; } return(id); }