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