public async Task<int> UpdateStatusByWarehouseId(bool isValid, int warehouseId)
        {
            using (var conn = GetDBConnection())
            {
                string sqlText = $@"UPDATE warehouse 
                                  SET 
                                  IsValid=@IsValid
                                  WHERE 
                                  WarehouseId=@WarehouseId ";
                return await conn.ExecuteAsync(sqlText, new { IsValid = isValid, WarehouseId = warehouseId });
            }
        }