public ActionResult Edit([Bind(Include = "ProductId,ProductName,ProductPrice,InStock")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create([Bind(Include = "productId,name,type,price")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create([Bind(Include = "customerId,firstname,lastname,mobile,email,address,city")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customer.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "orderId,orderDate,Custid,OStatusId")] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Custid = new SelectList(db.Customer, "customerId", "firstname", order.Custid);
ViewBag.OStatusId = new SelectList(db.OrderStatus, "OrderStatusId", "status", order.OStatusId);
return(View(order));
}
public void SaveProducts(int id, List <OrderedProducts> products)
{
foreach (var product in products)
{
product.OrderId = id;
_context.OrderedProducts.Add(product);
}
_context.SaveChanges();
}
public void Save()
{
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public int Commit()
{
return(_dataContext.SaveChanges());
}