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