/// <summary> /// more button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DateSumMoreButton_Click(object sender, RoutedEventArgs e) { if (SQLiteClass.ExecuteMoreSelectTableTaskTime(SQLiteClass.dbpath, DateCalc.StringToDate(textboxDateSum.Text, System.Globalization.CultureInfo.CurrentCulture))) { DateSumMoreButton.Visibility = Visibility.Visible; textDateSumStatusBar.Content = ""; } else { DateSumMoreButton.Visibility = Visibility.Collapsed; textDateSumStatusBar.Content = Properties.Resources.DD_Sum + SQLiteClass.SumTimeSpanDateSum.ToString(@"hh\:mm\:ss"); } }
/// <summary> /// date change button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonDateSumChange_Click(object sender, RoutedEventArgs e) { // Instantiate the dialog box DateSumDateWindow dlg = new DateSumDateWindow(); // Configure the dialog box dlg.Owner = this; dlg.WindowStartupLocation = WindowStartupLocation.CenterOwner; dlg.dateString = textboxDateSum.Text; // Open the dialog box modally if (dlg.ShowDialog() == true) { // due date window is closed textboxDateSum.Text = dlg.dateString; ExecuteFirstSelectTableTaskTime(DateCalc.StringToDate(textboxDateSum.Text, System.Globalization.CultureInfo.CurrentCulture)); } }
private void Name_Click(object sender, RoutedEventArgs e) { SQLiteClass.DateSumNameOrderByDirection = SQLiteClass.toggleDirection(SQLiteClass.DateSumNameOrderByDirection); SQLiteClass.DateSumSetOrderBy("name", SQLiteClass.DateSumNameOrderByDirection); ExecuteFirstSelectTableTaskTime(DateCalc.StringToDate(textboxDateSum.Text, System.Globalization.CultureInfo.CurrentCulture)); }
private void DurationDes_Click(object sender, RoutedEventArgs e) { SQLiteClass.DateSumNameOrderByDirection = "DESC"; SQLiteClass.DateSumSetOrderBy("duration", "DESC"); ExecuteFirstSelectTableTaskTime(DateCalc.StringToDate(textboxDateSum.Text, System.Globalization.CultureInfo.CurrentCulture)); }
private void DateSumDateWindow_Loaded(object sender, RoutedEventArgs e) { DateTime due = DateCalc.StringToDate(dateString, System.Globalization.CultureInfo.CurrentCulture); DateSumDateBox.SelectedDate = due; }