/// <summary>
        /// Get Model Variant Detail.
        /// </summary>
        /// <returns></returns>
        public List <ModelVariant> GetModelVariantList()
        {
            List <ModelVariant> modelDataList = new List <ModelVariant>();

            using (OracleConnection con = new OracleConnection(OracleConnectionHelper.ConnectionStringMaster))
            {
                using (OracleCommand cmd = con.CreateCommand())
                {
                    if (con.State != ConnectionState.Open)
                    {
                        con.Open();
                    }
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "TW_GET_MODEL_VARIANT_LIST";
                    cmd.BindByName  = true;
                    cmd.Parameters.Add(OracleConnectionHelper.CreateParam(0, "P_MODEL_VARIANT", OracleDbType.Int32, ParameterDirection.Input));
                    cmd.Parameters.Add(OracleConnectionHelper.CreateParam(null, "REF_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output));
                    using (IDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            ModelVariant modelDetail = new ModelVariant();
                            modelDetail.MakeId                   = reader.GetInt32(reader.GetOrdinal("MAKE_ID"));
                            modelDetail.ModelId                  = reader.GetInt32(reader.GetOrdinal("MODEL_ID"));
                            modelDetail.ModelName                = reader.GetString(reader.GetOrdinal("MODEL_NAME"));
                            modelDetail.VariantName              = reader.GetString(reader.GetOrdinal("VARIANT_NAME"));
                            modelDetail.FuelType                 = reader.GetString(reader.GetOrdinal("FUEL_TYPE"));
                            modelDetail.ComprehensiveRestricted  = reader.GetInt32(reader.GetOrdinal("COMPREHENSIVE_RESTRICTED"));
                            modelDetail.LiabilityRestricted      = reader.GetInt32(reader.GetOrdinal("LIABILITY_RESTRICTED"));
                            modelDetail.ModelDisplaySequenceNo   = reader.GetInt32(reader.GetOrdinal("MODEL_DISPLAY_SEQUENCE_NO"));
                            modelDetail.VariantDisplaySequenceNo = reader.GetInt32(reader.GetOrdinal("VARIANT_DISPLAY_SEQUENCE_NO"));
                            if (!reader.IsDBNull(reader.GetOrdinal("MODEL_IMAGE_URL")))
                            {
                                modelDetail.ModelImageUrl = reader.GetString(reader.GetOrdinal("MODEL_IMAGE_URL"));
                            }
                            if (!reader.IsDBNull(reader.GetOrdinal("SEATING_CAPACITY")))
                            {
                                modelDetail.SetingCapacity = reader.GetInt32(reader.GetOrdinal("SEATING_CAPACITY"));
                            }
                            if (!reader.IsDBNull(reader.GetOrdinal("FAST_LANE_ID")))
                            {
                                modelDetail.FastLaneId = reader.GetDecimal(reader.GetOrdinal("FAST_LANE_ID"));
                            }
                            if (!reader.IsDBNull(reader.GetOrdinal("IS_NEGATIVE_MODEL")))
                            {
                                modelDetail.IsNegativeModel = reader.GetInt16(reader.GetOrdinal("IS_NEGATIVE_MODEL"));
                            }
                            modelDataList.Add(modelDetail);
                        }
                    }
                }
            }
            return(modelDataList);
        }
Exemplo n.º 2
0
    /// <summary>
    /// Synchronizes with the server, then calls run().
    /// </summary>
    /// <returns>
    /// Return true to end turn, false to resynchronize with the
    /// server and run again.
    /// </returns>
    public bool startTurn()
    {
        int count = 0;

        iteration++;

        count   = Client.getPlayerCount(connection);
        players = new Player[count];
        for (int i = 0; i < count; i++)
        {
            players[i] = new Player(Client.getPlayer(connection, i));
        }

        count     = Client.getMappableCount(connection);
        mappables = new Mappable[count];
        for (int i = 0; i < count; i++)
        {
            mappables[i] = new Mappable(Client.getMappable(connection, i));
        }

        count  = Client.getDroidCount(connection);
        droids = new Droid[count];
        for (int i = 0; i < count; i++)
        {
            droids[i] = new Droid(Client.getDroid(connection, i));
        }

        count = Client.getTileCount(connection);
        tiles = new Tile[count];
        for (int i = 0; i < count; i++)
        {
            tiles[i] = new Tile(Client.getTile(connection, i));
        }

        count         = Client.getModelVariantCount(connection);
        modelVariants = new ModelVariant[count];
        for (int i = 0; i < count; i++)
        {
            modelVariants[i] = new ModelVariant(Client.getModelVariant(connection, i));
        }

        if (!initialized)
        {
            initialized = true;
            init();
        }

        return(run());
    }
Exemplo n.º 3
0
  /// <summary>
  /// Synchronizes with the server, then calls run().
  /// </summary>
  /// <returns>
  /// Return true to end turn, false to resynchronize with the 
  /// server and run again.
  /// </returns>
  public bool startTurn()
  {
    int count = 0;
    iteration++;

    count = Client.getPlayerCount(connection);
    players = new Player[count];
    for(int i = 0; i < count; i++)
      players[i] = new Player(Client.getPlayer(connection, i));

    count = Client.getMappableCount(connection);
    mappables = new Mappable[count];
    for(int i = 0; i < count; i++)
      mappables[i] = new Mappable(Client.getMappable(connection, i));

    count = Client.getDroidCount(connection);
    droids = new Droid[count];
    for(int i = 0; i < count; i++)
      droids[i] = new Droid(Client.getDroid(connection, i));

    count = Client.getTileCount(connection);
    tiles = new Tile[count];
    for(int i = 0; i < count; i++)
      tiles[i] = new Tile(Client.getTile(connection, i));

    count = Client.getModelVariantCount(connection);
    modelVariants = new ModelVariant[count];
    for(int i = 0; i < count; i++)
      modelVariants[i] = new ModelVariant(Client.getModelVariant(connection, i));

    if(!initialized)
    {
      initialized = true;
      init();
    }

    return run();
  }