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