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