// GET: Order/Index public ActionResult Index() { using (DbModelShop dbModelShops = new DbModelShop()) { return(View(dbModelShops.Items.ToList())); } }
// GET: Order/Invoice public ActionResult Order(int id, Item item) { using (DbModelShop dbModelShops = new DbModelShop()) { if (Session["Invoice"] == null) { List <OrderedItem> Invoice = new List <OrderedItem>(); Invoice.Add(new OrderedItem(dbModelShops.Items.Find(id), 1)); item.AmountPurchased++;//Testing if it works Session["Invoice"] = Invoice; } else { List <OrderedItem> Invoice = (List <OrderedItem>)Session["Invoice"]; int index = isExisting(id); if (index == -1) { Invoice.Add(new OrderedItem(dbModelShops.Items.Find(id), 1)); item.AmountPurchased++; } else { item.AmountPurchased++; Invoice[index].Quantity++; Session["Invoice"] = Invoice; } } return(View("invoice")); } }
public ActionResult Edit(int id, Item item, HttpPostedFileBase file, HttpPostedFileBase file2) { try { if (file != null) { file.SaveAs(HttpContext.Server.MapPath("~/Images/") + file.FileName); item.PicUrl = file.FileName; } if (file2 != null) { file2.SaveAs(HttpContext.Server.MapPath("~/Images/") + file2.FileName); item.AslPicUrl = file2.FileName; } using (DbModelShop dbModelShops = new DbModelShop()) { dbModelShops.Entry(item).State = EntityState.Modified; dbModelShops.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View(item)); } }
public ActionResult Checkout(int id) { using (DbModelShop dbModelShops = new DbModelShop()) { return(View(dbModelShops.Items.Where(x => x.ItemID == id).FirstOrDefault())); } }
public ActionResult ChartFromEF() { using (DbModelShop dbModelShops = new DbModelShop()) { var data = dbModelShops.Items.ToList(); var chart = new Chart(); var area = new ChartArea(); chart.ChartAreas.Add(area); var series = new Series(); foreach (var item in data) { series.Points.AddXY(item.Name, item.AmountPurchased); } series.Label = "#PERCENT{P0}"; //series.Font = new Font("Arial",, 8.0f, FontStyle.Bold); area.AxisX.Title = "Item Name"; area.AxisY.Title = "Amount Purchased"; series.ChartType = SeriesChartType.Column; //Decides which chart type series["PieLabelStyle"] = "Outside"; chart.Series.Add(series); var returnStream = new MemoryStream(); chart.ImageType = ChartImageType.Jpeg; chart.SaveImage(returnStream); returnStream.Position = 0; return(new FileStreamResult(returnStream, "image/png")); } }
public async Task <ActionResult> Search4(HttpPostedFileBase file10, Item items, DefCan.Models.Item ItemModel /*, string SearchString*/) { string SearchString = ""; if (file10 != null) { file10.SaveAs(HttpContext.Server.MapPath("~/Audio/") + file10.FileName); ItemModel.Audio = file10.FileName; SearchString = ItemModel.Audio; } using (DbModelShop dbModelShops = new DbModelShop()) { var item = from m in dbModelShops.Items select m; if (!String.IsNullOrEmpty(SearchString)) { item = item.Where(s => s.Audio.Contains(SearchString)); } return(View(await item.ToListAsync())); } }
public async Task <ActionResult> Search(string searchString)//Search by name { using (DbModelShop dbModelShops = new DbModelShop()) { var item = from m in dbModelShops.Items select m; if (!String.IsNullOrEmpty(searchString)) { item = item.Where(s => s.Name.Contains(searchString)); } return(View(await item.ToListAsync())); } }
public ActionResult Delete(int id, FormCollection collection) { try { // TODO: Add delete logic here using (DbModelShop dbModelShops = new DbModelShop()) { Item item = dbModelShops.Items.Where(x => x.ItemID == id).FirstOrDefault(); dbModelShops.Items.Remove(item); dbModelShops.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Item item, HttpPostedFileBase file, HttpPostedFileBase file2) { try { //if (ModelState.IsValid) //{ if (file != null) { file.SaveAs(HttpContext.Server.MapPath("~/Images/") + file.FileName); item.PicUrl = file.FileName; } if (file2 != null) { file2.SaveAs(HttpContext.Server.MapPath("~/Images/") + file2.FileName); item.AslPicUrl = file2.FileName; } using (DbModelShop dbModelShops = new DbModelShop()) { dbModelShops.Items.Add(item); dbModelShops.SaveChanges(); //return RedirectToAction("Index"); } // } //using (DbModelShop dbModelShops = new DbModelShop()) //{ // dbModelShops.Items.Add(item); //dbModelShops.SaveChanges(); //} // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View(item)); } }