public ActionResult ClearWrhse(BulkSaleImpIModel model) { int count = CountUnLocked(model.IfNotNull(m => m.RunName)); if (count < 1) { throw new Exception("Warehouse " + model.IfNotNull(m => m.RunName) + " has no uploaded records!"); } EnsureUtilDBContextOpen(); using (var transaction = UtilDBContext.Connection.BeginTransaction()) { try { // alternative is to load attachments, lots of data possibly selected just to delete, or set up cascade deletes, both in EF and DB UtilDBContext.ExecuteStoreCommand("DELETE FROM FG_BULK_SALE_IMPORT WHERE FG_LOCKED = 'F' AND FG_RUN_NAME = :p0", model.RunName); //UtilDBContext.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); ModelState.AddModelError("", ex.Message); return View(model); } } return RedirectToAction("TrnsfrWrhsList"); }
public ActionResult ClearWrhse(string id) { int count = CountUnLocked(id); if (count < 1) { throw new Exception("Warehouse " + id + " has no uploaded records!"); } BulkSaleImpIModel model = new BulkSaleImpIModel(); model.RunName = id; model.Count = (from i in UtilDBContext.BulkSaleImports where i.RunName == id select i.RunName).Count(); return View(model); }
public ActionResult UploadWrhse(BulkSaleImpIModel model, IEnumerable<HttpPostedFileBase> uploadedFiles) { CountUnLocked(model.IfNotNull(m => m.RunName)); HttpPostedFileBase file = uploadedFiles.IfNotNull(f => f.First()); if (file == null) { ModelState.AddModelError("", "No file was uploaded"); } if (ModelState.IsValid) { Stream stream = file.InputStream; StreamReader sr = new StreamReader(stream); int rowCount = 0; if (model.SkipFirstRow) { sr.ReadLine(); } string line; string[] row; while ((line = sr.ReadLine()) != null) { if (!String.IsNullOrWhiteSpace(line)) { row = line.Trim().Split(','); BulkSaleImport newImport = new BulkSaleImport(); newImport.RunName = model.RunName; newImport.SerialNum = row[0]; if (row.Length > 1) { newImport.CustPO = row[1]; } BulkSaleImport existImport = null; if (!model.Insert) { 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); } else { existImport.CustPO = newImport.CustPO; } rowCount++; } } if (rowCount > 0) { UtilDBContext.SaveChanges(); return RedirectToAction("EditWrhse", new {id = model.RunName}); } else ModelState.AddModelError("", "No rows were imported"); } return View(model); }
public ActionResult UploadWrhse(string id) { CountUnLocked(id); BulkSaleImpIModel model = new BulkSaleImpIModel(); if (String.IsNullOrWhiteSpace(id)) { model.Count = 0; } else { model.RunName = id; model.Count = (from i in UtilDBContext.BulkSaleImports where i.RunName == id select i.RunName).Count(); } model.Insert = (model.Count < 1); return View(model); }
public ActionResult ResultsWrhse(string id) { BulkSaleImpIModel model = new BulkSaleImpIModel { RunName = id }; return View(model); }
public ActionResult EditWrhse(string id) { CountUnLocked(id); BulkSaleImpIModel model = new BulkSaleImpIModel { RunName = id }; return View(model); }