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