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