public ActionResult EditMOPItem(M_MOP_ItemsModel model, int?siteId, string pmsNo, string mopNo) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { MopViewModels vm = new MopViewModels(); try { if (!ModelState.IsValid) { Alert("Their is something went wrong!!!", NotificationType.error); return(Json(model, JsonRequestBehavior.AllowGet)); } if (model != null) { var obj = new M_MOP_ITEMS() { MOP_ItemsId = model.MOP_ItemsId, SiteId = Convert.ToInt32(model.SiteId), SR_Qty = model.SR_Qty, PMS_No = model.PMS_No, MOP_No = model.MOP_No, Part_No = model.Part_No, }; if (model.NewSelectedPart_No != null) { obj.Part_No = model.NewSelectedPart_No.Trim(); } db.Entry(obj).State = EntityState.Modified; } db.SaveChanges(); transaction.Commit(); if (siteId != null && pmsNo != null && mopNo != null) { vm = GetMopItemData(siteId, pmsNo, mopNo); } // Alert("Data Saved Sucessfully!!!", NotificationType.success); return(Json(new { msg = "Record Updated Sucessfully!!!", model = vm.M_MOP_ItemsModelList }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { transaction.Rollback(); Exception(ex); //Alert("Their is something went wrong!!!", NotificationType.error); return(Json(vm)); } } } }
public ActionResult AddMOPItem(M_MOP_ITEMS model, int?siteId, string pmsNo, string mopNo) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { MopViewModels vm = new MopViewModels(); try { if (!ModelState.IsValid) { Alert("Their is something went wrong!!!", NotificationType.error); return(Json(model, JsonRequestBehavior.AllowGet)); } if (model != null) { db.M_MOP_ITEMS.Add(model); db.SaveChanges(); transaction.Commit(); } if (siteId != null && pmsNo != null && mopNo != null) { vm = GetMopItemData(siteId, pmsNo, mopNo); } // Alert("Data Saved Sucessfully!!!", NotificationType.success); return(Json(new { msg = "Data Saved Sucessfully!!!", model = vm.M_MOP_ItemsModelList }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { transaction.Rollback(); Exception(ex); //Alert("Their is something went wrong!!!", NotificationType.error); return(Json(vm)); } } } }