// for admin area
public OrderDetails GetOrderDetail(int orderNumber)
{
mergedEntities db = new mergedEntities();
OrderDetails orderDetails = new OrderDetails();
var query =
from o in db.OrderDetails
where (o.orderNumber == orderNumber)
select new OrderDetails()
//select new
{
OrderNumber = o.orderNumber,
OrderDate = (DateTime)o.orderDate,
OrderDelivery = (DateTime)o.deliveryTime,
DeliveryStatus = (bool)o.deliveryStatus
};
foreach (var item in query)
{
orderDetails.OrderNumber = item.OrderNumber;
orderDetails.OrderDate = item.OrderDate;
orderDetails.OrderDelivery = item.OrderDelivery;
orderDetails.DeliveryStatus = item.DeliveryStatus;
}
return orderDetails;
}
//Get order details
public OrderDetail GetOrderDetail()
{
mergedEntities db = new mergedEntities();
OrderDetails repo = new OrderDetails();
OrderDetail order = new OrderDetail();
var query =
from a in db.OrderDetails
where (a.orderNumber == repo.OrderNumber)
select new
{
OrderNumber = a.orderNumber,
OrderDate = a.orderDate,
Delivery = a.deliveryStatus,
};
foreach (var item in query)
{
order.orderNumber = item.OrderNumber;
order.orderDate = item.OrderDate;
order.deliveryStatus = item.Delivery;
}
return order;
}
public OrderDetails UpdateOrder(OrderDetails orderDetails)
{
mergedEntities db = new mergedEntities();
OrderDetail orderDetail = db.OrderDetails.Where(o => o.orderNumber == orderDetails.OrderNumber).FirstOrDefault();
orderDetail.orderNumber = orderDetails.OrderNumber;
orderDetail.orderDate = orderDetails.OrderDate;
orderDetail.deliveryTime = orderDetails.OrderDelivery;
orderDetail.deliveryStatus = orderDetails.DeliveryStatus;
db.SaveChanges();
return orderDetails;
}
public ActionResult ViewCart()
{
var items = shoppingCart.GetAllItems(session.SessionID);
if (items.Any())
{
Session["shoppingCart"] = items.Count();
}
else
{
Session["shoppingCart"] = null;
}
var order = new OrderDetails
{
CartItems = items,
Tax = ProductDetails.TAX_RATE
};
return View(order);
}
public ActionResult EditOrderDetail(OrderDetails orderDetails)
{
OrderRepo orderRepo = new OrderRepo();
OrderDetails editedOrderDetails = new OrderDetails();
if (ModelState.IsValid)
{
editedOrderDetails = orderRepo.UpdateOrder(orderDetails);
return RedirectToAction("AdminOnly");
}
else
{
ViewBag.ErrorMessage = "This entry is invalid.";
return View(orderDetails);
}
}
public ActionResult EditOrderDetail(int id) // "id" is "id order number".
{
OrderRepo orderRepo = new OrderRepo();
OrderDetails orderDetails = new OrderDetails();
orderDetails = orderRepo.GetOrderDetail(id);
return View(orderDetails);
}