public ActionResult Edit(string id)
{
var orderInDb = new ProductionAddOrder();
var order = _context.ProductionOrders.SingleOrDefault(o => o.Id == id);
var orderrawInDb = _context.ProductionRawMaterial.Where(or => or.OId == id).ToList();
List <ProductionRawMaterial> list = new List <ProductionRawMaterial>();
list = orderrawInDb;
string products = "";
string quantity = "";
foreach (var item in list)
{
products = products + item.PId + ",";
quantity = quantity + item.Quantity + ",";
}
ProductionRawMaterial prm = new ProductionRawMaterial();
prm.Quantity = quantity;
prm.PId = products;
prm.OId = id;
prm.SNO = 0;
orderInDb.productionOrder = order;
orderInDb.productionRawMaterial = prm;
return(View(orderInDb));
}
public ActionResult addOrder(ProductionAddOrder Item)
{
var order = new ProductionOrder();
var raw = new ProductionRawMaterial();
order = Item.productionOrder;
_context.ProductionOrders.Add(order);
List <string> listRaw = (Item.productionRawMaterial.PId).Split(',').ToList <string>();
List <string> quantityRaw = (Item.productionRawMaterial.Quantity).Split(',').ToList <string>();
for (var x = 0; x < listRaw.Count(); x++)
{
raw.OId = Item.productionOrder.Id;
raw.PId = listRaw[x];
raw.Quantity = quantityRaw[x];
_context.ProductionRawMaterial.Add(raw);
raw = new ProductionRawMaterial();
}
_context.SaveChanges();
return(Redirect("Index"));
}
public ActionResult UpdateOrder(ProductionAddOrder production)
{
var orderrawInDb = _context.ProductionRawMaterial.Where(or => or.OId == production.productionOrder.Id).ToList();
_context.ProductionRawMaterial.RemoveRange(orderrawInDb);
var order = _context.ProductionOrders.SingleOrDefault(o => o.Id == production.productionOrder.Id);
order.PId = production.productionOrder.PId;
order.ExpectedDate = production.productionOrder.ExpectedDate;
order.StartDate = production.productionOrder.StartDate;
order.Status = production.productionOrder.Status;
order.Title = production.productionOrder.Title;
_context.SaveChanges();
try
{
var raw = new ProductionRawMaterial();
List <string> listRaw = (production.productionRawMaterial.PId).Split(',').ToList <string>();
List <string> quantityRaw = (production.productionRawMaterial.Quantity).Split(',').ToList <string>();
for (var x = 0; x < listRaw.Count(); x++)
{
if (listRaw[x] != null)
{
raw.OId = production.productionOrder.Id;
raw.PId = listRaw[x];
raw.Quantity = quantityRaw[x];
_context.ProductionRawMaterial.Add(raw);
_context.SaveChanges();
raw = new ProductionRawMaterial();
}
}
}
catch (Exception e)
{
return(Redirect("~/Production/Index"));
}
return(Redirect("~/Production/Index"));
}
