public ActionResult DeleteConfirmed(int id) { LCTransferMas lCTransferMas = db.LCTransferMas.Find(id); db.LCTransferMas.Remove(lCTransferMas); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LCTransferMas lCTransferMas = db.LCTransferMas.Find(id); if (lCTransferMas == null) { return(HttpNotFound()); } return(View(lCTransferMas)); }
//// POST: LCTransfer/Create //// To protect from overposting attacks, please enable the specific properties you want to bind to, for //// more details see http://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Create([Bind(Include = "Id,MasterLCInfoMasId,IsAuth,OpBy,OpOn,AuthBy,AuthOn")] LCTransferMas lCTransferMas) //{ // if (ModelState.IsValid) // { // db.LCTransferMas.Add(lCTransferMas); // db.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.MasterLCInfoMasId = new SelectList(db.MasterLCInfoMas, "Id", "LCNo", lCTransferMas.MasterLCInfoMasId); // return View(lCTransferMas); //} // GET: LCTransfer/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LCTransferMas lCTransferMas = db.LCTransferMas.Find(id); if (lCTransferMas == null) { return(HttpNotFound()); } /* * $('#LCDate').val(''); * $('#LCReceiveDate').val(''); * $('#LatestShipmentDate').val(''); * $('#LCExpiryDate').val(''); * $('#BuyerName').val(''); * $('#LCQuantity').val(''); * $('#LCTotalValue').val(''); */ var lc = (from lcInfo in db.MasterLCInfoMas join buyer in db.BuyerInfo on lcInfo.BuyerInfoId equals buyer.Id where lcInfo.Id == lCTransferMas.MasterLCInfoMasId select new { lcInfo, buyer }).SingleOrDefault(); ViewBag.LCNo = lc.lcInfo.LCNo; ViewBag.LCDate = lc.lcInfo.LCDate.HasValue ? lc.lcInfo.LCDate.Value.ToString("dd/MM/yyyy"):""; ViewBag.LCReceiveDate = lc.lcInfo.LCReceiveDate.HasValue ? lc.lcInfo.LCReceiveDate.Value.ToString("dd/MM/yyyy") : ""; ViewBag.LatestShipmentDate = lc.lcInfo.LatestShipmentDate.HasValue ? lc.lcInfo.LatestShipmentDate.Value.ToString("dd/MM/yyyy") : ""; ViewBag.LCExpiryDate = lc.lcInfo.LCExpiryDate.HasValue ? lc.lcInfo.LCExpiryDate.Value.ToString("dd/MM/yyyy") : ""; ViewBag.BuyerName = lc.buyer.Name; ViewBag.LCQuantity = lc.lcInfo.Quantity; ViewBag.LCTotalValue = lc.lcInfo.TotalValue; ViewBag.MasterLCInfoMasId = new SelectList(db.MasterLCInfoMas, "Id", "LCNo", lCTransferMas.MasterLCInfoMasId); return(View(lCTransferMas)); }
public JsonResult SaveOrders(IEnumerable <LCTransferDet> OrderDetails, LCTransferMas OrderMas) { var result = new { flag = false, message = "Error occured. !", Id = 0 }; try { var OpDate = DateTime.Now; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { OrderMas.OpBy = 1; OrderMas.OpOn = OpDate; OrderMas.IsAuth = true; //var OrderM = new BuyerOrderMas() //{ // Id = 0, // OrderRefNo = OrderMas.OrderRefNo, // OrderDate = OrderMas.OrderDate, // BuyerInfoId = OrderMas.BuyerInfoId, // ProdDepartmentId = OrderMas.ProdDepartmentId, // SeasonInfoId = OrderMas.SeasonInfoId, // FabSupplierId = OrderMas.FabSupplierId, // OpBy = 1, // OpOn = OpDate, // IsAuth = true, // IsLocked = false //}; db.LCTransferMas.Add(OrderMas); db.SaveChanges(); //Dictionary<int, int> dictionary = // new Dictionary<int, int>(); foreach (var item in OrderDetails) { //var OrderD = new BuyerOrderDet() //{ // Id = 0, // BuyerOrderMasId = OrderM.Id, // ProdCatTypeId = item.ProdCatTypeId, // StyleNo = item.StyleNo, // ProdSizeId = item.ProdSizeId, // ProdColorId = item.ProdColorId, // FabricItemId = item.FabricItemId, // SupplierId = item.SupplierId, // UnitPrice = item.UnitPrice, // Quantity = item.Quantity, // ExFactoryDate = item.ExFactoryDate, // IsLocked = false //}; item.LCTransferMasId = OrderMas.Id; db.LCTransferDet.Add(item); db.SaveChanges(); //dictionary.Add(item.TempOrderDetId, OrderD.Id); } dbContextTransaction.Commit(); result = new { flag = true, message = "Saving successful !!", Id = OrderMas.Id }; 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)); }
// POST: LCTransfer/Edit/5 // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see http://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Edit([Bind(Include = "Id,MasterLCInfoMasId,IsAuth,OpBy,OpOn,AuthBy,AuthOn")] LCTransferMas lCTransferMas) //{ // if (ModelState.IsValid) // { // db.Entry(lCTransferMas).State = EntityState.Modified; // db.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.MasterLCInfoMasId = new SelectList(db.MasterLCInfoMas, "Id", "LCNo", lCTransferMas.MasterLCInfoMasId); // return View(lCTransferMas); //} // GET: LCTransfer/Delete/5 public JsonResult UpdateOrders(IEnumerable <LCTransferDet> OrderDetails, LCTransferMas OrderMas, int[] DelItems) { var result = new { flag = false, message = "Error occured. !" }; //return Json(result, JsonRequestBehavior.AllowGet); try { var OpDate = DateTime.Now; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var OrderM = db.LCTransferMas.Find(OrderMas.Id); if (OrderM == null) { result = new { flag = false, message = "Invalid Transfer Id. Saving failed !" }; return(Json(result, JsonRequestBehavior.AllowGet)); } //---- delete order detail items if (DelItems != null) { foreach (var item in DelItems) { var delOrder = db.LCTransferDet.Find(item); db.LCTransferDet.Remove(delOrder); db.SaveChanges(); } } foreach (var item in OrderDetails) { item.LCTransferMasId = OrderMas.Id; db.Entry(item).State = item.Id == 0 ? EntityState.Added : EntityState.Modified; //db.BuyerOrderDets.Add(OrderD); db.SaveChanges(); //dictionary.Add(item.TempOrderDetId, OrderD.Id); } dbContextTransaction.Commit(); result = new { flag = true, message = "Update successful !!" }; Success("Updated successfully.", true); } catch (Exception ex) { dbContextTransaction.Rollback(); result = new { flag = false, message = ex.Message }; } } } catch (Exception ex) { result = new { flag = false, message = ex.Message }; } return(Json(result, JsonRequestBehavior.AllowGet)); }