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