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