public IActionResult AddUserPermission(User_SubMenuDTO request)
{
var response = new OperationResponse <bool>();
try
{
response.Data = _userService.AddUserPermission(request);
}
catch (Exception exception)
{
response.State = ResponseState.Error;
response.Messages.Add(exception.Message);
//_logger.LogError(exception, "Error in Delete Bts Pack ==>" + exception.StackTrace, BtsPackId);
}
return(new JsonResult(response));
}
public bool AddUserPermission(User_SubMenuDTO user)
{
if (!DeleteUserPermission(user.UserId))
{
return(false);
}
var command = dbContext.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_user_permission_i";
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@user_id", SqlDbType.Int, 8);
sqlParams[1] = new SqlParameter("@sub_menu_id", SqlDbType.Int, 8);
using (var transaction = new TransactionScope())
{
using (command.Connection)
{
if (command.Connection.State == ConnectionState.Closed)
{
command.Connection.Open();
}
foreach (var subMenuId in user.SubMenuIds)
{
command.Parameters.Clear();
sqlParams[0].Value = user.UserId;
sqlParams[1].Value = subMenuId;
command.Parameters.Add(sqlParams[0]);
command.Parameters.Add(sqlParams[1]);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
}
}
}
transaction.Complete();
}
return(true);
}
