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); }