public ActionResult AddLens(AddLensVM lensAddition) { var qry = db.ProductLensDetails .Where(x => x.ProductId == lensAddition.ProductId) .Include(p => p.Product); var _lens = new tmpOrderDetail() { SKUNumber=lensAddition.ProductSKU, Price=lensAddition.ProductRetailPrice, Quantity=1, Discount=0, LineTotal=lensAddition.ProductRetailPrice, ProductTypeId=1 }; if (ModelState.IsValid) { db.tmpOrderDetails.Add(_lens); db.SaveChanges(); return RedirectToAction("Index"); } return View(); }
// GET: /Order/Create/CustomerID public ActionResult Create(int id, int page = 1 ,string searchTerm = null) { CustomerOrderVM _viewmodel = new CustomerOrderVM(); var _customer = db.Customers.Find(id); _viewmodel.CustomerId=_customer.CustomerID; ViewBag.StoreId = new SelectList(db.Stores, "StoreId", "StoreName"); ViewBag.OrderTypeId = new SelectList(db.OrderTypes, "OrderTypeId", "OrderTypeName"); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeName"); //List of Product Order Detail //Joining the three tables /* var qry = db.Orders .Join(db.OrderDetails, O => O.OrderId, er => er.OrderId, (O, er) => new { Order = O, OrderDetail = er }) .Join(db.Products, Or => Or.OrderDetail.ProductId, P => P.ProductId, (P, OR) => new { Product = P, OrderDetail = OR }) .ToList(); */ var qry = db.Products .Include(p => p.producttype) .ToList(); var _detailResult = new List<OrderDetailListVM>(); var qry3 = db.ProductLensDetails .OrderBy(p => p.ProductId) .Where(c => searchTerm == null || c.Product.ProductSKU.Equals(searchTerm) || c.Product.ProductName.Contains(searchTerm)); var _lensviewmodel = new List<AddLensVM>(); foreach (ProductLensDetail lens in qry3) { var _lens = new AddLensVM() { ProductId = lens.ProductId, ProductSKU = lens.Product.ProductSKU, ProductName = lens.Product.ProductName, LensSPH = lens.LensSPH, LensCYL = lens.LensCYL, ProductRetailPrice = lens.Product.ProductRetailPrice, ProductQuantity = lens.Product.ProductQuantity }; _lensviewmodel.Add(_lens); } _viewmodel.listproductorderdetail=_detailResult; _viewmodel.listproductlenssearch = _lensviewmodel.ToPagedList(page,5); if (Request.IsAjaxRequest()) { return PartialView("_AddLens", _viewmodel.listproductlenssearch); } ViewBag.CustomerId = id; return View(_viewmodel); }