public ActionResult Order()
{
var orderList = OrderREST.GetAllOrders();
var productList = ProductREST.GetAllProducts();
var userList = UserREST.GetAllUsers();
var OrderResultList = (
from order in orderList
join product in productList on order.ProductID equals product.ProductID
join user in userList on order.UserID equals user.Email
where order.ProductID == product.ProductID
where order.UserID == user.Email
select new OrderResult
{
orderId = order.OrderID,
quantity = order.OrderQuantity,
image = order.OrderImage,
productName = product.ProductName,
customerName = user.FirstName + user.LastName,
phoneNumber = user.PhoneNumber
}).ToList();
ViewBag.orders = OrderResultList;
return(View());
}
public ActionResult createOrder(OrdersViewModel orderViewModel, HttpPostedFileBase image)
{
byte[] img = null;
if (image != null)
{
img = new byte[image.ContentLength];
image.InputStream.Read(img, 0, image.ContentLength);
}
var order = new Order()
{
ProductID = long.Parse(orderViewModel.selectedProductName),
OrderQuantity = orderViewModel.Quantity,
OrderImage = img,
UserID = OnlinePrintingService.Helper.Cookiez.GetCookieData(Request).userId
};
var result = OrderREST.Post(order);
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("OrderComplete", "UserOrder"));
}
ModelState.AddModelError(string.Empty, "Sorry, something went wrong.");
return(View());
}
/*
*
*
*
* // var context = new dbOPScontext();
* //var userStore = new AppUserStore(context);
* List < OrderList > ordList = new List<OrderList>();
* OrderList od = null;
* // List<Order> orders = context.Order.ToList();
* foreach (var ordr in orders)
* {
* od = new OrderList();
* od.orderId = ordr.OrderID;
* // od.productName = context.Product.Where(p => p.ProductID.Equals(ordr.ProductID)).ToList().First().ProductName;
* int x = ordr.UserID.IndexOf("&role");
* string id = ordr.UserID.Substring(0, x);
* // od.customerName = context.Users.Where(c => c.Id.Equals(id)).ToList().First().UserName;
* od.quantity = ordr.OrderQuantity;
* od.image = ordr.OrderImage;
* ordList.Add(od);
* }
*
* /*
*
*
* using (var context1 = new dbOPScontext())
* {
*
* var getprdList = context.Product.ToList();
* SelectList list = new SelectList(getprdList, "ProductID", "ProductName");
* ViewBag.drplist = list;
*
*
*
* }
*
*
*
* var orders = (from order in context.Order
* join product in context.Product on order.ProductID equals product.ProductID
* join user in context.Users on order.UserID equals user.Id
* where order.UserID == user.Id && order.ProductID == product.ProductID
* select new
* {
* OrderId = order.OrderID,
* CustomerName = user.UserName,
* ProductName = product.ProductName,
* Image = order.OrderImage,
* });
*
* ViewBag.orders = ordList;
*
* return View();
*
* }
*/
public ActionResult DeleteOrder(long OrderID)
{
OrderREST.Delete(OrderID);
return(RedirectToAction("Order", "AdminOrder"));
}
