public ReturnUserPermission ListAllControllerName_PermissionByUserID(int userID)
{
List <UserPermission> lstUserPermission = null;
UserPermission userPermission = null;
ReturnUserPermission returnUserMenu = new ReturnUserPermission();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMenu_ListAllControllerName_PermissionByUserID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = userID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstUserPermission = new List <UserPermission>();
while (sqlDr.Read())
{
userPermission = new UserPermission();
userPermission.RoleID = int.Parse(sqlDr["RoleID"].ToString());
userPermission.MenuID = int.Parse(sqlDr["MenuID"].ToString());
userPermission.Permission = sqlDr["Permission"].ToString();
userPermission.ControllerName = sqlDr["ControllerName"].ToString();
lstUserPermission.Add(userPermission);
}
returnUserMenu.Code = "00";
returnUserMenu.Message = "Lấy dữ liệu thành công.";
returnUserMenu.lstUserPermission = lstUserPermission;
}
else
{
returnUserMenu.Code = "01";
returnUserMenu.Message = "Không tồn tại bản ghi nào.";
returnUserMenu.Total = 0;
returnUserMenu.lstUserPermission = null;
}
}
}
}
}
catch (Exception ex)
{
returnUserMenu.Code = "99";
returnUserMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUserMenu.Total = 0;
returnUserMenu.lstUserPermission = null;
mylog4net.Error("", ex);
}
return(returnUserMenu);
}
public static PermisionControllerVM getPermisionControllerViewModel(string controllerName, ReturnUserPermission userPermission)
{
PermisionControllerVM permisionControllerViewModel = new PermisionControllerVM();
permisionControllerViewModel.Code = "00";
permisionControllerViewModel.isAllow_View = false;
permisionControllerViewModel.isAllow_Add = false;
permisionControllerViewModel.isAllow_Edit = false;
permisionControllerViewModel.isAllow_Delete = false;
permisionControllerViewModel.isAllow_Check = false;
if (userPermission == null)
{
return(permisionControllerViewModel);
}
try
{
permisionControllerViewModel.isAllow_View = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(SMCommon.View))) != null ? true : false;
permisionControllerViewModel.isAllow_Add = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(SMCommon.Add))) != null ? true : false;
permisionControllerViewModel.isAllow_Edit = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(SMCommon.Edit))) != null ? true : false;
permisionControllerViewModel.isAllow_Delete = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(SMCommon.Delete))) != null ? true : false;
permisionControllerViewModel.isAllow_Check = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(SMCommon.Check))) != null ? true : false;
}
catch (Exception ex)
{
permisionControllerViewModel.Code = "99";
permisionControllerViewModel.Message = "Lỗi kiểm tra quyền/Error while checking permission! : " + ex.ToString();
permisionControllerViewModel.isAllow_View = false;
permisionControllerViewModel.isAllow_Add = false;
permisionControllerViewModel.isAllow_Edit = false;
permisionControllerViewModel.isAllow_Delete = false;
permisionControllerViewModel.isAllow_Check = false;
}
return(permisionControllerViewModel);
}
public static bool CheckUserPermission(string controllerName, string checkPermission, ReturnUserPermission userPermission)
{
if (userPermission == null)
{
return(false);
}
UserPermission x = userPermission.lstUserPermission.Find(o => (o.ControllerName == controllerName) && (o.Permission.Contains(checkPermission)));
if (x != null)
{
return(true);
}
return(false);
}