/// <summary> /// Save /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header bool confidentialityAffected = PollutantTransferTrend.IsAffectedByConfidentiality(FacilityBasic.FacilityID, PollutantCode); Dictionary <string, string> header = CsvHeaderBuilder.GetFacilityTrendHeader(FacilityBasic.FacilityReportId, true); // Create Body string pollutantName = LOVResources.PollutantName(PollutantCode); List <TimeSeriesClasses.PollutantTransfers> data = getTimeSeriesData(FacilityBasic.FacilityID, PollutantCode); // dump to file string topheader = csvformat.CreateHeader(header); string pollutantHeader = csvformat.GetPollutantTransfersTrendHeader(); Response.WriteUtf8FileHeader("EPRTR_Pollutant_Transfers_Time_Series"); Response.Write(topheader + pollutantHeader); foreach (var v in data) { string row = csvformat.GetPollutantTransfersTrendRow(v, pollutantName); Response.Write(row); } Response.End(); } catch { } }
static void Main(string[] args) { Stopwatch sw = new Stopwatch(); sw.Start(); var csvHelper = new CSVFormatter(); var trainingArray = File.ReadAllLines("ExcelFiles/trainingsample.csv"); var recordsList = csvHelper.FormatToRecordList(trainingArray); var validationArray = File.ReadAllLines("ExcelFiles/validationsample.csv"); var validationrecordsList = csvHelper.FormatToRecordList(validationArray); var results = Prediction.Predict(recordsList, validationrecordsList); int accuracy = 0; for (var i = 0; i < results.ToArray().Length; i++) { if (results[i].Number.Equals(validationrecordsList[i].Number)) { accuracy++; } //Console.WriteLine($" The closest match for{i}-th record is {results[i].Number} || {validationrecordsList[i].Number} distance of {results[i].DistanceToNumber}"); } Console.WriteLine($"Accuracy is {accuracy} out of {validationArray.Length}"); sw.Stop(); Console.WriteLine(sw.Elapsed); Console.ReadLine(); }
/// <summary> /// Save transfers data /// </summary> public void DoSaveCSV(object sender, EventArgs e) { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); bool ConfidentialityAffected = WasteTransfers.IsAffectedByConfidentiality(SearchFilter); // Create Header Dictionary <string, string> header = CsvHeaderBuilder.GetWasteTransfersSearchHeader( SearchFilter, ConfidentialityAffected); IEnumerable <WasteTransfers.TransboundaryHazardousWasteData> wastedata = WasteTransfers.GetTransboundaryHazardousWasteData( SearchFilter, ConfidentialityAffected); Response.WriteUtf8FileHeader("EPRTR_Waste_Transfers_Transboundary_Hazardous"); // dump to file string topheader = csvformat.CreateHeader(header); string wasteHeader = csvformat.GetWasteHeader(); Response.Write(topheader + wasteHeader); foreach (var v in wastedata) { string row = csvformat.GetWasteRow(v); Response.Write(row); } Response.End(); }
public void CSVFormatting_WithValidInput_ThenOK() { //Arrange var input = new List <Sentence> { new Sentence { Words = new List <string> { "a", "had", "lamb", "little", "Mary" } }, new Sentence { Words = new List <string> { "Aesop", "and", "called", "came", "for", "Peter", "the", "wolf" } } }; var expected = @", Word 1, Word 2, Word 3, Word 4, Word 5, Word 6, Word 7, Word 8 Sentence 1, a, had, lamb, little, Mary Sentence 2, Aesop, and, called, came, for, Peter, the, wolf"; //Act var csvFormatter = new CSVFormatter(); var actual = csvFormatter.Format(input); //Assert expected.Should().BeEquivalentTo(actual); }
/// <summary> /// Save transfers data /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var header = CsvHeaderBuilder.GetTsPollutantTransfersSearchHeader(SearchFilter, ConfidentialityAffected); var data = PollutantTransferTrend.GetTimeSeries(SearchFilter); var pollutant = ListOfValues.GetPollutant(SearchFilter.PollutantFilter.PollutantID); string pollutantName = LOVResources.PollutantName(pollutant.Code); // dump to file string topheader = csvformat.CreateHeader(header); string rowheaders = csvformat.GetPollutantTransfersTimeSeriesHeader(); Response.WriteUtf8FileHeader("EPRTR_Pollutant_Transfers_Time_Series"); Response.Write(topheader + rowheaders); foreach (var v in data) { string row = csvformat.GetPollutantTransfersTimeSeriesRow(v, pollutantName); Response.Write(row); } Response.End(); } catch { } }
public void DoSaveCSV(object sender, EventArgs e) { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header IndustrialActivitySearchFilter filter = SearchFilter; bool isConfidentialityAffected = IndustrialActivity.IsWasteAffectedByConfidentiality(filter); Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetIndustrialActivitySearchHeader( filter, isConfidentialityAffected); // Create Body var rows = IndustrialActivity.GetWasteTransfers(filter); // dump to file string topheader = csvformat.CreateHeader(header); string rowHeader = csvformat.GetIndustrialActivityWasteTransfersHeader(); Response.WriteUtf8FileHeader("EPRTR_Industrial_Activity_Waste_Transfer_List"); Response.Write(topheader + rowHeader); foreach (var item in rows) { string row = csvformat.GetIndustrialActivityWasteTransfersRow(item); Response.Write(row); } Response.End(); }
/// <summary> /// Save /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header int facilityReportId = (int)ViewState[FACILITY_SPECIAL]; Dictionary <string, string> header = CsvHeaderBuilder.GetFacilityTrendHeader(facilityReportId, true); // Create Body List <TimeSeriesClasses.WasteTransfer> data = getTimeSeriesData(FacilityBasic.FacilityID, WasteType); // dump to file string topheader = csvformat.CreateHeader(header); string pollutantHeader = csvformat.GetWasteTransferTrendHeader(); Response.WriteUtf8FileHeader("EPRTR_Waste_Transfers_Time_Series"); Response.Write(topheader + pollutantHeader); foreach (var v in data) { string row = csvformat.GetWasteTransferTrendRow(v); Response.Write(row); } Response.End(); } catch { /*ignore all errors */ } }
public CSVCreator(Stream stream) : base(stream) { if (Stream == Stream.Null) { Stream = new MemoryStream(); } _formatter = new CSVFormatter(); }
/// <summary> /// Save /// </summary> /// public void DoSaveCSV(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header FacilitySearchFilter filter = SearchFilter; bool isConfidentialityAffected = Facility.IsAffectedByConfidentiality(filter); Dictionary <string, string> header = CsvHeaderBuilder.GetFacilitySearchHeader( filter, isConfidentialityAffected); // Create Body List <Facility.FacilityCSV> facilities = Facility.GetFacilityListCSV(filter); // dump to file string topheader = csvformat.CreateHeader(header).Replace("E-PRTR", "EPER"); string facilityHeader = csvformat.GetFacilityHeader(); string url = Request.Url.AbsoluteUri; url = url.Substring(0, url.LastIndexOf("/") + 1); Response.WriteUtf8FileHeader("EPER_Facility_List"); Response.Write(topheader + facilityHeader); foreach (var v in facilities) { // translate codes v.ActivityName = LOVResources.AnnexIActivityName(v.ActivityCode); v.CountryName = LOVResources.CountryName(v.CountryCode); v.NutsRegionName = LOVResources.NutsRegionName(v.NutsRegionCode); v.RiverBasinName = LOVResources.RiverBasinDistrictName(v.RiverBasinCode); v.FacilityName = ConfidentialFormat.Format(v.FacilityName, v.Confidential); v.PostalCode = ConfidentialFormat.Format(v.PostalCode, v.Confidential); v.Address = ConfidentialFormat.Format(v.Address, v.Confidential); v.City = ConfidentialFormat.Format(v.City, v.Confidential); v.URL = String.Format("{0}/PopupFacilityDetails.aspx?FacilityReportId={1}", url, v.FacilityReportID); string row = csvformat.GetFacilityRow(v); Response.Write(row); } Response.End(); } catch { } }
public void NullValuesShouldBeEmptyStrings() { var sut = new CSVFormatter(); var result = sut.FormatLine(new List <string> { "value a", null, "value c" }); result.ShouldBe("value a,,value c"); }
public void LineFeedValuesShouldBeSurroundedWithQuotes() { var sut = new CSVFormatter(); var result = sut.FormatLine(new List <string> { "value a", "value b", "value c", "value d\rvalue e\rvalue f" }); result.ShouldBe("value a,value b,value c,\"value d\rvalue e\rvalue f\""); }
public void QuotedValuesShouldBeSurroundedWithQuotes() { var sut = new CSVFormatter(); var result = sut.FormatLine(new List <string> { "value a", "\"value b\"", "value\"c", "value d" }); result.ShouldBe("value a,\"\"\"value b\"\"\",\"value\"\"c\",value d"); }
public void CommaValuesShouldBeSurroundedWithQuotes() { var sut = new CSVFormatter(); var result = sut.FormatLine(new List <string> { "value a", "value,b", "value c", "value d" }); result.ShouldBe("value a,\"value,b\",value c,value d"); }
public void NormalValuesShouldBeCommaDelimited() { var sut = new CSVFormatter(); var result = sut.FormatLine(new List <string> { "value a", "value b", "value c", "value d" }); result.ShouldBe("value a,value b,value c,value d"); }
public void ConvertWithoutRulesTest() { XDocument doc = _doc; string parentElementName = "EndOfDayTradeReportForClient"; IList <string> expected = new List <string>(); expected.Add("123456578,Buy,RUT,20,25.5,2013-10-01,Call"); expected.Add("123456578,Sell,RUT"); IList <string> actual; actual = CSVFormatter.Convert(doc, parentElementName); CompareStringLists(expected, actual); }
public void TestCsv() { CSVFormatter t = new CSVFormatter(_dataServiceMock.Object); var dummyItems = DataService.CreateDummyItems(); _dataServiceMock.Setup(d => d.ReadData()).Returns(dummyItems); t.Execute(); _dataServiceMock.Verify(d => d.OpenConnection(), Times.Once); string expectedText = getExpectedFormat(); _dataServiceMock.Verify(d => d.ExportData(expectedText), Times.Once); _dataServiceMock.Verify(d => d.CloseConnection(), Times.Once); }
public void ConvertWithRulesTest() { XDocument doc = _doc; string parentElementName = "EndOfDayTradeReportForClient"; IList <string> expected = new List <string>(); expected.Add("Adar,B,20,RUT,25.50,10/1/2013,C"); expected.Add(String.Format("Adar,S,,RUT,\"{0}\",,", String.Format(CSVErrorMessages_Accessor.ErrorMsgElementNotFound, "{http://tempuri.org/ClientReportDataset.xsd}StrikePrice"))); IList <string> actual; actual = CSVFormatter.Convert(doc, parentElementName, _rules); CompareStringLists(expected, actual); }
public void EvenTableWithSep() { Table table = new Table(); table[1, 1] = 1; table[2, 1] = 2; table[1, 2] = 3; table[2, 2] = 4; CSVFormatter sut = new CSVFormatter(table); string expected = "sep=;\n1;2\n3;4\n"; string actual = sut.GetCSV(table); Assert.AreEqual(expected, actual); }
public void DoSaveCSV(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var filter = SearchFilter; bool isConfidentialityAffected = WasteTransfers.IsAffectedByConfidentiality(filter); var tempFilter = filter.Clone() as WasteTransferSearchFilter; tempFilter.WasteTypeFilter = new WasteTypeFilter(SelectedWasteType); Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetWasteTransfersSearchHeader( tempFilter, isConfidentialityAffected); // Create Body var facilities = WasteTransfers.GetFacilityListCSV(tempFilter); // dump to file string topheader = csvformat.CreateHeader(header); string facilityHeader = csvformat.GetWasteTransfersFacilityHeader(); string url = Request.Url.AbsoluteUri; url = url.Substring(0, url.LastIndexOf("/") + 1); Response.WriteUtf8FileHeader("EPRTR_Waste_Transfers_Facility_List"); Response.Write(topheader + facilityHeader); foreach (var item in facilities) { item.Url = String.Format("{0}/PopupFacilityDetails.aspx?FacilityReportId={1}", url, item.FacilityReportId); string row = csvformat.GetWasteTransfersFacilityRow(item); Response.Write(row); } Response.End(); } catch { } }
public void EvenTableWithSepAndDifferentDelim() { Table table = new Table(); table.ColumnDelimiter = ','; table[1, 1] = 1; table[2, 1] = 2; table[1, 2] = 3; table[2, 2] = 4; CSVFormatter sut = new CSVFormatter(table); string expected = "sep=,\n1,2\n3,4\n"; string actual = sut.GetCSV(table); Assert.AreEqual(expected, actual); }
public void DoSaveCSV(object sender, EventArgs e) { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var filter = SearchFilter; int pollutantGroupID = getPollutantGroupID(); List <string> pollutantCodes = getOrderedPollutantCodes(); MediumFilter.Medium medium = this.ucMediumSelector.SelectedMedium; bool isConfidentialityAffected = AreaOverview.IsPollutantReleaseAffectedByConfidentiality(filter, medium, pollutantGroupID); Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetAreaoverviewPollutantReleaseSearchHeader(filter, pollutantGroupID, medium, isConfidentialityAffected); // Create Body List <AreaOverview.AOPollutantTreeListRow> rows = AreaOverview.GetPollutantReleaseActivityTree(filter, medium, pollutantGroupID, pollutantCodes).ToList(); sortData(rows); // dump to file string topheader = csvformat.CreateHeader(header); string pollutantinfoHeader = csvformat.GetAreaOverviewPollutantInfoHeader(getOrderedPollutants(filter, medium, pollutantGroupID)); string rowHeader = csvformat.GetAreaOverviewPollutantDataHeader(getOrderedPollutants(filter, medium, pollutantGroupID)); Response.WriteUtf8FileHeader("EPRTR_Areaoverview_PollutantReleases_List"); Response.Write(topheader + pollutantinfoHeader + rowHeader); foreach (var item in rows) { string row = csvformat.GetAreaOverviewPollutantsRow(item); if (AreaOverview.AOPollutantTreeListRow.CODE_TOTAL.Equals(item.Code)) { Response.Write(rowHeader); } Response.Write(row); } Response.End(); }
public void EvenTableWithNoSep() { Table table = new Table(); table.SpecifyColumnDelimiterInFile = false; table[1, 1] = 1; table[2, 1] = 2; table[1, 2] = 3; table[2, 2] = 4; CSVFormatter sut = new CSVFormatter(table); string expected = "1;2\n3;4\n"; string actual = sut.GetCSV(table); Assert.AreEqual(expected, actual); }
/// <summary> /// Save release data /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Check if current medium is affected confidentiality claims bool confidentialityAffected = PollutantReleaseTrend.IsAffectedByConfidentiality( SearchFilter, CurrentMedium); // Create Header var header = CsvHeaderBuilder.GetTsPollutantReleasesSearchHeader(SearchFilter, CurrentMedium, confidentialityAffected); var data = PollutantReleaseTrend.GetTimeSeries(SearchFilter, CurrentMedium); string mediumName = LOVResources.MediumName(EnumUtil.GetStringValue(CurrentMedium)); var pollutant = ListOfValues.GetPollutant(SearchFilter.PollutantFilter.PollutantID); string pollutantName = LOVResources.PollutantName(pollutant.Code); // dump to file string topheader = csvformat.CreateHeader(header); string rowheaders = csvformat.GetPollutantReleasesTimeSeriesHeader(); Response.WriteUtf8FileHeader("EPRTR_Pollutant_Releases_Time_Series"); Response.Write(topheader + rowheaders); foreach (var v in data) { string row = csvformat.GetPollutantReleasesTimeSeriesRow(v, pollutantName, mediumName); Response.Write(row); } Response.End(); } catch { } }
public void DoSaveCSV(object sender, EventArgs e) { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var filter = SearchFilter; bool isConfidentialityAffected = AreaOverview.IsWasteAffectedByConfidentiality(filter); Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetAreaoverviewWasteTransferSearchHeader(filter, isConfidentialityAffected); // Create Body List <AreaOverview.AOWasteTreeListRow> rows = AreaOverview.GetWasteTransferActivityTree(filter).ToList(); sortResult(rows); // dump to file string topheader = csvformat.CreateHeader(header); string rowHeader = csvformat.GetAreaOverviewWasteTransferHeader(); Response.WriteUtf8FileHeader("EPRTR_Areaoverview_WasteTransfers_List"); Response.Write(topheader + rowHeader); foreach (var item in rows) { string row = csvformat.GetAreaOverviewWasteTransferRow(item); if (AreaOverview.AOWasteTreeListRow.CODE_TOTAL.Equals(item.Code)) { Response.Write(Environment.NewLine); Response.Write(rowHeader); } Response.Write(row); } Response.End(); }
/// <summary> /// Save /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header int facilityReportId = (int)ViewState[FACILITY_REPORTID]; string pollutantCode = PollutantCode; bool confidentialityAffected = PollutantReleaseTrend.IsAffectedByConfidentiality(FacilityBasic.FacilityID, PollutantCode, CurrentMedium); Dictionary <string, string> header = CsvHeaderBuilder.GetFacilityTrendHeader(facilityReportId, confidentialityAffected); // Create Body string mediumName = LOVResources.MediumName(EnumUtil.GetStringValue(CurrentMedium)); string codeEPER = pollutantCode + "EPER"; string pollutantName = LOVResources.PollutantNameEPER(pollutantCode, codeEPER); List <TimeSeriesClasses.PollutantReleases> data = getTimeSeriesData(FacilityBasic.FacilityID, CurrentMedium); // dump to file string topheader = csvformat.CreateHeader(header); string pollutantHeader = csvformat.GetPollutantReleaseTrendHeader(); Response.WriteUtf8FileHeader("EPRTR_Pollutant_Releases_Time_Series"); Response.Write(topheader + pollutantHeader); foreach (var v in data) { string row = csvformat.GetPollutantReleaseTrendRow(v, pollutantName, mediumName); Response.Write(row); } Response.End(); } catch { } }
/// <summary> /// Save waste transfers data /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // TODO: Consider moving this value to ViewState bool isCurrentWasteTypeAffectedByConfidentiality = WasteTransferTrend.IsAffectedByConfidentiality(SearchFilter, CurrentWasteType); // Create Header var header = CsvHeaderBuilder.GetTsWasteTransfersSearchHeader( SearchFilter, CurrentWasteType, isCurrentWasteTypeAffectedByConfidentiality); var data = WasteTransferTrend.GetTimeSeries(SearchFilter, CurrentWasteType); // dump to file string topheader = csvformat.CreateHeader(header); string rowheaders = csvformat.GetWasteTransfersTimeSeriesHeader(); Response.WriteUtf8FileHeader("EPRTR_Waste_Transfers_Time_Series"); Response.Write(topheader + rowheaders); foreach (var v in data) { string row = csvformat.GetWasteTransfersTimeSeriesRow(v); Response.Write(row); } Response.End(); } catch { } }
/// <summary> /// Save transfers data /// </summary> public void DoSaveCSV(object sender, EventArgs e) { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var filter = SearchFilter; bool isConfidentialityAffected = WasteTransfers.IsAffectedByConfidentiality(filter); Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetWasteTransfersSearchHeader( filter, isConfidentialityAffected); // Create Body var rows = WasteTransfers.GetActivityTree(filter); // dump to file string topheader = csvformat.CreateHeader(header); string[] colHeaderRows = csvformat.GetWasteTransferActivityColHeaderRows(filter); Response.WriteUtf8FileHeader("EPRTR_Waste_Transfers_Activity_List"); Response.Write(topheader + colHeaderRows[0] + colHeaderRows[1] + colHeaderRows[2]); //all rows but total foreach (var item in rows.Where(r => r.Code != ActivityTreeListRow.CODE_TOTAL)) { string row = csvformat.GetWasteTransferActivityRow(item, filter); Response.Write(row); } //write total row var totalRow = rows.SingleOrDefault(r => r.Code == ActivityTreeListRow.CODE_TOTAL); if (totalRow == null) { //find all rows on topLevel. if only one, use this as total row var toplevelRows = rows.Where(r => r.Level == 0); if (toplevelRows != null && toplevelRows.Count() == 1) { totalRow = toplevelRows.Single(); } } //write total row if any is found if (totalRow != null) { Response.Write(Environment.NewLine); Response.Write(csvformat.AddText(Resources.GetGlobal("Common", "Total"))); Response.Write(Environment.NewLine); string[] totalColHeaderRows = csvformat.GetWasteTransferActivityColHeaderRows(filter); Response.Write(totalColHeaderRows[0] + totalColHeaderRows[1]); string row = csvformat.GetWasteTransferActivityRow(totalRow, filter); Response.Write(row); } Response.End(); }
public void Read() { Reader reader = new Reader(Path.Combine(LocalDirectory, "ExampleFile.csv")); LineDataReader lineDataReader = new LineDataReader(reader, Encoding.UTF8); CSVFormatter csvFormatter = new CSVFormatter(lineDataReader); int lastRowIndex = 0; csvFormatter.Read((rowIndex, columns) => { lastRowIndex = rowIndex; switch (rowIndex) { case 0: Assert.AreEqual(columns[0], "NAME"); Assert.AreEqual(columns[1], "SURNAME"); Assert.AreEqual(columns[2], "OLD"); break; case 1: Assert.AreEqual(columns[0], "MUHAMMED"); Assert.AreEqual(columns[1], "KANDEMIR"); Assert.AreEqual(columns[2], "23"); break; case 2: Assert.AreEqual(columns[0], "HAMZA"); Assert.AreEqual(columns[1], "KANDEMIR"); Assert.AreEqual(columns[2], "19"); break; case 3: Assert.AreEqual(columns[0], "MUHAMMED"); Assert.AreEqual(columns[1], "KANDEMIR"); Assert.AreEqual(columns[2], "2\"3"); break; case 4: Assert.AreEqual(columns[0], "\"HAMZA"); Assert.AreEqual(columns[1], "KAN\"DEMIR"); Assert.AreEqual(columns[2], "1\"\"9\""); break; case 5: Assert.AreEqual(columns[0], "MUHAMMED"); Assert.AreEqual(columns[1], "KANDEMIR"); Assert.AreEqual(columns[2], "23"); break; case 6: Assert.AreEqual(columns[0], "HAMZA"); Assert.AreEqual(columns[1], "KAN\"DEMIR"); Assert.AreEqual(columns[2], "1\"\"9\""); break; default: break; } }); Assert.AreEqual(lastRowIndex, 6); }