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); }