public static Activity GetActivityFromString(string activity)
{
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
return(context.Activities.FirstOrDefault(c => c.Name == activity));
}
}
/// <summary>
/// Initializes a new instance of the MainViewModel class.
/// </summary>
public MainViewModel()
{
ChangeToMonth(DateTime.Now);
MessengerInstance.Register <DateTime>(this, "DayView", ChangeToDay);
MessengerInstance.Register <DateTime>(this, "MonthView", ChangeToMonth);
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
//Category category = new Category { Name = "Gaming" };
//context.Categories.Add(category);
//Activity activity = new Activity { Name = "Playing League", Category = category };
//context.Activities.Add(activity);
//TimeEntry timeEntry = new TimeEntry { Activity = activity, Comment = "Lost every f*****g game", Date = DateTime.Now, CreationDate = DateTime.Now, Duration = 2.25 };
//context.TimeEntries.Add(timeEntry);
//context.SaveChanges();
}
////if (IsInDesignMode)
////{
//// // Code runs in Blend --> create design time data.
////}
////else
////{
//// // Code runs "for real"
////}
}
public static void AddCategory(string name, IMessenger messenger)
{
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
context.Categories.Add(new Category {
Name = name
});
context.SaveChanges();
}
messenger.Send("Update");
}
public static void AddActivity(string categoryString, string name, IMessenger messenger)
{
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
Category category = context.Categories.FirstOrDefault(c => c.Name == categoryString);
category.Activities.Add(new Activity
{
Name = name
});
context.SaveChanges();
}
messenger.Send("Update");
}
public static ObservableCollection <string> GetAllCategories()
{
var allCategories = new ObservableCollection <string>();
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
foreach (var activiy in context.Categories.Select(r => r.Name).OrderBy(r => r))
{
allCategories.Add(activiy);
}
}
return(allCategories);
}
public static void AddEntry(string activityString, string comment, string duration, DateTime date, IMessenger messenger)
{
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
Activity activity = context.Activities.FirstOrDefault(c => c.Name == activityString);
activity.TimeEntries.Add(new TimeEntry
{
Comment = comment,
Duration = double.Parse(duration),
CreationDate = DateTime.Now,
Date = date
});
context.SaveChanges();
}
messenger.Send("Update");
}
public static ObservableCollection <EntryViewModel> GetTimeEntriesFromDate(DateTime date)
{
var tempEntries = new ObservableCollection <EntryViewModel>();
using (TimeTrackingDBEntities context = new TimeTrackingDBEntities())
{
var entriesFromDB = context.TimeEntries.Where(r => r.Date.Day == date.Day).ToList();
foreach (var entry in entriesFromDB)
{
tempEntries.Add(new EntryViewModel
{
Activity = entry.Activity.Name,
Duration = entry.Duration.ToString(),
Comment = entry.Comment
});
}
}
return(tempEntries);
}
