private List <ImportModel.rawImport> ReadInputFile()
{
List <ImportModel.rawImport> recordsIn = new List <ImportModel.rawImport>();
var fred = TempData["path"].ToString();
//var filesData = Directory.GetFiles(@fred);
string path = Server.MapPath("~/App_Data/" + fred);
//string path = Server.MapPath(fred.ToString());
var package = new OfficeOpenXml.ExcelPackage(new FileInfo(path));
OfficeOpenXml.ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
for (int row = workSheet.Dimension.Start.Row;
row <= workSheet.Dimension.End.Row;
row++)
{
if (ExcelData.HasData(workSheet, row))
{
decimal price = 0.0m;
ImportModel.rawImport obj = new ImportModel.rawImport();
obj.Sku = ExcelData.GetPBSKU(workSheet, row);
obj.FormSizeCode = ExcelData.GetPBFSCOde(workSheet, row);
obj.Name = ExcelData.GetName(workSheet, row);
obj.FormSize = ExcelData.GetFSDecription(workSheet, row);
price = ExcelData.GetPrice(workSheet, row);
obj.FromDate = null;
// obj.FromDate = ExcelData.GetDate(workSheet, row);
obj.Price = price * 100;
obj.Location = "PB";
recordsIn.Add(obj);
}
}
return(recordsIn);
}
