public static List <FleetShips> GetFleetShips(int?FleetID)
{
List <FleetShips> Ships = new List <FleetShips>();
using (SqlConnection sqlConn = DatabaseHelper.GetConnection())
using (SqlCommand DBCmd = new SqlCommand("dbo.GetFleetShips", sqlConn))
{
SqlDataReader sqlReader = default(SqlDataReader);
DBCmd.CommandType = CommandType.StoredProcedure;
DBCmd.Parameters.AddWithValue("@FleetID", FleetID);
sqlConn.Open();
sqlReader = DBCmd.ExecuteReader(CommandBehavior.CloseConnection);
while (sqlReader.Read())
{
FleetShips ship = new FleetShips();
ship.UserID = sqlReader.GetInt32Nullable("UserID");
ship.FleetDetailID = sqlReader.GetInt32Nullable("FleetDetailID");
ship.FleetID = sqlReader.GetInt32Nullable("FleetID");
ship.DesignID = sqlReader.GetInt32Nullable("DesignID");
ship.DesignName = sqlReader.GetString("DesignName");
ship.ActualNumber = sqlReader.GetInt32Nullable("ActualNumber");
ship.EffectiveNumber = sqlReader.GetDoubleNullable("EffectiveNumber");
ship.Movement = sqlReader.GetDoubleNullable("Movement");
ship.Colony = sqlReader.GetInt32Nullable("Colony");
ship.Hull = sqlReader.GetDoubleNullable("Hull");
Ships.Add(ship);
}
return(Ships);
}
}
public int GetShipCount(int shipTypeID)
{
var entry = FleetShips.SingleOrDefault(x => x.ShipTypeID == shipTypeID);
if (entry != null)
{
return(entry.Count);
}
else
{
return(0);
}
}
public void SetShipCount(int shipTypeID, int count)
{
var entry = FleetShips.SingleOrDefault(x => x.ShipTypeID == shipTypeID);
if (entry == null)
{
entry = new FleetShip();
entry.ShipTypeID = shipTypeID;
FleetShips.Add(entry);
}
entry.Count = count;
if (count == 0)
{
FleetShips.Remove(entry);
}
}
