public ActionResult AddStoreInventory(AddStoreInventoryModel model) { try { if (ModelState.IsValid) { var result = _storeInventoryService.AddStoreInventory(model); if (result > 0) { return(RedirectToAction("AddStoreInventory").WithSuccess("Butiksinventarielista har blivit tillagd.")); } else { return(Redirect(Url.Action("StoreInventories", "StoreInventory") + "?id=" + model.StoreId).WithError("Fel vid sparandet av butiksinventarielista.")); } } else { return(View(model)); } } catch (Exception ex) { _log.ErrorFormat("Error in updating store details. Error : {0}", ex.Message); _log.Error(ex); return(View().WithError(ex.Message)); } }
public string AddBulkDataFromCSVFile(HttpPostedFileBase fileUpload, int storeId) { string fileName = Path.GetFileName(fileUpload.FileName); var bulkCopy = string.Empty; string path = Path.Combine(HttpContext.Current.Server.MapPath("~/InventoryUpload"), fileName); fileUpload.SaveAs(path); var csvInventoryList = new List <StoreInventoryCSVModel>(); using (var sr = new StreamReader(path)) { CsvReader csvRead = new CsvReader(sr); csvInventoryList = csvRead.GetRecords <StoreInventoryCSVModel>().Where(x => x.StoreId == storeId).ToList(); foreach (var item in csvInventoryList) { var addStoreInventoryModel = new AddStoreInventoryModel() { StoreId = item.StoreId, InventoryId = item.InventoryId, NumberOfItems = item.NumberOfItems }; _storeInventoryRepository.AddStoreInventory(addStoreInventoryModel); } sr.Close(); } return(fileName); }
public ActionResult AddStoreInventory() { var storeId = Convert.ToInt32(TempData["StoreId"]); var addStoreInventoryModel = new AddStoreInventoryModel { StoreId = storeId }; TempData.Keep("StoreId"); return(View(addStoreInventoryModel)); }
public long AddStoreInventory(AddStoreInventoryModel model) { var sqlQuery = GetStoreInventoryExitsQuery(model.StoreId.ToString(), model.InventoryId.ToString()); var numberOfUnits = GetAvailableUnit(model.StoreId.ToString(), model.InventoryId.ToString()); var count = _db.ExecuteScalar <long>(sqlQuery); if (count > 0) { sqlQuery = ""; sqlQuery = GetEditStoreInventoryQuery(); _db.ExecuteScalar <long>(sqlQuery, new { @numberOfItems = numberOfUnits + model.NumberOfItems, @modifiedBy = _setupUser.GetUserData().Id, @modifiedDate = DateTime.Now, @storeId = model.StoreId.ToString(), @inventoryId = model.InventoryId.ToString() }); return(1); } else { sqlQuery = ""; sqlQuery = GetAddStoreInventoryQuery(); var result = _db.ExecuteScalar <long>(sqlQuery, new { @storeId = model.StoreId.ToString(), @inventoryId = model.InventoryId.ToString(), @numberOfItems = model.NumberOfItems, @createdBy = _setupUser.GetUserData().Id, @createdDate = DateTime.Now, @modifiedBy = _setupUser.GetUserData().Id, @modifiedDate = DateTime.Now }); return(result); } }
public long AddStoreInventory(AddStoreInventoryModel model) { return(_storeInventoryRepository.AddStoreInventory(model)); }