/// <summary>Initializes a new instance of the <see cref="ShipModel"/> class.</summary>
/// <param name="id">The id.</param>
/// <param name="name">The name.</param>
/// <param name="type">The type.</param>
/// <param name="x">The x.</param>
/// <param name="y">The y.</param>
public ShipModel(int id, string name, ShipTypeModel type, int x, int y)
{
this.Y = y;
this.X = x;
this.Type = type;
this.Name = name;
this.ID = id;
}
/// <summary></summary>
/// <returns>The <see cref="List"/>.</returns>
public List<ShipModel> GetAllShips()
{
List<ShipModel> ships = new List<ShipModel>();
ShipModel shipModel = null;
string query = "select s.*, st.* from Ship s join shiptype st on (s.shiptypetype = st.type) ";
OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection);
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ShipTypeModel.ShipTypeEnum shipType;
ShipTypeModel.ShipTypeEnum.TryParse(reader[2].ToString(), true, out shipType);
ShipTypeModel shipTypeModel = new ShipTypeModel(shipType, Convert.ToInt32(reader[6]), Convert.ToInt32(reader[7]));
shipModel = new ShipModel(Convert.ToInt32(reader[0]), reader[1].ToString(), shipTypeModel, Convert.ToInt32(reader[3]), Convert.ToInt32(reader[4]));
ships.Add(shipModel);
}
return ships;
}
/// <summary>The get ship by id.</summary>
/// <param name="id">The id.</param>
/// <returns>The <see cref="ShipModel"/>.</returns>
public ShipModel GetShipById(int id)
{
ShipModel shipModel = null;
string query = string.Format("select s.*, st.* from Ship s join shiptype st on (s.shiptypetype = st.type) where id = {0}", id);
OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection);
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ShipTypeModel.ShipTypeEnum shipType;
ShipTypeModel.ShipTypeEnum.TryParse(reader[2].ToString(), true, out shipType);
ShipTypeModel shipTypeModel = new ShipTypeModel(shipType, Convert.ToInt32(reader[6]), Convert.ToInt32(reader[7]));
shipModel = new ShipModel(Convert.ToInt32(reader[0]), reader[1].ToString(), shipTypeModel, Convert.ToInt32(reader[3]), Convert.ToInt32(reader[4]));
}
return shipModel;
}
