public List <UserClientPrivilege> GetUserClientPrivileges()
{
try
{
_context = new StratasFairDBEntities();
var objMember = _context.vw_UserClientPrivileges.ToList();
var UserPrivilegeList = new List <UserClientPrivilege>();
foreach (var item in objMember)
{
UserClientPrivilege model = new UserClientPrivilege
{
PageId = item.PageId,
PageName = item.PageName,
PageLink = item.PageLink,
IsChecked = false
};
UserPrivilegeList.Add(model);
}
return(UserPrivilegeList);
}
catch
{
return(new List <UserClientPrivilege>());
}
}
public List <UserClientPrivilege> GetUserClientPrivileges(int UserClientId)
{
try
{
_conString = SqlHelper.GetConnectionString();
SqlParameter prmUserClientId = SqlHelper.CreateParameter("@UserClientId", UserClientId);
SqlParameter prmType = SqlHelper.CreateParameter("@Type", 7);
SqlParameter[] allParams = { prmUserClientId, prmType };
DataSet ds = SqlHelper.ExecuteDataset(_conString, CommandType.StoredProcedure, "Usp_GetClientUser", allParams);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
List <UserClientPrivilege> userClientPrivilegeList = new List <UserClientPrivilege>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
UserClientPrivilege userClientPrivilege = new UserClientPrivilege();
userClientPrivilege.PageId = Convert.ToInt32(dt.Rows[i]["PageId"]);
userClientPrivilege.PageName = dt.Rows[i]["PageName"].ToString();
userClientPrivilege.PageLink = dt.Rows[i]["PageLink"].ToString();
userClientPrivilege.PageLevel = Convert.ToInt32(dt.Rows[i]["Level"]);
userClientPrivilege.ParentPageId = Convert.ToInt32(dt.Rows[i]["ParentPageId"]);
userClientPrivilege.PageLinkIconName = dt.Rows[i]["PageLinkIconName"].ToString();
userClientPrivilegeList.Add(userClientPrivilege);
}
}
return(userClientPrivilegeList);
}
else
{
return(null);
}
}
catch
{
throw;
}
}
