public void AddLog(Log log)
{
var timeLoggingContext = new TimeLoggingContext();
timeLoggingContext.Logs.Add(log);
timeLoggingContext.SaveChanges();
}
public static void SubmitTimeLog(TimeLogViewModel log)
{
var timeLoggingContext = new TimeLoggingContext();
var newEntry = new Log()
{
Billable = log.Billable,
Comment = log.Comment,
EndTime = log.EndTime,
StartTime = log.StartTime,
UserId = "doug"
};
timeLoggingContext.Logs.Add(newEntry);
timeLoggingContext.SaveChanges();
}
public static List <TimeLogViewModel> GetFiveLatestEntries()
{
var timeLoggingContext = new TimeLoggingContext();
var result = timeLoggingContext.Logs.Take(5).Select(l => new TimeLogViewModel()
{
UserId = l.UserId,
StartTime = l.StartTime,
EndTime = l.EndTime,
Comment = l.Comment,
Billable = l.Billable
});
return(result.ToList());
}
public List <Log> GetEntriesByDate(DateTime?dayInQuestion)
{
var day = DateTime.UtcNow;
if (dayInQuestion.HasValue)
{
day = dayInQuestion.Value;
}
var context = new TimeLoggingContext();
var result = context.Logs.Where((r =>
(r.StartTime.Day == day.Day) &&
(r.StartTime.Month == day.Month) &&
(r.StartTime.Year == day.Year)));
return(result.ToList());
}
public Log FindLog(int?id)
{
var timeLoggingContext = new TimeLoggingContext();
return(timeLoggingContext.Logs.Where(r => r.Id == id).SingleOrDefault <Log>());
}
