public ActionResult Edit(Order_MasterVM order_MasterVM)
{
if (ModelState.IsValid)
{
foreach (var omp in order_MasterVM.order_Master_products)
{
var orderMasterItems = db.order_master_items.Where(x => x.ID == omp.ID).FirstOrDefault();
orderMasterItems.RemainingQuantity = omp.RemainingQuantity;
db.Entry(orderMasterItems).State = EntityState.Modified;
db.SaveChanges();
var objPI = db.productsinventories.Where(p => p.ProductID == omp.ProductID).SingleOrDefault();
if (objPI != null)
{
objPI.Quantity = objPI.Quantity + (int)omp.RemainingQuantity;
db.productsinventories.Attach(objPI);
db.Entry(objPI).State = EntityState.Modified;
db.SaveChanges();
}
else
{
throw new Exception("One or more product does not exist or it does not have required quantity.");
}
}
var order_Master = db.order_master.Where(x => x.ID == order_MasterVM.ID).FirstOrDefault();
order_Master.Status = Convert.ToInt32(order_MasterVM.Status);
db.Entry(order_Master).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(order_MasterVM));
}
// GET: order_master/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
order_master order_Master = db.order_master.Find(id);
if (order_Master == null)
{
return(HttpNotFound());
}
Order_MasterVM orderMasterVM = new Order_MasterVM();
orderMasterVM.order_Master_products = new List <OrderMasterProducts>();
orderMasterVM.OrderNo = order_Master.order.OrderNo;
orderMasterVM.EmployeeName = order_Master.employee.FirstName + " " + order_Master.employee.LastName;
orderMasterVM.Status = order_Master.Status.ToString();
List <SelectListItem> items = new List <SelectListItem> {
new SelectListItem {
Text = statusEnum.NewOrder.ToString(), Value = "5"
},
new SelectListItem {
Text = statusEnum.InProgress.ToString(), Value = "6"
},
new SelectListItem {
Text = statusEnum.Completed.ToString(), Value = "4"
}
};
ViewBag.Status = new SelectList(items, "Value", "Text", orderMasterVM.Status);
foreach (var omi in db.order_master_items.Where(x => x.OrderMasterID == order_Master.ID).ToList())
{
OrderMasterProducts objOMP = new OrderMasterProducts();
objOMP.ID = omi.ID;
objOMP.Name = omi.product.Name;
objOMP.ProductID = omi.ProductID;
objOMP.Quantity = omi.Quantity;
objOMP.RemainingQuantity = 0;
orderMasterVM.order_Master_products.Add(objOMP);
}
return(View(orderMasterVM));
}
public ActionResult Create(Order_MasterVM order_MasterVM)
{
order_MasterVM.order_Master_products.RemoveAt(0);
order_master OM = new order_master();
OM.EmployeeID = order_MasterVM.EmployeeID;
OM.OrderID = order_MasterVM.OrderID;
OM.Status = Convert.ToInt32(order_MasterVM.Status);
if (ModelState.IsValid)
{
foreach (var x in order_MasterVM.order_Master_products)
{
order_master_items obj = new order_master_items();
obj.ProductID = x.ProductID;
obj.Quantity = x.Quantity;
obj.RemainingQuantity = x.RemainingQuantity;
OM.order_master_items.Add(obj);
// update inventery
var objPI = db.productsinventories.Where(p => p.ProductID == x.ProductID).SingleOrDefault();
if (objPI != null)
{
objPI.Quantity = objPI.Quantity - (int)x.Quantity;
db.productsinventories.Attach(objPI);
db.Entry(objPI).State = EntityState.Modified;
db.SaveChanges();
}
else
{
throw new Exception("One or more product does not exist or it does not have required quantity.");
}
}
db.order_master.Add(OM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderID = new SelectList(db.orders, "ID", "OrderNo", order_MasterVM.OrderID);
return(View(order_MasterVM));
}
// GET: order_master/Create
public ActionResult Create()
{
var orders = from order in db.orders
where !(from om in db.order_master select om.OrderID).Contains(order.ID)
select order;
ViewBag.OrderID = new SelectList(orders, "ID", "OrderNo");
var employees = from emp in db.employees
where emp.MasterEmp == true
select new {
ID = emp.ID,
Name = emp.FirstName + ", " + emp.LastName
};
ViewBag.EmployeeID = new SelectList(employees, "ID", "Name");
ViewBag.ProductID = new SelectList(db.products, "ID", "Name");
List <SelectListItem> items = new List <SelectListItem> {
new SelectListItem {
Text = statusEnum.NewOrder.ToString(), Value = "5"
},
new SelectListItem {
Text = statusEnum.InProgress.ToString(), Value = "6"
},
new SelectListItem {
Text = statusEnum.Completed.ToString(), Value = "4"
}
};
ViewBag.Status = new SelectList(items, "Value", "Text");
Order_MasterVM orderMasterVM = new Order_MasterVM();
orderMasterVM.order_Master_products = new List <OrderMasterProducts>
{
new OrderMasterProducts()
};
return(View(orderMasterVM));
}
