static void Main(string[] args)
{
var csvData = ReadFile("sample.csv");
using (var context = new MyContext())
{
foreach (var row in csvData)
{
var item = new TimeLogItem()
{
Date = row.Date,
Minutes = row.Minutes,
Week = row.Week,
Year = row.Year,
ExternalId = row.Id,
Project = row.Project,
};
context.TimeLogItems.Add(item);
}
context.SaveChanges();
}
Console.WriteLine("press enter to exit");
Console.ReadLine();
}
public void SaveTime()
{
var newTimeLogItem = new TimeLogItem(
CurrentTimer.StartTime,
CurrentTimer.EndTime,
CurrentTimer.Title,
CurrentTimer.CategorySystemId);
_logger.LogInformation($"Adding new time log: {JsonSerializer.Serialize(newTimeLogItem)}");
_timeLogService.Add(newTimeLogItem);
}
public TimeLogService(ILogger <TimeLogService> logger)
{
_logger = logger;
TimeLog = new List <TimeLogItem>();
for (int i = 0; i < 12; i++)
{
var t = (int)i % 5;
var date = DateTime.Now;
var time = new TimeLogItem(date.AddDays(-t), date.AddDays(-t).AddHours(i), "some task");
_logger.LogInformation($"Adding timelog {System.Text.Json.JsonSerializer.Serialize(time)}");
TimeLog.Add(time);
}
}
public void Add(TimeLogItem timeLogItem)
{
TimeLog.Add(timeLogItem);
}
