public void RefreshTimeSheetList() { var t = Calendar.DisplayDate; Console.WriteLine("{0}: {1}", t.GetType(), t.ToString()); using (WorkTimeTrackerContext context = new WorkTimeTrackerContext()) { TicketsDataGrid.ItemsSource = context.TimeSheets.ToList(); } return(true); }
private void RefreshCurrentTimer() { DateTime startWorkTime = DateTime.Now; JetEntityFrameworkProvider.JetConnection.ShowSqlStatements = true; while (isTimerStarted) { DateTime currentDateTime = DateTime.Now; TimeSpan diff = currentDateTime - startWorkTime; Updater uiUpdater = new Updater(CurrentTimer); StringBuilder difference = new StringBuilder(); if (diff.Days > 0) { difference.Append(diff.Days.ToString()).Append("d "); } if (diff.Hours > 0) { difference.Append(diff.Hours.ToString()).Append("h "); } if (diff.Minutes > 0) { difference.Append(diff.Minutes.ToString()).Append("m "); } if (diff.Seconds > 0) { difference.Append(diff.Seconds.ToString()).Append("s "); } Dispatcher.BeginInvoke(DispatcherPriority.Send, uiUpdater, difference.ToString()); Thread.Sleep(1000); } using (var context = new WorkTimeTrackerContext()) { context.TimeSheets.Add(new TimeSheet() { Start = startWorkTime, Finish = DateTime.Now, Ticket = null }); context.SaveChanges(); } }