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