public static string FindNamesOfDate(List <NameDate> nameDates, DateTime date)
{
NameDate name = nameDates.FirstOrDefault(nd => nd.Day == date.Day && nd.Month == date.Month);
string namesOfTheDate = name != null ? name.Names : $"No names found from file for the date {date}";
return(namesOfTheDate);
}
public static List <NameDate> LoadCSV(string filename)
{
string whole_file;
try
{
// Get the file's text.
whole_file = System.IO.File.ReadAllText(filename);
}
catch (System.IO.FileNotFoundException)
{
throw new System.IO.FileNotFoundException($"inserted file name from path: {filename} is not found");
}
// Split into lines.
whole_file = whole_file.Replace('\n', '\r');
string[] lines = whole_file.Split(new char[] { '\r' },
StringSplitOptions.RemoveEmptyEntries);
// See how many rows and columns there are.
int num_rows = lines.Length;
int num_cols = lines[0].Split(';').Length;
if (num_cols != 2)
{
throw new Exception($"inserted file name from path: {filename} is not in correct format 2 columns separeted with semicolumn");
}
// Generate List for All name dates
List <NameDate> nameDates = new List <NameDate>();
int row = 0;
// Load the array.
try
{
for (row = 0; row < num_rows; row++)
{
string[] columns = lines[row].Split(';');
NameDate nameDate = new NameDate(columns, row);
nameDates.Add(nameDate);
}
}
catch
{
throw new Exception($"Data in row {row} is not correct. Please check the date is in correct format \"dd.MM\".");
}
return(nameDates);
}