public IActionResult Import()
{
InventoryOpenigStockImport inventoryOpenigStockImport = new InventoryOpenigStockImport();
inventoryOpenigStockImport.StoreList = _iDropDownService.GetStoreList();
return(View(inventoryOpenigStockImport));
}
public ActionResult ProcessData(InventoryOpenigStockImport inv, int storeId, int categoryId)
{
int Result = _iInventoryService.BulkImport(_inventoryOpenigStockImports);
return(View(_inventoryOpenigStockImports));
}
public ActionResult ImportData(int storeId, int itemType)
{
InventoryOpenigStockImport item = new InventoryOpenigStockImport();
List <InventoryOpenigStockImport> ItemList = new List <InventoryOpenigStockImport>();
Random _random = new Random();
StringBuilder sb = new StringBuilder();
try
{
IFormFile file = Request.Form.Files[0];
string folderName = "Upload";
string webRootPath = _hostingEnvironment.WebRootPath;
string contentRootPath = _hostingEnvironment.ContentRootPath;
string newPath = Path.Combine(webRootPath, folderName);
string BatchId = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset).ToString("MM/dd/yyyy HH:mm").Replace("/", "").Replace(" ", "").Replace(":", "").ToString() + _random.Next(1000).ToString();
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
if (file.Length > 0)
{
string sFileExtension = Path.GetExtension(file.FileName).ToLower();
ISheet sheet;
string fullPath = Path.Combine(newPath, file.FileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
stream.Position = 0;
if (sFileExtension == ".xls")
{
HSSFWorkbook hssfwb = new HSSFWorkbook(stream); //This will read the Excel 97-2000 formats
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
else
{
XSSFWorkbook hssfwb = new XSSFWorkbook(stream); //This will read 2007 Excel format
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
IRow headerRow = sheet.GetRow(0); //Get Header Row
int cellCount = headerRow.LastCellNum;
sb.Append("<p>Process completed successfully</p>");
sb.Append("<table class='table table-bordered'><tr>");
for (int j = 0; j < cellCount; j++)
{
NPOI.SS.UserModel.ICell cell = headerRow.GetCell(j);
if (cell == null || string.IsNullOrWhiteSpace(cell.ToString()))
{
continue;
}
sb.Append("<th>" + cell.ToString() + "</th>");
}
sb.Append("</tr>");
sb.AppendLine("<tr>");
for (int i = (sheet.FirstRowNum + 1); i <= sheet.LastRowNum; i++) //Read Excel File
{
IRow row = sheet.GetRow(i);
if (row == null)
{
continue;
}
if (row.Cells.All(d => d.CellType == CellType.Blank))
{
continue;
}
for (int j = row.FirstCellNum; j < cellCount; j++)
{
if (row.GetCell(j) != null)
{
if (j == 0)
{
item.FoodmenuId = Convert.ToInt32(row.GetCell(j).ToString());
sb.Append("<td class=\"text-right\">" + row.GetCell(j).ToString() + "</td>");
}
else if (j == 3)
{
item.PhysicalStockQty = Convert.ToDecimal(row.GetCell(j).ToString());
sb.Append("<td class=\"text-right\">" + row.GetCell(j).ToString() + "</td>");
}
else
{
sb.Append("<td>" + row.GetCell(j).ToString() + "</td>");
}
}
}
sb.AppendLine("</tr>");
ItemList.Add(new InventoryOpenigStockImport {
ItemType = itemType, ImportBatch = BatchId, StoreId = storeId, FoodmenuId = item.FoodmenuId, PhysicalStockQty = item.PhysicalStockQty
});
}
sb.Append("</table>");
_inventoryOpenigStockImports = ItemList;
int Result = _iInventoryService.BulkImport(_inventoryOpenigStockImports);
}
}
}
catch (Exception ex)
{
SystemLogs.Register(ex.Message);
}
return(this.Content(sb.ToString()));
}
