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));
}
}
}
}
