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());
}
}
}
