public static void WhenWrongFileisInputedThenDataTableMustBeNull() { String path = ReturnPath("Someone.csv"); System.Data.DataTable dt = CsvToDatatable.ConvertCsvtoDatatable(path); Assert.True(dt == null); }
public static void WhenDatatableisReturnedThenNumberofColumnsMustbe2() { String path = ReturnPath("DateTimeSpaCustomer.csv"); System.Data.DataTable dt = CsvToDatatable.ConvertCsvtoDatatable(path); Assert.True(dt.Columns.Count == 2); }
public static void WhenCsvFileisConvertedThenDataTableMustBeNotNull() { String path = ReturnPath("DateTimeSpaCustomer.csv"); System.Data.DataTable dt = CsvToDatatable.ConvertCsvtoDatatable(path); Assert.False(dt == null); }
public async Task <IActionResult> Index(IFormFile file) { DataTable dTable; string fPath = CSVManipulation.uploadToServer(file); dTable = CsvToDatatable.ConvertCSVtoDataTable(fPath); vcfFileName = DatatableToVcf.ConvertDatatableToVcf(dTable, Path.GetFileNameWithoutExtension(fPath)); return(View()); }
static void Main() { DataTable dt = new DataTable(); try { Console.WriteLine("Input any not numeric string or Press Enter to execute this module without Console Redirection"); ReadConsole datatablereader = new ReadConsole(); dt = datatablereader.AddColumns(dt); dt = datatablereader.AddRows(dt); } catch (Exception) { try { Console.WriteLine("The file is running without Console Redirection"); String file = System.Configuration.ConfigurationManager.AppSettings["filename"]; String path = Directory.GetCurrentDirectory(); path += @"\" + file; dt = CsvToDatatable.ConvertCsvtoDatatable(path); } catch (Exception) { Console.WriteLine("Some error occured"); } } finally { CultureInfo culture = new CultureInfo("en-US"); string dateString = "07-01-2020"; DateTime date = DateTime.ParseExact(dateString, new[] { "MM.dd.yyyy", "MM-dd-yyyy", "MM/dd/yyyy" }, culture, DateTimeStyles.None); if (dt != null) { double avghour = Analytics.AverageInHour(dt, date); double avgweek = Analytics.AvergaeInweek(dt, date); int avgpeak = Analytics.PeakLastMonth(dt); DataTable dtresults = new DataTable(); String storingresultsfile = "Results.csv"; String pathtoresultfile = Directory.GetCurrentDirectory(); pathtoresultfile += @"\" + storingresultsfile; FileExistsfunction(pathtoresultfile); dtresults = CreateDataTableResults(dtresults, avghour, avgweek, avgpeak); DataTableTocsv.ToCsv(dtresults, pathtoresultfile); Console.WriteLine("The result is stored in " + pathtoresultfile); } else { Console.WriteLine("DataTable is Null Check your file stream"); } } }
// ReSharper disable once RedundantAssignment private static DataTable Convert(DataTable dt) { String file = "DateTimeSpaCustomer.csv"; String path = Directory.GetCurrentDirectory(); path += @"\" + file; dt = CsvToDatatable.ConvertCsvtoDatatable(path); return(dt); }