private void ButtonStopClick(object sender, System.Windows.RoutedEventArgs e)
{
try
{
timerStopWatch.Stop();
dispatcherTimer.Stop();
MessageBoxResult messResuly = MessageBox.Show("Are you want to save data ?", "Time Tracker", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messResuly.Equals(MessageBoxResult.Yes))
{
var sqltoLinqDataContract = new sqltoLinqDataDataContext();
TimeTrickTable AddTime = new TimeTrickTable
{
//Autoinc = 1,
EntryDate = DateTime.Today,
ETime = TimeSpan.Parse(this.TextBlockTimer.Text)
};
sqltoLinqDataContract.TimeTrickTables.InsertOnSubmit(AddTime);
sqltoLinqDataContract.SubmitChanges();
}
}
catch (Exception error)
{
MessageBox.Show(error.Message, "Time Tracker", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void ButtonSearchbyDateClick(object sender, System.Windows.RoutedEventArgs e)
{
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from timedb in sqlDataContract.TimeTrickTables where timedb.EntryDate ==Convert.ToDateTime(DatePickerTimer.Text) select timedb;
DataGridReportMaker.ItemsSource = reportmaker;
sqlDataContract.Dispose();
}
private void ButtonStopClick(object sender, System.Windows.RoutedEventArgs e)
{
try
{
timerStopWatch.Stop();
dispatcherTimer.Stop();
MessageBoxResult messResuly = MessageBox.Show("Are you want to save data ?", "Time Tracker", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messResuly.Equals(MessageBoxResult.Yes))
{
var sqltoLinqDataContract = new sqltoLinqDataDataContext();
TimeTrickTable AddTime = new TimeTrickTable
{
//Autoinc = 1,
EntryDate = DateTime.Today,
ETime = TimeSpan.Parse(this.TextBlockTimer.Text)
};
sqltoLinqDataContract.TimeTrickTables.InsertOnSubmit(AddTime);
sqltoLinqDataContract.SubmitChanges();
}
}
catch(Exception error)
{
MessageBox.Show(error.Message, "Time Tracker", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void ButtonSearchbyMonthClick(object sender, System.Windows.RoutedEventArgs e)
{
var sqlDataContract = new sqltoLinqDataDataContext();
var monthely = from u in sqlDataContract.TimeTrickTables group u by u.EntryDate.Value.Month into g select new { EntryDate = g.Key, ETime = new TimeSpan(g.Sum(r => r.ETime.Value.Ticks)) };
DataGridReportMaker.ItemsSource = monthely;
sqlDataContract.Dispose();
}
private void ButtonSearchbyDateClick(object sender, System.Windows.RoutedEventArgs e)
{
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from timedb in sqlDataContract.TimeTrickTables where timedb.EntryDate == Convert.ToDateTime(DatePickerTimer.Text) select timedb;
DataGridReportMaker.ItemsSource = reportmaker;
sqlDataContract.Dispose();
}
private void ButtonReportByMonthClick(object sender, System.Windows.RoutedEventArgs e)
{
this.ButtonReport.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from u in sqlDataContract.TimeTrickTables group u by u.EntryDate.Value.Month into g select new { EntryDate = g.Key, ETime = new TimeSpan(g.Sum(r => r.ETime.Value.Ticks)) };
TimerDataSet reportDataset = new TimerDataSet();
foreach (var item in reportmaker)
{
reportDataset.TimerDataTable.Rows.Add(item.EntryDate, item.ETime);
}
WindowReportViewer reportVew = new WindowReportViewer();
CrystalReport1 cyReport = new CrystalReport1();
cyReport.SetDataSource(reportDataset);
reportVew.ReportViewerView.ViewerCore.ReportSource = cyReport;
reportVew.Show();
sqlDataContract.Dispose();
reportDataset.Dispose();
this.ButtonReport.IsEnabled = true;
Mouse.OverrideCursor = null;
}
private void ButtonReportByDateClick(object sender, System.Windows.RoutedEventArgs e)
{
this.ButtonReport.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from timedb in sqlDataContract.TimeTrickTables where timedb.EntryDate == Convert.ToDateTime(DatePickerTimer.Text) select timedb;
TimerDataSet reportDataset = new TimerDataSet();
foreach (var item in reportmaker)
{
reportDataset.TimerDataTable.Rows.Add(item.EntryDate, item.ETime);
}
WindowReportViewer reportVew = new WindowReportViewer();
CrystalReport1 cyReport = new CrystalReport1();
cyReport.SetDataSource(reportDataset);
reportVew.ReportViewerView.ViewerCore.ReportSource=cyReport;
reportVew.Show();
sqlDataContract.Dispose();
reportDataset.Dispose();
this.ButtonReport.IsEnabled = true;
Mouse.OverrideCursor = null;
}
private void ButtonReportByMonthClick(object sender, System.Windows.RoutedEventArgs e)
{
this.ButtonReport.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from u in sqlDataContract.TimeTrickTables group u by u.EntryDate.Value.Month into g select new { EntryDate = g.Key, ETime = new TimeSpan(g.Sum(r => r.ETime.Value.Ticks)) };
TimerDataSet reportDataset = new TimerDataSet();
foreach (var item in reportmaker)
{
reportDataset.TimerDataTable.Rows.Add(item.EntryDate, item.ETime);
}
WindowReportViewer reportVew = new WindowReportViewer();
CrystalReport1 cyReport = new CrystalReport1();
cyReport.SetDataSource(reportDataset);
reportVew.ReportViewerView.ViewerCore.ReportSource = cyReport;
reportVew.Show();
sqlDataContract.Dispose();
reportDataset.Dispose();
this.ButtonReport.IsEnabled = true;
Mouse.OverrideCursor = null;
}
private void ButtonReportByDateClick(object sender, System.Windows.RoutedEventArgs e)
{
this.ButtonReport.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
var sqlDataContract = new sqltoLinqDataDataContext();
var reportmaker = from timedb in sqlDataContract.TimeTrickTables where timedb.EntryDate == Convert.ToDateTime(DatePickerTimer.Text) select timedb;
TimerDataSet reportDataset = new TimerDataSet();
foreach (var item in reportmaker)
{
reportDataset.TimerDataTable.Rows.Add(item.EntryDate, item.ETime);
}
WindowReportViewer reportVew = new WindowReportViewer();
CrystalReport1 cyReport = new CrystalReport1();
cyReport.SetDataSource(reportDataset);
reportVew.ReportViewerView.ViewerCore.ReportSource = cyReport;
reportVew.Show();
sqlDataContract.Dispose();
reportDataset.Dispose();
this.ButtonReport.IsEnabled = true;
Mouse.OverrideCursor = null;
}
private void ButtonSearchbyMonthClick(object sender, System.Windows.RoutedEventArgs e)
{
var sqlDataContract = new sqltoLinqDataDataContext();
var monthely = from u in sqlDataContract.TimeTrickTables group u by u.EntryDate.Value.Month into g select new { EntryDate = g.Key, ETime = new TimeSpan(g.Sum(r => r.ETime.Value.Ticks)) };
DataGridReportMaker.ItemsSource = monthely;
sqlDataContract.Dispose();
}
