public async Task <IActionResult> Edit(int id, [Bind("OrderDtlId,OrderId,ProductId,EmpID,Quentity,TotalCost")] OrderDtl orderDtl) { if (id != orderDtl.OrderDtlId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(orderDtl); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OrderDtlExists(orderDtl.OrderDtlId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["EmpID"] = new SelectList(_context.Employees, "EmpID", "Country", orderDtl.EmpID); ViewData["OrderId"] = new SelectList(_context.Orders, "OrderId", "Orderdate", orderDtl.OrderId); ViewData["ProductId"] = new SelectList(_context.Products, "ProductId", "ProductName", orderDtl.ProductId); return(View(orderDtl)); }
protected void InsertNewWCItem(OrderedDictionary newValues) { DataClassesDataContext db = new DataClassesDataContext(); string code = newValues["ItemCode"].ToString(); int orderline = Convert.ToInt32(newValues["OrderLine"]); var cust = db.OrderDtls.Where(x => x.OrderLine == orderline && x.OrderNo == txtOrderNo.Text).FirstOrDefault(); if (cust != null) { return; } OrderDtl item = new OrderDtl(); int lineno = 1; var line = db.OrderDtls.Max(x => x.OrderLine); if (line != null) { lineno = Convert.ToInt32(line); } item.OrderNo = txtOrderNo.Text; item.OrderLine = lineno; item.ItemCode = code; item.ItemName = newValues["ItemName"].ToString(); item.ItemUom = newValues["ItemUom"].ToString(); item.Quantity = Convert.ToDecimal(newValues["Quantity"]); if (newValues["Remark"] != null) { item.Remark = newValues["Remark"].ToString(); } db.OrderDtls.InsertOnSubmit(item); db.SubmitChanges(); grid.DataBind(); }
public ActionResult DeleteConfirmed(int id) { OrderDtl orderDtl = db.OrderDtls.Find(id); db.OrderDtls.Remove(orderDtl); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "OrderDtlsId,OrderId,ProductId,EmpID,Quentity,TotalCost")] OrderDtl orderDtl) { if (ModelState.IsValid) { db.Entry(orderDtl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmpID = new SelectList(db.Employees, "EmpID", "Name", orderDtl.EmpID); ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Orderdate", orderDtl.OrderId); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "ProductName", orderDtl.ProductId); return(View(orderDtl)); }
// GET: OrderDtls/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OrderDtl orderDtl = db.OrderDtls.Find(id); if (orderDtl == null) { return(HttpNotFound()); } return(View(orderDtl)); }
public async Task <IActionResult> Create([Bind("OrderDtlId,OrderId,ProductId,EmpID,Quentity,TotalCost")] OrderDtl orderDtl) { if (ModelState.IsValid) { _context.Add(orderDtl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["EmpID"] = new SelectList(_context.Employees, "EmpID", "Country", orderDtl.EmpID); ViewData["OrderId"] = new SelectList(_context.Orders, "OrderId", "Orderdate", orderDtl.OrderId); ViewData["ProductId"] = new SelectList(_context.Products, "ProductId", "ProductName", orderDtl.ProductId); return(View(orderDtl)); }
// GET: OrderDtls/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OrderDtl orderDtl = db.OrderDtls.Find(id); if (orderDtl == null) { return(HttpNotFound()); } ViewBag.EmpID = new SelectList(db.Employees, "EmpID", "Name", orderDtl.EmpID); ViewBag.OrderId = new SelectList(db.Orders, "OrderId", "Orderdate", orderDtl.OrderId); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "ProductName", orderDtl.ProductId); return(View(orderDtl)); }