private bool IsTimeNotCoverAnother(RoutineViewModel routine)
{
var day = routine.Days[0];
if (routine.Times != null)
{
TimeOfActivity routineCovered = routine.Times
.OrderBy(r => r.End)
.ToList()
.FirstOrDefault(r =>
(r.Day == day) &&
((r.End.TotalMinutes > routine.Time.End.TotalMinutes &&
r.Start.TotalMinutes < routine.Time.Start.TotalMinutes) ||
(r.Start.TotalMinutes > routine.Time.Start.TotalMinutes &&
r.Start.TotalMinutes < routine.Time.End.TotalMinutes) ||
(r.End.TotalMinutes > routine.Time.Start.TotalMinutes &&
r.End.TotalMinutes < routine.Time.End.TotalMinutes) ||
(r.Start.TotalMinutes >= routine.Time.Start.TotalMinutes &&
r.End.TotalMinutes <= routine.Time.End.TotalMinutes)));
if (routineCovered == null)
{
return(true);
}
else
{
return(false);
}
}
return(true);
}
public ActionResult DeleteRoutine(string id)
{
var idInt = Int32.Parse(id);
TimeOfActivity time = _context.TimeOfActivity.Single(t => t.Id == idInt);
_context.TimeOfActivity.Remove(time);
_context.SaveChanges();
return(RedirectToAction("EditRoutine"));
}
public int LogActivity(DescriptionOfActivity activity, CalendarDate date, TimeOfActivity time)
{
var user = _persistenceData.ActiveUser;
var query = "INSERT INTO activity_log " +
"( user_id, calendar_day, calendar_date, day_name, category_description, activity_description, time_spent_on_activity ) " +
$"VALUES ({user.Id}, {date.CalendarDay()}, {date.Id}, {date.Weekday()}, {activity.GetCategoryId()}, {activity.Id}, {time.Id})";
System.Diagnostics.Debug.WriteLine($"query: {query}");
return(DbHelper.Insert(query));
}
