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