public void writeDataToCsv(TableVersion.Value tableVersion, IList <IVersionAgnostic> csvDataList, string fileName, IList <string> columnNames) { var streamWriter = new StreamWriter(fileName); streamWriter.Write(getCsv(tableVersion, csvDataList, columnNames)); streamWriter.Close(); }
public IList <IVersionAgnostic> getCsvData(TableVersion.Value tableVersion, string searchName, Tail tail, Ear ear, Nose nose, DateAndTime dateAndTime, GeoLocationData latitudeData, GeoLocationData longitudeData) { var dbContext = new Model1(); var builder = new Builder(); IQueryable <IVersionAgnostic> csvData = null; if (tableVersion == TableVersion.Value.Version1) { csvData = dbContext.csvWithDataVersion1.AsQueryable(); } else { csvData = dbContext.csvWithDataVersion2.AsQueryable(); } csvData = builder.addNameFilter(csvData, searchName); csvData = builder.tailHighFilter(csvData, tail.highData); csvData = builder.tailLowFilter(csvData, tail.lowData); csvData = builder.earHighFilter(csvData, ear.highData); csvData = builder.earLowFilter(csvData, ear.lowData); csvData = builder.noseHighFilter(csvData, nose.highData); csvData = builder.noseLowFilter(csvData, nose.lowData); csvData = builder.DateFilter(csvData, dateAndTime); csvData = builder.LatitudeFilter(csvData, latitudeData); csvData = builder.LongitudeFilter(csvData, longitudeData); return(csvData.ToList()); }
public DataTable getDataTable(TableVersion.Value tableVersion, string searchName, Tail tail, Ear ear, Nose nose, DateAndTime dateAndTime, GeoLocationData latitudeData, GeoLocationData longitudeData) { return(dataTableFactory.getDataTable( tableVersion, getCsvData(tableVersion, searchName, tail, ear, nose, dateAndTime, latitudeData, longitudeData), csvDataProvider.getCsvColumnNames(tableVersion))); }
public void generateCsv(TableVersion.Value tableVersion, string fileName, string searchName, Tail tail, Ear ear, Nose nose, DateAndTime dateAndTime, GeoLocationData latitudeData, GeoLocationData longitudeData) { csvDataToCsvTransformer.writeDataToCsv( tableVersion, getCsvData(tableVersion, searchName, tail, ear, nose, dateAndTime, latitudeData, longitudeData), fileName, csvDataProvider.getCsvColumnNames(tableVersion)); }
private DataRow getRow(TableVersion.Value tableVersion, IVersionAgnostic csvData, IList <string> csvColumnNames, DataTable dataTable) { var dataRow = dataTable.NewRow(); if (tableVersion == TableVersion.Value.Version1) { return(getVersion1Row(csvData, csvColumnNames, dataRow)); } return(getVersion2Row(csvData, csvColumnNames, dataRow)); }
public DataTable getDataTable(TableVersion.Value tableVersion, IList <IVersionAgnostic> csvDataList, IList <string> csvColumnNames) { var dataTable = new DataTable(); dataTable.Columns.AddRange(getDataColumns(csvColumnNames)); for (int rowCount = 0; rowCount < csvDataList.Count; rowCount++) { dataTable.Rows.Add(getRow(tableVersion, csvDataList[rowCount], csvColumnNames, dataTable)); } return(getDataTableWithCorrectDataTypesForColumns(dataTable)); }
public string getCsv(TableVersion.Value tableVersion, IList <IVersionAgnostic> csvDataList, IList <string> columnNames) { var stringBuilder = new StringBuilder(); stringBuilder.AppendLine(String.Join(",", columnNames)); foreach (var item in csvDataList) { stringBuilder.AppendLine(getCsvRow(tableVersion, item, columnNames)); } return(stringBuilder.ToString().TrimEnd(Environment.NewLine.ToCharArray())); }
public IList <string> getCsvColumnNames(TableVersion.Value tableVersion) { Type type; if (tableVersion == TableVersion.Value.Version1) { type = typeof(csvWithDataVersion1); } else { type = typeof(csvWithDataVersion2); } return(type. GetProperties(). Select(x => x.Name). ToList()); }
private string getCsvRow(TableVersion.Value tableVersion, IVersionAgnostic csvData, IList <string> csvColumnNames) { if (tableVersion == TableVersion.Value.Version1) { var csvDataList = new List <string>(); for (int columnCount = 0; columnCount < csvColumnNames.Count; columnCount++) { csvDataList.Add(csvWithDataVersionPropertyValueService.version1(csvData, csvColumnNames[columnCount]).ToString()); } return(String.Join(",", csvDataList)); } else { var csvDataList = new List <string>(); for (int columnCount = 0; columnCount < csvColumnNames.Count; columnCount++) { csvDataList.Add(csvWithDataVersionPropertyValueService.version2(csvData, csvColumnNames[columnCount]).ToString()); } return(String.Join(",", csvDataList)); } }
private IList <IVersionAgnostic> getCsvData(TableVersion.Value tableVersion, string searchName, Tail tail, Ear ear, Nose nose, DateAndTime dateAndTime, GeoLocationData latitudeData, GeoLocationData longitudeData) { return(csvDataProvider.getCsvData(tableVersion, searchName, tail, ear, nose, dateAndTime, latitudeData, longitudeData)); }