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