public Models.DisplayRestrictedViewModel GetDisplayRestrictedViewModel(Models.RestrictedIndexViewModel rivm)
        {
            CDLContext db = new CDLContext();

            Models.DisplayRestrictedViewModel drvm = new Models.DisplayRestrictedViewModel();
            List<Bridge> bridges = new List<Bridge>();

            //"Straight Truck", "Single Trailer", "Double Trailer"
            if (rivm.SelectedTruckType == "Single Trailer")
                rivm.Type = TruckType.Single;
            else if (rivm.SelectedTruckType == "Double Trailer")
                rivm.Type = TruckType.Double;
            else                                     // (rivm.SelectedTruckType == "Straight Truck")
                rivm.Type = TruckType.Straight;

            drvm.Bridges = bridges;  // list of bridges to populate for new view model

            drvm.Bridges = db.Bridge.Where(b => ((b.Height <= rivm.Height) || b.Weights.Any(w => w.maxWeight <= rivm.Weight && w.TruckType == rivm.Type))
                                              && (b.State.PostalCode == rivm.State && b.City == rivm.City)).ToList();

            return drvm;
        }
        public Models.DisplayRestrictedViewModel GetDisplayRestrictedViewModelByCityAndState(Models.RetrieveByCityViewModel rbcvm)
        {
            CDLContext db = new CDLContext();

            Models.DisplayRestrictedViewModel drvm = new Models.DisplayRestrictedViewModel();
            List<Bridge> bridges = new List<Bridge>();

            drvm.Bridges = bridges;  // list of bridges to populate for new view model

            drvm.Bridges = db.Bridge.Where(b => (b.State.PostalCode == rbcvm.State && b.City == rbcvm.City)).ToList();

            return drvm;
        }