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