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()); } }
private List <Entry> GetEntries(List <User> Users, List <string> Tables) { List <Entry> entries = new List <Entry>(); foreach (string table in Tables) { List <string> strs = new List <string>() { table }; foreach (Entry entry in queries.Entries(CreateListQString(strs, Users))) { entries.Add(entry); } } return(entries); }
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()); } } }