Beispiel #1
0
        /// <summary>
        /// Gets the model trim equipment table.
        /// </summary>
        /// <param name="modelId">The model id.</param>
        /// <returns>A table with rows for equipment items and a tri state flag for trim level (none - no derivatives have the equipment, some or all)</returns>
        public DataTable GetModelTrimEquipmentTable(int modelId)
        {
            Sproc procedure = new Sproc("TrimEquipmentGrid_S_ByModel", DatabaseName);

            procedure.Parameters.Add("@CARModId", SqlDbType.Int).Value = modelId;

            DataSet trimEquipmentDataSet = procedure.ExecuteDataSet();

            if (trimEquipmentDataSet.Tables.Count > 0)
            {
                return(trimEquipmentDataSet.Tables[0]);
            }

            return(null);
        }