//Roles
public static Boolean GetUserPermissions(AccountViewModel account, RoleViewModel_Roles roles, string ConnectionString)
{
if (account.AccountID == null)
{
account.Errors.Add("Invalid Account ID");
}
return(roles.Errors.Count > 0 || account.Errors.Count > 0 ? false : AccountDataAccess.GetUserPermissions(account, roles, ConnectionString));
}
//Roles
public static Boolean GetUserPermissions(AccountViewModel view, RoleViewModel_Roles roles, string ConnectionString)
{
List <RoleViewModel_Permission> permissions = new List <RoleViewModel_Permission>();
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spRoles_GetUserPermissions");
dataAccess.SetParamater_Input("@AccountID", view.AccountID, SqlDbType.Int);
DataTable dt = dataAccess.ExcuteQuery();
foreach (DataRow row in dt.Rows)
{
if (roles.roles.FindLast(x => x.RoleID == (int?)row["RoleID"]) == null)
{
roles.roles.Add(new RoleViewModel_Role()
{
RoleID = (int?)row["RoleID"], RoleName = (string)row["RoleName"], ExpirationDate = (DateTime)row["ExperationDate"]
});
}
roles.roles.FindLast(x => x.RoleID == (int?)row["RoleID"]).Permissions.Add(new RoleViewModel_Permission()
{
PermissionID = (int?)row["PermissionID"],
PermissionName = (string)row["PermissionName"],
Controller = (string)row["Controller"],
Action = (string)row["Action"],
Priority = (int?)row["PermissionPriority"],
PermissionGroup = new RoleViewModel_PermissionGroup()
{
PermissionGroupID = (int?)row["PermissionGroupID"],
PermissionGroupName = (string)row["PermissionGroupName"],
Priority = (int?)row["PermissionGroupPriority"],
}
});
}
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
public static Boolean GetRoless(RoleViewModel_Roles view, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spRoles_GetRoles");
DataTable dt = dataAccess.ExcuteQuery();
foreach (DataRow row in dt.Rows)
{
view.roles.Add(new RoleViewModel_Role());
view.roles.Last().RoleID = (int?)row["RoleID"];
view.roles.Last().RoleName = (string)row["RoleName"];
}
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
public static Boolean GetRoless(RoleViewModel_Roles view, string ConnectionString)
{
return(PermissionDataAccess.GetRoless(view, ConnectionString));
}
