public List <StatusAccessibilityList> GetPageStatusAccessibility(string GroupSNo, string PageSNo)
{
ProcessPermissionList SPL = new ProcessPermissionList();
SqlParameter[] Parameters = { new SqlParameter("@GroupSNo", (GroupSNo)),
new SqlParameter("@PageSNo", Convert.ToInt32(PageSNo)) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetPageStatusAccessibility", Parameters);
var processList = ds.Tables[0].AsEnumerable().Select(e => new StatusAccessibilityList
{
SNo = Convert.ToInt32(e["SNo"]),
StatusSNo = Convert.ToInt32(e["StatusSNo"]),
PageSNo = Convert.ToInt32(e["PageSNo"]),
StatusCode = Convert.ToString(e["StatusCode"]),
IsAllow = Convert.ToBoolean(e["IsAllow"])
});
return(processList.ToList());
}
public KeyValuePair <string, List <ProcessPermissionList> > GetProcessPermission(string UserSNo, string GroupSNo, string PageSNo)
{
ProcessPermissionList SPL = new ProcessPermissionList();
SqlParameter[] Parameters = { new SqlParameter("@UserSNo", (UserSNo)),
new SqlParameter("@GroupSNo", (GroupSNo)),
new SqlParameter("@PageSNo", Convert.ToInt32(PageSNo)) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetProcessPermission", Parameters);
var processList = ds.Tables[0].AsEnumerable().Select(e => new ProcessPermissionList
{
SNo = Convert.ToInt32(e["SNo"]),
UserSNo = Convert.ToInt32(e["UserSNo"]),
SubProcessSNo = Convert.ToInt32(e["SubProcessSNo"]),
SubProcessDisplayName = Convert.ToString(e["SubProcessDisplayName"]),
IsBlocked = Convert.ToBoolean(e["IsBlocked"]),
IsView = Convert.ToBoolean(e["IsView"]),
IsEdit = Convert.ToBoolean(e["IsEdit"])
});
return(new KeyValuePair <string, List <ProcessPermissionList> >("SNo", processList.AsQueryable().ToList()));
}
