public Program()
{
filereader = new Filereader();
string inPath = AppDomain.CurrentDomain.BaseDirectory + "in.xlsx";
Console.WriteLine(inPath);
Excel excel = new Excel(inPath);
try
{
for (int i = 0; i < excel.getRows() && i < 10; i++)
{
excel.WriteCell(i, 0, FixRow(excel.ReadCell(i, 0)));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
Console.WriteLine();
Console.WriteLine("Finished! Used time: " + (DateTime.UtcNow - Process.GetCurrentProcess().StartTime.ToUniversalTime()) + "!");
excel.Save();
excel.Close();
}
//helpers
// read textures.txt and process data
static bool loadGraphics(string address)
{
Filereader filereader = new Filereader(address);
filereader.processTextures();
return(true);
}
public void GetNamesFromFileByDate_FileFound_ReturnsName()
{
var result =
Filereader.GetNamesFromFileByDate("2.9.",
Path.Combine(
Directory.GetCurrentDirectory(),
"nimet.csv"));
Assert.Equal("Sinikka, Sini, Justus", result);
}
public void GetNamesFromFileByDate_FileNotFound_ThrowsException()
{
Exception ex = Assert.Throws <Exception>(() =>
Filereader.GetNamesFromFileByDate("2.9.",
Path.Combine(
Directory.GetCurrentDirectory(),
"asdasd.dsa")));
Assert.Equal("File not found.", ex.Message);
}
public void GetNamesFromFileByDate_FileFormatWrong_ThrowsException()
{
Exception ex = Assert.Throws <Exception>(() =>
Filereader.GetNamesFromFileByDate("2.9.",
Path.Combine(
Directory.GetCurrentDirectory(),
"NameDay.pdb")));
Assert.Equal("File is in incorrect format.", ex.Message);
}
public void GetNamesByDate_DateOnList_ReturnsName()
{
var result = Filereader.GetNamesByDate(NamesAndDates.AsQueryable(), "30.11.");
Assert.Equal("Antti, Atte", result);
}
public void GetNamesByDate_DateNotOnList_ReturnsNotFound()
{
var result = Filereader.GetNamesByDate(NamesAndDates.AsQueryable(), "11.11.");
Assert.Equal("No names found on given date.", result);
}
