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