public ActionResult _SaveWhtrans(string id, BulkSaleImpItem editModel) { if (String.IsNullOrWhiteSpace(editModel.SerialNum)) { ModelState.AddModelError(editModel.FullPropertyName(m => m.SerialNum), "Required"); } else { BulkSaleImpItem idModel = new BulkSaleImpItem(); if (idModel.ParseItemKey(id)) { BulkSaleImport import = (from i in UtilDBContext.BulkSaleImports where i.RunName == idModel.RunName && i.SerialNum == idModel.SerialNum select i).FirstOrDefault(); if (import != null) { if (import.SerialNum == editModel.SerialNum) { if (TryUpdateModel(import)) { UtilDBContext.SaveChanges(); } } else { BulkSaleImport newImport = new BulkSaleImport(); if (TryUpdateModel(newImport)) { BulkSaleImport existImport = (from i in UtilDBContext.BulkSaleImports where i.RunName == newImport.RunName && i.SerialNum == newImport.SerialNum select i).FirstOrDefault(); if (existImport == null) { //Delete UtilDBContext.DeleteObject(import); UtilDBContext.SaveChanges(); //insert UtilDBContext.BulkSaleImports.AddObject(newImport); UtilDBContext.SaveChanges(); } else { ModelState.AddModelError(editModel.FullPropertyName(m => m.SerialNum), "Already exists"); } } } } } } return View(UnlockedSerialPoGridList(editModel.RunName)); }
public ActionResult _InsertWhtrans(BulkSaleImpItem editModel) { BulkSaleImport newImport = new BulkSaleImport(); if (TryUpdateModel(newImport)) { if (!String.IsNullOrWhiteSpace(newImport.SerialNum)) { BulkSaleImport existImport = (from i in UtilDBContext.BulkSaleImports where i.RunName == newImport.RunName && i.SerialNum == newImport.SerialNum select i).FirstOrDefault(); if (existImport == null) { UtilDBContext.BulkSaleImports.AddObject(newImport); UtilDBContext.SaveChanges(); } else { ModelState.AddModelError(editModel.FullPropertyName(m => m.SerialNum), "Already exists"); } } else { ModelState.AddModelError(editModel.FullPropertyName(m => m.SerialNum), "Required"); } } return View(UnlockedSerialPoGridList(editModel.RunName)); }