private static ICSVAddress FindAddress(ICSVAddress address, Func <ICSVAddress, bool> validator, Func <ICSVAddress, ICSVAddress> mover)
{
ICSVAddress nextCursor = address;
while (validator(nextCursor))
{
address = nextCursor;
nextCursor = mover(address);
}
return(address);
}
//private static ICSVAddress ToTableRightCol(ICSVAddress address)
//{
// ICSVAddress nextCursor = address;
// int r = address.Row;
// int c = address.Column;
// while (nextCursor.IsValid() && !nextCursor.IsBlank())
// {
// address = nextCursor;
// nextCursor = new CSVAddress(r, ++c, address.Plane);
// }
// return address;
//}
//private static ICSVAddress ToTableTopRow(ICSVAddress address)
//{
// ICSVAddress nextCursor = address;
// int r = address.Row;
// int c = address.Column;
// while (nextCursor.IsValid() && !nextCursor.IsBlank())
// {
// address = nextCursor;
// nextCursor = new CSVAddress(--r, c,address.Plane);
// }
// return address;
//}
private static ICSVAddress GoToTopLeftAddress(int row, int col, string[,] csvReport)
{
ICSVAddress topRow = FindAddress
(
new CSVAddress(row, col, csvReport),
(a) => { return(a.IsValid() && !a.IsBlank()); },
(a) => { return(new CSVAddress(a.Row - 1, a.Column, a.Plane)); }
);
ICSVAddress topLeft = FindAddress
(
topRow,
(a) => { return(a.IsValid() && !a.IsBlank()); },
(a) => { return(new CSVAddress(a.Row, a.Column - 1, a.Plane)); }
);
return(topLeft);
}
private int GetRowCount(ICSVAddress topLeftCorner, string[,] csvReport, Func <ICSVAddress, bool> cellValidator)
{
List <int> lengths = new List <int>();
ICSVAddress checkAddr = new CSVAddress(topLeftCorner.Row, topLeftCorner.Column, csvReport);
for (int columnIndex = topLeftCorner.Column; cellValidator(checkAddr); columnIndex++)
{
int length = 0;
ICSVAddress nextAddress = new CSVAddress(checkAddr.Row, checkAddr.Column, csvReport);
while (cellValidator(nextAddress))
{
length++;
nextAddress = new CSVAddress(nextAddress.Row + 1, nextAddress.Column, csvReport);
}
lengths.Add(length);
checkAddr = new CSVAddress(topLeftCorner.Row, columnIndex, csvReport);
}
return(lengths.Count > 0 ? lengths.Max() : 0);
}
public static CSVTable FindTable(IUniqueNameProvider _nameProvider, int row, int col, string[,] csvReport)
{
CSVTable table = new CSVTable();
ICSVAddress topLeftAddess = GoToTopLeftAddress(row, col, csvReport);
ICSVAddress nextAddress = topLeftAddess;
while (nextAddress.IsValid() && !nextAddress.IsBlank() && !nextAddress.Value.IsNumeric())
{
ICSVAddress address = nextAddress;
table.AddAddress(address);
//Add the header while you're at it
table.AddHeader(_nameProvider.GetUniqueName(table.Headers.ToArray(), address.Value));
nextAddress = new CSVAddress(address.Row, address.Column + 1, csvReport);
}
if (table.Headers.Count() < 3)
{
return(null);
}
//int columnDepth = table.GetLongestColumn(csvReport, (r, c, report) => { return report[r, c] != string.Empty; });
int endColumns = GetTopRightAddress(row, col, csvReport).Column + 1;
int rowWidth = table.Addresses.Count(); //The current count of the addresses is only the header width: g2g
//int endRows = topLeftAddess.Row + table.GetRowCount(topLeftAddess, csvReport, (a)=> { return a.IsValid() && !a.IsBlank() && !a.IsZero(); });
//Add the headers to the table addresses
//for(int header = topLeftAddess.Column; header < endColumns; header++)
//{
// table.AddAddress(new CSVAddress(topLeftAddess.Row, header, csvReport));
//}
//int currentCol = topLeftAddess.Column;
int currentRow = topLeftAddess.Row + 1;
//List<string[]> records = new List<string[]>();
string[] record = csvReport.SubArray(currentRow, topLeftAddess.Column, rowWidth);
//while (!record.OnlyContains(new string[]{ string.Empty, "0" }))
while (!record.OnlyContains(new Func <string, bool>[]
{
(s) => s == string.Empty,
(s) => s == "0",
(s) => s.IsNumeric() && double.Parse(s) == 0
}
))
{
table.AddRecord(record);
for (int tableColumn = 0; tableColumn < rowWidth; tableColumn++)
{
table.AddAddress(new CSVAddress(currentRow, topLeftAddess.Column + tableColumn, csvReport));
}
currentRow++;
if (currentRow < csvReport.GetLength(0))
{
record = csvReport.SubArray(currentRow, topLeftAddess.Column, rowWidth);
}
else
{
break;
}
}
//while (currentRow < endRows)
//{
// CSVAddress address = new CSVAddress(currentRow, currentCol, csvReport);
// table.AddAddress(address);
// record.Add(address.Value);
// currentCol++;
// if (currentCol >= endColumns)
// {
// string[] tuple = record.ToArray();
// if (!tuple.OnlyContains(new string[] { string.Empty, "0"}))
// {
// table.AddRecord(record.ToArray());
// record = new List<string>();
// currentCol = topLeftAddess.Column;
// currentRow++;
// }
// else break;
// }
//}
if (table.Records.Count() < 1)
{
return(null);
}
return(table);
}
private void AddAddress(ICSVAddress address)
{
_addresses.Add(address);
}
private void MarkInspected(ICSVAddress address)
{
_inspected[address.Row, address.Column] = true;
}
