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