public ActionResult Create(Area_Orden item) { try { // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult StartOrden(int id, int fromarea) { int orden = id; int area = fromarea; //var getOrden = from w in context.WorkOrden // where w.BatchOrden == id.ToString() // select w; //var lstOrden = getOrden.ToList(); //foreach(var d in lstOrden) //{ // orden = d.WorkOrdenId; //} int user = Convert.ToInt32(Session["userId"]); //area = (int)Session["userAreaId"]; if (area == 1) { var up = from w in context.WorkOrden where w.WorkOrdenId == id select w; foreach (WorkOrden wo in up) { wo.dateStart = DateTime.Now; } DeliveryOrder delivery = new DeliveryOrder(); delivery.WorkOrdenID = id; context.DeliveryOrder.Add(delivery); } var ar = from a in context.Area where a.orden == area select a; foreach (var item in ar.ToList()) { area = (int)item.AreaId; } Area_Orden ord = new Area_Orden() { AreaId = area, WorkOrdenId = orden, dateStart = DateTime.Now, runOrden = true, notify = false }; area = fromarea; if (area != 1) { var s**t = from a in context.Area_Orden join b in context.Area on a.AreaId equals b.AreaId where a.WorkOrdenId == id && b.orden == (area - 1) select a; var slutlst = s**t.ToList(); foreach (Area_Orden a in s**t) { a.runOrden = false; } } context.Area_Orden.Add(ord); context.SaveChanges(); return(RedirectToAction("Index")); }