//[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Create([Bind(Include = "Id,FactoryOrderDelivDetId,TimeActionMasId,PlanFlag,RevisedFlag")] ActionActivityMas actionActivityMas) //{ // if (ModelState.IsValid) // { // db.ActionActivityMas.Add(actionActivityMas); // db.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.FactoryOrderDelivDetId = new SelectList(db.FactoryOrderDelivDet, "Id", "Id", actionActivityMas.FactoryOrderDelivDetId); // ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas, "Id", "TemplateName", actionActivityMas.TimeActionMasId); // return View(actionActivityMas); //} // GET: ActionActivity/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ActionActivityMas actionActivityMas = db.ActionActivityMas.Find(id); if (actionActivityMas == null) { return(HttpNotFound()); } var factoryDet = db.FactoryOrderDet.SingleOrDefault(x => x.Id == actionActivityMas.FactoryOrderDelivDet.FactoryOrderDetId); ViewBag.RDLRefNo = factoryDet.BuyerOrderDet.BuyerOrderMas.OrderRefNo; ViewBag.OrderDate = NullHelpers.DateToString(factoryDet.BuyerOrderDet.BuyerOrderMas.OrderDate); ViewBag.Style = factoryDet.BuyerOrderDet.StyleNo; ViewBag.OrderQty = factoryDet.BuyerOrderDet.Quantity; ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas.Where(x => x.BuyerInfoId == factoryDet.BuyerOrderDet.BuyerOrderMas.BuyerInfoId), "Id", "TemplateName", actionActivityMas.TimeActionMasId); //ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x => x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "BuyerSlNo"); ViewBag.ShipmentSummDetId = new SelectList(db.ShipmentSummDet.Where(x => x.BuyerOrderDetId == factoryDet.BuyerOrderDetId), "Id", "DelivSlno", actionActivityMas.FactoryOrderDelivDet.ShipmentSummDetId); //ViewBag.FactoryOrderDelivDetId = new SelectList(db.FactoryOrderDelivDet, "Id", "Id", actionActivityMas.FactoryOrderDelivDetId); //ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas, "Id", "TemplateName", actionActivityMas.TimeActionMasId); return(View(actionActivityMas)); }
public ActionResult DeleteConfirmed(int id) { ActionActivityMas actionActivityMas = db.ActionActivityMas.Find(id); db.ActionActivityMas.Remove(actionActivityMas); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,FactoryOrderDelivDetId,TimeActionMasId,PlanFlag,RevisedFlag")] ActionActivityMas actionActivityMas) { if (ModelState.IsValid) { db.Entry(actionActivityMas).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FactoryOrderDelivDetId = new SelectList(db.FactoryOrderDelivDet, "Id", "Id", actionActivityMas.FactoryOrderDelivDetId); ViewBag.TimeActionMasId = new SelectList(db.TimeActionMas, "Id", "TemplateName", actionActivityMas.TimeActionMasId); return(View(actionActivityMas)); }
// GET: ActionActivity/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ActionActivityMas actionActivityMas = db.ActionActivityMas.Find(id); if (actionActivityMas == null) { return(HttpNotFound()); } return(View(actionActivityMas)); }
public JsonResult SaveActivity(IEnumerable <ActionActivityDet> ActivityDetails, ActionActivityMas ActivityMas, int[] DelItems) { var result = new { flag = false, message = "Error occured. !", Id = 0 }; try { var OpDate = DateTime.Now; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var factoryDelivDet = db.FactoryOrderDelivDet.SingleOrDefault(x => x.ShipmentSummDetId == ActivityMas.FactoryOrderDelivDetId); var OrderM = new ActionActivityMas() { Id = ActivityMas.Id, TimeActionMasId = ActivityMas.TimeActionMasId, FactoryOrderDelivDetId = factoryDelivDet.Id, PlanFlag = true, RevisedFlag = true }; db.Entry(OrderM).State = OrderM.Id == 0 ? EntityState.Added : EntityState.Modified; //db.TimeActionMas.Add(OrderM); db.SaveChanges(); foreach (var item in ActivityDetails) { var OrderD = new ActionActivityDet() { Id = item.Id, ActionActivityMasId = OrderM.Id, TimeActionDetId = item.TimeActionDetId, PlanDate = item.PlanDate, RevisedDate = item.RevisedDate, ActualDate = item.ActualDate, Remarks = item.Remarks }; db.Entry(OrderD).State = OrderD.Id == 0 ? EntityState.Added : EntityState.Modified; //db.TimeActionDet.Add(OrderD); db.SaveChanges(); } if (DelItems != null) { foreach (var item in DelItems) { var delOrder = db.ActionActivityDet.Find(item); db.ActionActivityDet.Remove(delOrder); db.SaveChanges(); } } dbContextTransaction.Commit(); result = new { flag = true, message = "Saving successful !!", Id = OrderM.FactoryOrderDelivDet.FactoryOrderDet.FactoryOrderMasId }; //Success("Record saved successfully.", true); } catch (Exception ex) { dbContextTransaction.Rollback(); result = new { flag = false, message = ex.Message, Id = 0 }; } } } catch (Exception ex) { result = new { flag = false, message = ex.Message, Id = 0 }; } return(Json(result, JsonRequestBehavior.AllowGet)); }