public ge_data_table NewFile(ge_search dic, string[] lines, Guid dataId, Guid templateId) { search_table st = dic.search_tables[0]; search_range sr = st.header; string header_row = dic.search_items.Find(e => e.name == sr.search_item_name).row_text; string[] columns = Split(header_row, 100); int line_start = dic.data_start_row(NOT_FOUND); int line_end = dic.data_end_row(lines.Count()); ge_data_table _dt = new ge_data_table(st.name, columns); for (int i = line_start; i < line_end; i++) { string line = lines[i]; if (line.Length > 0) { string[] values = Split(line, _dt.dt.Columns.Count); DataRow row = _dt.dt.NewRow(); set_values(columns, values, row); _dt.dt.Rows.Add(row); } } return(_dt); }
private async Task <IActionResult> ReadPSDData(ge_search template, ge_log_workbook wb, string sheet) { search_table st = template.search_tables[0]; int psize_col = st.headers.Find(e => e.id == "PARTICLESIZE").found; int descr_row = template.search_items.Find(e => e.name == "soil_description").row; int cobble_row = template.search_items.Find(e => e.name == "cobbles").row; int gravel_row = template.search_items.Find(e => e.name == "gravel").row; int sand_row = template.search_items.Find(e => e.name == "sand").row; int silt_row = template.search_items.Find(e => e.name == "silt").row; int clay_row = template.search_items.Find(e => e.name == "clay").row; int sampid_row = template.search_items.Find(e => e.name == "sample_ref").row; int depth_row = template.search_items.Find(e => e.name == "sample_depth").row; int line_start = template.data_start_row(-1); int line_end = template.data_end_row(40); List <GRAG_WC> GRAG_WC = new List <GRAG_WC>(); foreach (value_header vh in st.headers) { if (vh.id == "PARTICLESIZE") { continue; } GRAG_WC gg = new GRAG_WC(); gg.PointID = vh.id; gg.SAMP_Depth = getDouble(wb.getValue(depth_row, vh.found)).Value; gg.Depth = getDouble(wb.getValue(depth_row, vh.found)).Value; gg.SAMP_ID = Convert.ToString(wb.getValue(sampid_row, vh.found)); gg.SPEC_DESC = Convert.ToString(wb.getValue(descr_row, vh.found)); gg.SAMP_TYPE = "EB"; gg.GRAG_VCRE = getDouble(wb.getValue(cobble_row, vh.found)); gg.GRAG_GRAV = getDouble(wb.getValue(gravel_row, vh.found)); gg.GRAG_SAND = getDouble(wb.getValue(sand_row, vh.found)); gg.GRAG_SILT = getDouble(wb.getValue(silt_row, vh.found)); gg.GRAG_CLAY = getDouble(wb.getValue(clay_row, vh.found)); GRAG_WC.Add(gg); for (int i = line_start; i <= line_end; i++) { string psize = Convert.ToString(wb.getValue(i, psize_col)); if (psize == "") { break; } string ppassing = Convert.ToString(wb.getValue(i, vh.found)); if (ppassing == "") { break; } GRAT gt = newGRAT(gg); gt.Reading = Convert.ToDouble(psize); gt.GRAT_PERP = Convert.ToInt16(ppassing); gg.GRAT.Add(gt); } } return(Ok(GRAG_WC)); }
public ge_log_file NewFile(ge_search dic, string[] lines, Guid dataId, Guid templateId) { ge_log_file file = new ge_log_file(); file.dataId = dataId; file.templateId = templateId; file.search_template = dic; file.file_headers = dic.search_items; file.file_array = dic.array_items; search_table st = dic.search_tables.FirstOrDefault(); file.search_table = st; file.field_headers = st.headers; file.channel = st.name; value_header DateTimeReading = dic.getHeader(ge_log_constants.READINGDATETIME); int intReadTime = NOT_FOUND; if (DateTimeReading != null) { intReadTime = DateTimeReading.found; } value_header Duration = dic.getHeader(ge_log_constants.DURATION); int intDuration = NOT_FOUND; if (Duration != null) { intDuration = Duration.found; } value_header Header1 = dic.getHeader(ge_log_constants.VALUE1); int intValue1 = NOT_FOUND; if (Header1 != null) { intValue1 = Header1.found; } value_header Header2 = dic.getHeader(ge_log_constants.VALUE2); int intValue2 = NOT_FOUND; if (Header2 != null) { intValue2 = Header2.found; } value_header Header3 = dic.getHeader(ge_log_constants.VALUE3); int intValue3 = NOT_FOUND; if (Header3 != null) { intValue3 = Header3.found; } value_header Header4 = dic.getHeader(ge_log_constants.VALUE4); int intValue4 = NOT_FOUND; if (Header4 != null) { intValue4 = Header4.found; } value_header Header5 = dic.getHeader(ge_log_constants.VALUE5); int intValue5 = NOT_FOUND; if (Header5 != null) { intValue5 = Header5.found; } value_header Header6 = dic.getHeader(ge_log_constants.VALUE6); int intValue6 = NOT_FOUND; if (Header6 != null) { intValue6 = Header6.found; } value_header Header7 = dic.getHeader(ge_log_constants.VALUE7); int intValue7 = NOT_FOUND; if (Header7 != null) { intValue7 = Header7.found; } value_header Header8 = dic.getHeader(ge_log_constants.VALUE8); int intValue8 = NOT_FOUND; if (Header8 != null) { intValue8 = Header8.found; } value_header Header9 = dic.getHeader(ge_log_constants.VALUE9); int intValue9 = NOT_FOUND; if (Header9 != null) { intValue9 = Header9.found; } value_header Header10 = dic.getHeader(ge_log_constants.VALUE10); int intValue10 = NOT_FOUND; if (Header10 != null) { intValue10 = Header10.found; } value_header Header11 = dic.getHeader(ge_log_constants.VALUE11); int intValue11 = NOT_FOUND; if (Header11 != null) { intValue11 = Header11.found; } value_header Header12 = dic.getHeader(ge_log_constants.VALUE12); int intValue12 = NOT_FOUND; if (Header12 != null) { intValue12 = Header12.found; } value_header Header13 = dic.getHeader(ge_log_constants.VALUE13); int intValue13 = NOT_FOUND; if (Header13 != null) { intValue13 = Header13.found; } value_header Header14 = dic.getHeader(ge_log_constants.VALUE14); int intValue14 = NOT_FOUND; if (Header14 != null) { intValue14 = Header14.found; } value_header Header15 = dic.getHeader(ge_log_constants.VALUE15); int intValue15 = NOT_FOUND; if (Header15 != null) { intValue15 = Header15.found; } value_header Header16 = dic.getHeader(ge_log_constants.VALUE16); int intValue16 = NOT_FOUND; if (Header16 != null) { intValue16 = Header16.found; } value_header Header17 = dic.getHeader(ge_log_constants.VALUE17); int intValue17 = NOT_FOUND; if (Header17 != null) { intValue17 = Header17.found; } value_header Header18 = dic.getHeader(ge_log_constants.VALUE18); int intValue18 = NOT_FOUND; if (Header18 != null) { intValue18 = Header18.found; } value_header HeaderRemark = dic.getHeader(ge_log_constants.REMARK); int intRemark = NOT_FOUND; if (HeaderRemark != null) { intRemark = HeaderRemark.found; } value_header log_wdepthM = file.getHeaderByIdUnits(ge_log_constants.WDEPTH, "m"); int intCheckValueForDry = NOT_FOUND; if (log_wdepthM != null) { intCheckValueForDry = log_wdepthM.found; } file.readings = new List <ge_log_reading>(); int line_start = dic.data_start_row(NOT_FOUND); int line_end = dic.data_end_row(lines.Count()); int readlines = addReadingsAny(file.readings, lines, line_start, line_end, intReadTime, intDuration, intValue1, intValue2, intValue3, intValue4, intValue5, intValue6, intValue7, intValue8, intValue9, intValue10, intValue11, intValue12, intValue13, intValue14, intValue15, intValue16, intValue17, intValue18, intRemark, intCheckValueForDry, DateTimeReading.format ); if (readlines <= 0) { return(null); } file.init_new_file(); file.calcReadingAggregates(); return(file); }