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