public List <CommodityStallModel> LowestPriceForItem(int?commodityID) { using (var context = new ShukRoutingContext()) { List <CommodityStall> Stalls = new List <CommodityStall>(); Stalls = context.CommoditiesStalls.AsNoTracking() .Where(s => s.CommodityID == commodityID) .OrderBy(s => s.Price) .ToList(); if (Stalls != null) { List <CommodityStallModel> StallsDisplay = new List <CommodityStallModel>(); foreach (var stall in Stalls) { var Stalldisplay = new CommodityStallModel() { CommodityName = stall.Commodity.CommodityName, StallName = stall.Stall.StallName, Price = stall.Price, Rating = stall.Rating, TimeRegistered = stall.TimeRegistered, Notes = stall.Notes }; StallsDisplay.Add(Stalldisplay); } return(StallsDisplay); } return(null); } }
public List <CommodityStallModel> StallPerCommodityID(int?commodityID) { using (var context = new ShukRoutingContext()) { List <CommodityStall> Stalls = new List <CommodityStall>(); Stalls = context.CommoditiesStalls.AsNoTracking() .Where(s => s.CommodityID == commodityID) .ToList(); if (Stalls != null) { List <CommodityStallModel> stallsDisplay = new List <CommodityStallModel>(); foreach (var stall in Stalls) { var stallDisplay = new CommodityStallModel() { StallName = stall.Stall.StallName, FirstCoord = stall.Stall.FirstCoord, SecondCoord = stall.Stall.SecondCoord }; stallsDisplay.Add(stallDisplay); } return(stallsDisplay); } return(null); } }