private void menuFileExport_Click(object sender, RoutedEventArgs e) { ExportToExcel <Entry, List <Entry> > exportToExcel = new ExportToExcel <Entry, List <Entry> >() { dataToPrint = queries.Entries(queries.User_AllEntries(user.UserID, queries.t_Timesheet_Prelim)) }; exportToExcel.GenerateReport(); }
public void RefreshDGHoursFromClassList() { dgHours.ItemsSource = null; try { itemsSourceEntries = queries.Entries(queries.User_AllEntries(user.UserID, queries.t_Timesheet_Prelim)); items = ( from E in itemsSourceEntries where E.date <= beforeDate select E).ToList <Entry>(); items.AddRange(( from E in itemsSourceEntries where E.date > beforeDate where (E.timesheet_code.Equals("H") || E.timesheet_code.Equals("PA") || E.timesheet_code.Equals("UA") ? true : E.timesheet_code.Equals("V")) select E).ToList <Entry>()); dgHours.ItemsSource = from E in items orderby E.date select E; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } }
public void RefreshDGHoursFromClassList() { string tTimesheetLimbo = queries.t_Timesheet_Limbo; if (cbxEmployee.SelectedItem != null) { int userID = ((User)cbxEmployee.SelectedItem).UserID; dgHours.ItemsSource = null; try { itemsSourceEntries = queries.Entries(queries.User_AllEntries(userID, tTimesheetLimbo)); dgHours.ItemsSource = from E in itemsSourceEntries orderby E.date where E.date <= beforeDate select E; } catch (Exception exception) { MessageBox.Show(exception.ToString()); } } }