Esempio n. 1
0
 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));
 }
Esempio n. 2
0
 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));
 }
Esempio n. 3
0
 public ActionResult _DeleteWhtrans(string id)
 {
     BulkSaleImpItem idModel = new BulkSaleImpItem();
     if (idModel.ParseItemKey(id))
     {
             BulkSaleImport import = (from i in UtilDBContext.BulkSaleImports
                                      where i.RunName == idModel.RunName && i.SerialNum == idModel.SerialNum && i.LockedStr == "F"
                                      select i).FirstOrDefault();
             if (import != null)
             {
                 UtilDBContext.DeleteObject(import);
                 UtilDBContext.SaveChanges();
             }
     }
     return View(UnlockedSerialPoGridList(idModel.RunName));
 }