thePunderWoman

        internal ACESConfigs getVehicleConfigs(int BaseVehicleID, int SubmodelID) {
            ACESConfigs acesconfigs = new ACESConfigs();
            CurtDevDataContext db = new CurtDevDataContext();
            AAIA.VCDBDataContext vcdb = new AAIA.VCDBDataContext();
            try {
                BaseVehicle bv = db.BaseVehicles.Where(x => x.ID.Equals(BaseVehicleID)).First<BaseVehicle>();
                Submodel submodel = db.Submodels.Where(x => x.ID.Equals(SubmodelID)).First<Submodel>();
                List<ConfigAttributeType> attrtypes = db.ConfigAttributeTypes.Where(x => x.AcesTypeID != null).OrderBy(x => x.sort).ToList<ConfigAttributeType>();
                List<AAIA.VehicleConfig> configs = vcdb.VehicleConfigs.Where(x => x.Vehicle.BaseVehicleID.Equals(bv.AAIABaseVehicleID) && x.Vehicle.SubmodelID.Equals(submodel.AAIASubmodelID)).Distinct().OrderBy(x => x.BodyStyleConfig.BodyTypeID).ToList<AAIA.VehicleConfig>();
                acesconfigs.configs = configs;

thePunderWoman

    <ul class="vehicles" id="vehicleData">
        @foreach(CurtAdmin.BaseVehicle bv in vehicles) {
            <li>@bv.YearID @bv.vcdb_Make.MakeName @bv.vcdb_Model.ModelName
                <ul class="submodels">
                    @foreach(CurtAdmin.Submodel s in bv.vcdb_Vehicles.Where(x => x.SubModelID != null).Select(x => x.Submodel).Distinct().OrderBy(x => x.SubmodelName)) {
                        <li>@s.SubmodelName
                            @if(bv.vcdb_Vehicles.Where(x => x.SubModelID.Equals(s.ID)).Any(x => x.ConfigID != null)) {
                                <a href="#" class="showConfig">Show Configs</a>
                                <table class="configs">
                                    <thead>

thePunderWoman

            List<Part> parts = new List<Part>();
            int partcount = db.CustomerReportParts.Where(x => x.customerID.Equals(customerID)).Select(x => x.partID).Count();

            if (start == null) {
                if (partcount == 0) {
                    parts = db.Parts.OrderBy(x => x.partID).ToList<Part>();
                } else {
                    parts = (from p in db.Parts
                             join crp in db.CustomerReportParts on p.partID equals crp.partID
                             orderby p.partID

thePunderWoman

vehicle = (from ve in db2.vcdb_Vehicles
            where ve.VehicleConfig.VehicleConfigAttributes.Count.Equals(vehicleAttribs.Count)
            && ve.VehicleConfig.VehicleConfigAttributes.All(p => attrIDs.Contains(p.AttributeID))
            select ve).First<vcdb_Vehicle>();

thePunderWoman

select V.VehicleID, V.BaseVehicleID FROM
Vehicle AS V
INNER JOIN BaseVehicle ON V.BaseVehicleID = BaseVehicle.BaseVehicleID
INNER JOIN Year ON BaseVehicle.YearID = Year.YearID
INNER JOIN Make ON BaseVehicle.MakeID = Make.MakeID
INNER JOIN Model ON BaseVehicle.ModelID = Model.ModelID
INNER JOIN Submodel ON V.SubmodelID = Submodel.SubmodelID
WHERE Year.YearID = 2006 AND Make.MakeName = 'Honda' AND Model.ModelName = 'Element'

thePunderWoman

CREATE TABLE vcdb_VehiclePart (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	BaseVehicleID int NOT NULL FOREIGN KEY REFERENCES BaseVehicle (ID),
	SubmodelID int NOT NULL FOREIGN KEY REFERENCES Submodel (ID),
	PartNumber int NOT NULL,
	VehicleConfigID int NULL FOREIGN KEY REFERENCES VehicleConfig (ID)
)
GO

CREATE TABLE VehicleConfig (

thePunderWoman

CREATE TABLE VehicleConfig (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	AAIAVehicleConfigID int NOT NULL
)
GO

CREATE TABLE vcdb_VehiclePart (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	BaseVehicleID int NOT NULL FOREIGN KEY REFERENCES BaseVehicle (ID),
	SubmodelID int NOT NULL FOREIGN KEY REFERENCES Submodel (ID),

thePunderWoman

DECLARE @CursorVar1 CURSOR
DECLARE @CurrentVehicle int
DECLARE @CurrentYear int
DECLARE @CurrentMake int
DECLARE @CurrentModel int

SET @CursorVar1 = CURSOR SCROLL DYNAMIC
FOR
select AAIABaseVehicleID, AAIAYearID, AAIAMakeID, AAIAModelID from AAIABaseVehicle