public ActionResult Create([Bind(Include = "ProductId,ProductName,ProductCode,Remark,Description,PriceExVAT,Reprobel,Bebat,Recupel,Auvibel,PurchasePrice,Brand,CategoryId,VATPercId,Stock,EAN")] ProductCreateViewModel product) { if (ModelState.IsValid) { Product prod = new Product(); prod.ProductName = product.ProductName; prod.ProductCode = product.ProductCode; prod.Remark = product.Remark; prod.Description = product.Description; prod.PriceExVAT = product.PriceExVAT; prod.Reprobel = product.Reprobel; prod.Bebat = product.Bebat; prod.Recupel = product.Recupel; prod.Auvibel = product.Auvibel; prod.PurchasePrice = product.PurchasePrice; prod.Brand = product.Brand; prod.CategoryId = product.CategoryId; prod.VATPercId = product.VATPercId; prod.Stock = product.Stock; prod.EAN = product.EAN; prod.Active = true; db.Products.Add(prod); db.SaveChanges(); return RedirectToAction("Index"); } return View(product); }
public ActionResult Edit([Bind(Include = "OrderDetailId,Quantity,OrderId,ProductId,ProductName,ProductCode,Description,PriceExVAT,Reprobel,Bebat,Recupel,Auvibel,Brand,CategoryId,VATPercId,TotalExVat,TotalIncVat")] OrderDetail orderDetail, string returnUrl) { Product prod = new Product(); prod = db.Products.Find(orderDetail.ProductId); VAT tempod = db.VATs.Find(orderDetail.VATPercId); orderDetail.ProductName = prod.ProductName; orderDetail.TotalExVat = (orderDetail.PriceExVAT + orderDetail.Auvibel + orderDetail.Bebat + orderDetail.Recupel + orderDetail.Reprobel) * orderDetail.Quantity; orderDetail.TotalIncVat = orderDetail.TotalExVat * (1 + (tempod.VATValue / 100)); if (ModelState.IsValid) { db.Entry(orderDetail).State = EntityState.Modified; db.SaveChanges(); return Redirect(returnUrl); } ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Annotation", orderDetail.OrderId); ViewBag.VATPercId = new SelectList(db.VATs, "VATPercId", "VATPercId", orderDetail.VATPercId); return Redirect(returnUrl); }
public ActionResult Edit([Bind(Include = "QuotationDetailId,Quantity,QuotationId,ProductId,ProductName,ProductCode,Description,PriceExVAT,Reprobel,Bebat,Recupel,Auvibel,Brand,CategoryId,VATPercId")] QuotationDetail quotationDetail, int editValue) { Product prod = new Product(); prod = db.Products.Find(quotationDetail.ProductId); //aangezien VAT obj niet 100% mee linkt vanuit de edit halen we deze opnieuw op via QD id VAT tempqd = db.VATs.Find(quotationDetail.VATPercId); quotationDetail.ProductName = prod.ProductName; quotationDetail.TotalExVat = (quotationDetail.PriceExVAT + quotationDetail.Auvibel + quotationDetail.Bebat + quotationDetail.Recupel + quotationDetail.Reprobel) * quotationDetail.Quantity; quotationDetail.TotalIncVat = quotationDetail.TotalExVat * (1 + (tempqd.VATValue / 100)); if (ModelState.IsValid) { db.Entry(quotationDetail).State = EntityState.Modified; db.SaveChanges(); if (editValue == 1) { return RedirectToAction("Edit", "Quotations", new { id = quotationDetail.QuotationId }); } return RedirectToAction("AddProducts", "Quotations", new { id = quotationDetail.QuotationId }); } return View(quotationDetail); }