public bool CommodityStallSave(CommodityStallCreateModel commodityStallCreateModel)
{
if (commodityStallCreateModel.CommodityID != null)
{
if (commodityStallCreateModel != null)
{
using (var context = new ShukRoutingContext())
{
var commoditystall = new CommodityStall()
{
CommodityID = commodityStallCreateModel.CommodityID,
StallID = commodityStallCreateModel.StallID,
Price = commodityStallCreateModel.Price,
Rating = commodityStallCreateModel.Rating,
TimeRegistered = DateTime.Now,
Notes = commodityStallCreateModel.Notes
};
commoditystall.Commodity = context.Commodities.Find(commodityStallCreateModel.CommodityID);
commoditystall.Stall = context.Stalls.Find(commodityStallCreateModel.StallID);
context.CommoditiesStalls.Add(commoditystall);
context.SaveChanges();
return(true);
}
}
return(false);
}
else
{
return(false);
}
}
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);
}
}
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 IEnumerable <CommodityModel> GetCommoditiesNamesForLayout()
{
using (var context = new ShukRoutingContext())
{
var commodityNames = context.Commodities.AsNoTracking()
.OrderBy(x => x.CommodityName)
.Select(x => new CommodityModel()
{
CommodityID = x.CommodityID,
CommodityName = x.CommodityName
}).ToList();
return(commodityNames);
}
}
public bool SaveNewCommodity(CommodityModel commodity)
{
if (commodity != null)
{
using (var context = new ShukRoutingContext())
{
Commodity Commodity = new Commodity()
{
CommodityID = commodity.CommodityID,
CommodityName = commodity.CommodityName
};
context.Commodities.Add(Commodity);
context.SaveChanges();
}
return(true);
}
return(false);
}
public bool SaveNewStall(StallModel stall)
{
if (stall != null) // maybe take out
{
using (var context = new ShukRoutingContext())
{
var Stall = new Stall()
{
StallID = stall.StallID,
StallName = stall.StallName,
FirstCoord = stall.FirstCoord,
SecondCoord = stall.SecondCoord
};
context.Stalls.Add(Stall);
context.SaveChanges();
}
return(true);
}
return(false);
}
public IEnumerable <SelectListItem> GetCommoditiesNames()
{
using (var context = new ShukRoutingContext())
{
List <SelectListItem> commodityNames = context.Commodities.AsNoTracking()
.OrderBy(x => x.CommodityName)
.Select(x => new SelectListItem
{
Value = x.CommodityID.ToString(),
Text = x.CommodityName
}).ToList();
var commodityTip = new SelectListItem
{
Value = null,
Text = "--- select Item ---"
};
commodityNames.Insert(0, commodityTip);
return(new SelectList(commodityNames, "Value", "Text"));
}
}
public IEnumerable <SelectListItem> GetStallNames()
{
using (var context = new ShukRoutingContext())
{
List <SelectListItem> stallNames = context.Stalls.AsNoTracking()
.OrderBy(x => x.StallName)
.Select(x => new SelectListItem
{
Value = x.StallID.ToString(),
Text = x.StallName
}).ToList();
var stalltip = new SelectListItem()
{
Value = null,
Text = "--- select stall ---"
};
stallNames.Insert(0, stalltip);
return(new SelectList(stallNames, "Value", "Text"));
}
}
public List <StallModel> GetStallsDetails(string stallName = null)
{
using (var context = new ShukRoutingContext())
{
List <Stall> stalls = new List <Stall>();
if (stallName == null)
{
stalls = context.Stalls.AsNoTracking()
.ToList();
}
else
{
stalls = context.Stalls.AsNoTracking()
.Where(s => s.StallName == stallName)
.ToList();
}
if (stalls != null)
{
List <StallModel> stallsDisplay = new List <StallModel>();
foreach (var stall in stalls)
{
var stallDisplay = new StallModel()
{
StallID = stall.StallID,
StallName = stall.StallName,
FirstCoord = stall.FirstCoord,
SecondCoord = stall.SecondCoord
};
stallsDisplay.Add(stallDisplay);
}
return(stallsDisplay);
}
return(null);
}
}
public List <CommodityModel> GetCommodities(int?commodityID = null)
{
using (var context = new ShukRoutingContext())
{
List <Commodity> Commodities = new List <Commodity>();
if (commodityID != null)
{
Commodities = context.Commodities.AsNoTracking()
.Where(x => x.CommodityID == commodityID)
.ToList();
}
else
{
Commodities = context.Commodities.AsNoTracking()
.ToList();
}
if (Commodities != null)
{
List <CommodityModel> CommoditiesDisplay = new List <CommodityModel>();
foreach (var commodity in Commodities)
{
var commoditieDisplay = new CommodityModel()
{
CommodityID = commodity.CommodityID,
CommodityName = commodity.CommodityName
};
CommoditiesDisplay.Add(commoditieDisplay);
}
return(CommoditiesDisplay);
}
return(null);
}
}
