public static TableModel CogeFetcher(MemoryStream memoryStream)
{
ExcelSupport excelSupport = new ExcelSupport();
TableModel CogeTable = new TableModel();
TableModel CogeOut = new TableModel();
TableModel CogeDisplayTable = new TableModel();
RowsModel rowsModel = new RowsModel();
try
{
CogeTable = excelSupport.ExcelTableLoader(memoryStream, "REV_CUST");
Console.WriteLine("Coge File Loaded");
CogeDisplayTable = BuildCoge(CogeTable);
Console.WriteLine("File Decoded");
CogeOut = SortTable(CogeDisplayTable);
CogeOut.Header = CogeDisplayTable.Header;
CogeOut.Other = CogeDisplayTable.Other;
CogeOut.Footer = CogeDisplayTable.Footer;
return(CogeOut);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
public RowsModel ExcelTableLoader(string ExcelPath, string TableName, bool RowModelFlag)
{
RowsModel LoadedRowTable = new RowsModel();
MemoryStream inMemoryCopy = new MemoryStream();
try
{
using (FileStream fs = File.OpenRead(ExcelPath))
{
fs.CopyTo(inMemoryCopy);
}
TablesModel Tables = new TablesModel();
ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy);
var package = excelPackage;
Tables = Parse(package, false);
var Result = FetchTableByName(Tables, TableName);
RowsModel rowsModel = new RowsModel();
foreach (var row in Result.Body)
{
RowsModel.RowModel row2 = new RowsModel.RowModel();
int cell2 = 0;
foreach (var cell in row.Cells)
{
row2.Cells[cell2].Value = cell.Value;
cell2 += 1;
}
rowsModel.Rows.Add(row2);
}
LoadedRowTable = rowsModel;
var count = LoadedRowTable.Rows.Count;
Debug.WriteLine("Row Count: " + count);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
return(LoadedRowTable);
}
public static TableModel GecoFetcher(string path)
{
ExcelSupport excelSupport = new ExcelSupport();
TableModel GecoTable = new TableModel();
TableModel GecoDisplayTable = new TableModel();
RowsModel rowsModel = new RowsModel();
try
{
GecoTable = excelSupport.ExcelTableLoader(path, "Profit & Loss");
rowsModel = excelSupport.ExcelTableLoader(path, "Profit & Loss", true);
Console.WriteLine("Geco File Loaded");
GecoDisplayTable = BuildGeco(GecoTable);
Console.WriteLine("File Decoded");
return(GecoDisplayTable);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
public static TableModel GecoFetcher(MemoryStream memoryStream)
{
RowsModel RowsSorted = new RowsModel();
RowModel rowModel = new RowModel();
ExcelSupport excelSupport = new ExcelSupport();
TableModel GecoTable = new TableModel();
TableModel GecoDisplayTable = new TableModel();
//IList<RowModel> rowsModel;
try
{
GecoTable = excelSupport.ExcelTableLoader(memoryStream, "Profit & Loss");
Console.WriteLine("Geco File Loaded");
GecoDisplayTable = BuildGeco(GecoTable);
Console.WriteLine("File Decoded");
return(GecoDisplayTable);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
private static TableModel GecoGather(List <GecoPosition> gecoPositions, TableModel table)
{
RowsModel Rows = new RowsModel();
TableModel displayTable = new TableModel();
RowModel headerRow = GetHeaderRow(table);
//displayTable.Body.Add(headerRow);
displayTable.Header = headerRow;
int entityCount = gecoPositions.Count - 1;
var gecoRow = new RowModel();
for (int i = 0; i < entityCount; i++)
{
var GecoRow = new RowModel();
GecoRow = ParseGecoRow(table, gecoPositions[i].CustomerName, gecoPositions[i].TotalRow);
displayTable.Body.Add(GecoRow);
}
gecoRow = ParseGecoRow(table, gecoPositions[entityCount].CustomerName, gecoPositions[entityCount].CustomerRow);
displayTable.Footer = gecoRow;
return(displayTable);
}
