//Permissions
public static Boolean CreatePermission(RoleViewModel_Permission view, string ConnectionString)
{
if (view.PermissionName == null)
{
view.Errors.Add("Invalid Permission Name");
}
if (view.Action == null)
{
view.Errors.Add("Invalid Action");
}
if (view.Controller == null)
{
view.Errors.Add("Invalid Controller");
}
if (view.PermissionGroup.PermissionGroupID == null)
{
view.Errors.Add("Invalid Permission Group ID");
}
if (view.Priority == null)
{
view.Errors.Add("Invalid Priority");
}
return(view.Errors.Count > 0 ? false : PermissionDataAccess.CreatePermission(view, ConnectionString));
}
public static Boolean DeletePermission(RoleViewModel_Permission view, string ConnectionString)
{
if (view.PermissionID == null)
{
view.Errors.Add("Invalid Permission ID");
}
return(view.Errors.Count > 0 ? false : PermissionDataAccess.DeletePermission(view, ConnectionString));
}
public static Boolean AddPermissionToRole(RoleViewModel_Role role, RoleViewModel_Permission permission, string ConnectionString)
{
if (role.RoleID == null)
{
role.Errors.Add("Invalid Role ID");
}
if (permission.PermissionID == null)
{
permission.Errors.Add("Invalid Permission ID");
}
return(role.Errors.Count > 0 || permission.Errors.Count > 0 ? false : PermissionDataAccess.AddPermissionToRole(role, permission, ConnectionString));
}
public static Boolean DeletePermission(RoleViewModel_Permission view, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spRoles_DeletePermission");
dataAccess.SetParamater_Input("@PermissionID", view.PermissionID, SqlDbType.Int);
dataAccess.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
public static Boolean AddPermissionToRole(RoleViewModel_Role role, RoleViewModel_Permission permission, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spRoles_AddPermissionToRole");
dataAccess.SetParamater_Input("@RoleID", role.RoleID, SqlDbType.Int);
dataAccess.SetParamater_Input("@PermissionID", permission.PermissionID, SqlDbType.Int);
dataAccess.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
role.Errors.Add(ex.Message);
return(false);
}
}
public static Boolean EditPermission(RoleViewModel_Permission view, string ConnectionString)
{
try
{
DataAccess dataAccess = new DataAccess(ConnectionString, "spRoles_EditPermission");
dataAccess.SetParamater_Input("@PermissionID", view.PermissionID, SqlDbType.Int);
dataAccess.SetParamater_Input("@PermissionName", view.PermissionName, SqlDbType.VarChar, 100);
dataAccess.SetParamater_Input("@Action", view.Action, SqlDbType.VarChar, 100);
dataAccess.SetParamater_Input("@Controller", view.Controller, SqlDbType.VarChar, 100);
dataAccess.SetParamater_Input("@PermissionGroupID", view.PermissionGroup.PermissionGroupID, SqlDbType.Int);
dataAccess.SetParamater_Input("@Priority", view.Priority, SqlDbType.Int);
dataAccess.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
view.Errors.Add(ex.Message);
return(false);
}
}
