private GangTerritory GetGangTerritoryFromReader(SqlDataReader reader) { var gangTerritory = new GangTerritory(); if (reader.Read()) { var value = reader.GetOrdinal("gangId"); gangTerritory.GangId = reader.GetString(value); value = reader.GetOrdinal("gangTerritoryId"); gangTerritory.GangTerritoryId = reader.GetString(value); value = reader.GetOrdinal("description"); gangTerritory.Territory.Description = reader.GetString(value); value = reader.GetOrdinal("name"); gangTerritory.Territory.Name = reader.GetString(value); value = reader.GetOrdinal("income"); gangTerritory.Territory.Income = reader.GetString(value); value = reader.GetOrdinal("territoryId"); gangTerritory.Territory.TerritoryId = reader.GetInt32(value); } else { return(null); } return(gangTerritory); }
public GangTerritory AddGangTerritory([FromUri] string gangId, Territory territory) { var gangTerritory = new GangTerritory() { Territory = territory, GangId = gangId }; return(_territoryManager.AddGangTerritory(gangTerritory)); }
private void InitialGangTerritories(string gangId) { for (int i = 0; i < StartingGangTerritories; i++) { var gangTerritory = new GangTerritory() { GangId = gangId, Territory = GetRandomTerritory(), }; _territoryProvider.AddGangTerritory(gangTerritory); } }
/// <summary> /// Add gang territory /// </summary> /// <param name="gangTerritory">Gang territory</param> /// <returns>Added GangTerritory</returns> public GangTerritory AddGangTerritory(GangTerritory gangTerritory) { using (var connection = new SqlConnection(_connectionString)) { using (var command = new SqlCommand("GangTerritories_Add", connection)) { connection.Open(); command.CommandType = CommandType.StoredProcedure; var gangTerritoryId = command.Parameters.Add("@GangTerritoryId", SqlDbType.NVarChar, 100); gangTerritoryId.Direction = ParameterDirection.Output; gangTerritoryId.Value = string.Empty; command.Parameters.Add("@GangId", SqlDbType.NVarChar, 100).Value = gangTerritory.GangId; command.Parameters.Add("@TerritoryId", SqlDbType.Int).Value = gangTerritory.Territory.TerritoryId; command.ExecuteNonQuery(); gangTerritory.GangTerritoryId = (string)gangTerritoryId.Value; return(gangTerritory); } } }
public void GangTerritoryTest() { var gangId = "1"; var gangTerritory = new GangTerritory() { GangId = gangId, Territory = new Territory() { TerritoryId = 1 } }; Assert.IsTrue(_territoryManager.GetTerritoriesByGangId(gangId).Count() == 0); var addedTerritory = _territoryManager.AddGangTerritory(gangTerritory); Assert.IsTrue(_territoryManager.GetTerritoriesByGangId(gangId).Count() == 1); _territoryManager.RemoveGangTerritory(addedTerritory.GangTerritoryId); Assert.IsTrue(_territoryManager.GetTerritoriesByGangId(gangId).Count() == 0); }
public GangTerritory AddGangTerritory(GangTerritory gangTerritory) { gangTerritory.GangTerritoryId = "AAA-BBB-CCC"; _gangTerritory.Add(gangTerritory); return(gangTerritory); }
/// <summary> /// Add gang territory /// </summary> /// <param name="gangTerritory">Gang territory</param> /// <returns>Added gang territory</returns> public GangTerritory AddGangTerritory(GangTerritory gangTerritory) { return(_territoryProvider.AddGangTerritory(gangTerritory)); }