//Admin View Order Details by Searching Function
public ActionResult SerachByUserName(string UserName)
{
//string searchUserId = null;
var userName = UserName;
using (DAL.BarContext db = new DAL.BarContext())
{
var userId = HttpContext.User.Identity.GetUserId();
//searchUserId = (from s in db.AspNetUsers
// where s.UserName == UserName
// select s.Id).FirstOrDefault();
}
if (!String.IsNullOrEmpty(userName))
{
using (DAL.BarContext db = new DAL.BarContext())
{
var result = (from s in db.Orders
where s.UserName == userName
select s).ToList();
return(View("Index", result));
}
}
else
{
return(View("Index", new List <Models.Order>()));
}
}
public ActionResult Edit(Models.Item postback)
{
//verify the user input
if (this.ModelState.IsValid)
{
using (DAL.BarContext db = new DAL.BarContext())
{
//catch Item.Id and postback the data of Id
var result = (from s in db.Items where s.Id == postback.Id select s).FirstOrDefault();
//Save the change into Database
result.Name = postback.Name; result.Price = postback.Price;
result.Description = postback.Description; result.OnShelf = postback.OnShelf;
result.DefaultImageURL = postback.DefaultImageURL; result.Category = postback.Category;
result.ImageAlt = postback.ImageAlt;
//Save the change
db.SaveChanges();
//Pop-up "edit successfully" msg and direct to Index
TempData["Message"] = String.Format("Item [{0}] is edited ", postback.Name);
return(RedirectToAction("Index"));
}
}
else
{
return(View(postback));
}
}
public bool AddProduct(int ItemId)
{
var locateItem = this.itemsInCarts
.Where(s => s.Id == ItemId)
.Select(s => s)
.FirstOrDefault();
if (locateItem == default(Models.ShoppingCart.ItemsInCart))
{
using (DAL.BarContext db = new DAL.BarContext())
{
var stuff = (from s in db.Items
where s.Id == ItemId
select s).FirstOrDefault();
if (stuff != default(Models.Item))
{
this.AddProduct(stuff);
}
}
}
else
{
locateItem.Quantity += 1;
}
return(true);
}
//Menu Page
public ActionResult Menu()
{
using (DAL.BarContext db = new DAL.BarContext()) {
var result = (from s in db.Items select s).ToList();
return(View(result));
}
}
// GET: OrderManager
public ActionResult Index()
{
using (DAL.BarContext db = new DAL.BarContext())
{
var result = (from s in db.Orders
select s).ToList();
return(View(result));
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
using (DAL.BarContext db = new DAL.BarContext())
{
Order order = await db.Orders.FindAsync(id);
db.Orders.Remove(order);
await db.SaveChangesAsync();
return(RedirectToAction("YourOrder"));
}
}
public ActionResult Index(Models.OrderLocation postback, Nullable <int> OrderId)
{
if (OrderId == null)
{
if (this.ModelState.IsValid)
{
var currentcart = Models.ShoppingCart.CartActions.CurrentShoppingCart();
var userId = HttpContext.User.Identity.GetUserId();
var userName = HttpContext.User.Identity.GetUserName();
using (DAL.BarContext db = new DAL.BarContext())
{
var order = new Models.Order()
{
UserId = userId,
UserName = userName,
TableNumber = postback.TableNumber,
};
db.Orders.Add(order);
db.SaveChanges();
var orderDetails = currentcart.ToOrderDetailList(order.Id);
db.OrderDetails.AddRange(orderDetails);
db.SaveChanges();
}
return(View("~/Views/Home/Index.cshtml"));
}
}
//Handle Add-on Item
else
{
if (this.ModelState.IsValid)
{
var currentcart = Models.ShoppingCart.CartActions.CurrentShoppingCart();
using (DAL.BarContext db = new DAL.BarContext())
{
var orderDetails = currentcart.ToOrderDetailList(OrderId.GetValueOrDefault());
db.OrderDetails.AddRange(orderDetails);
db.SaveChanges();
}
return(View("~/Views/Home/Index.cshtml"));
}
}
return(View());
}
public ActionResult YourOrder()
{
var userId = HttpContext.User.Identity.GetUserId();
using (DAL.BarContext db = new DAL.BarContext())
{
var result = (from s in db.Orders
where s.UserId == userId
select s).ToList();
return(View(result));
}
}
public ActionResult Index()
{
//echo the Item List
List <Models.Item> result = new List <Models.Item>();
//handle the message
ViewBag.Message = TempData["Message"];
using (DAL.BarContext db = new DAL.BarContext())
{
result = (from s in db.Items select s).ToList();
return(View(result));
}
}
public async Task <ActionResult> Delete(int?id)
{
using (DAL.BarContext db = new DAL.BarContext()) {
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order order = await db.Orders.FindAsync(id);
if (order == null)
{
return(HttpNotFound());
}
return(View(order));
}
}
public ActionResult Details(int id)
{
using (DAL.BarContext db = new DAL.BarContext())
{
var result = (from s in db.OrderDetails
where s.OrderId == id
select s).ToList();
if (result.Count == 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(result));
}
}
}
public ActionResult Edit(int id)
{
using (DAL.BarContext db = new DAL.BarContext())
{
//Catch Item.Id as Entry
var result = (from s in db.Items where s.Id == id select s).FirstOrDefault();
//verify the id
if (result != default(Models.Item))
{
return(View(result));
}
else
{ //If no data is found, direct to Index
TempData["Message"] = "Please Input Again";
return(RedirectToAction("Index"));
}
}
}
public ActionResult Add(Models.OrderDetail postback)
{
if (this.ModelState.IsValid)
{
using (DAL.BarContext db = new DAL.BarContext())
{
//Post back data and add to Item table
db.OrderDetails.Add(postback);
//Save Change
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.Message = "The data entry is not correct.";
return(View(postback));
}
}
public ActionResult Create(Models.Item postback)
{
if (this.ModelState.IsValid)
{
using (DAL.BarContext db = new DAL.BarContext())
{
//Post back data and add to Item table
db.Items.Add(postback);
//Save Change
db.SaveChanges();
//Item Create Sucessfully
TempData["Message"] = String.Format("Item[{0}] is created", postback.Name);
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.Message = "The data entry is not correct.";
return(View(postback));
}
}
