public ExpenseEntryCollection FetchByQuery(Query qry)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public ExpenseEntryCollection FetchAll()
{
ExpenseEntryCollection coll = new ExpenseEntryCollection();
Query qry = new Query(ExpenseEntry.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public Double GetTotalByBillingPeriodAccountID(Int32 BillingPeriodAccountID)
{
Double total = 0;
ExpenseEntryCollection col = this.FetchAll().Where(ExpenseEntry.Columns.IsDeleted, false);
var allTimesheets = new TimesheetController().FetchAll();
foreach (ExpenseEntry expenseentry in col)
{
var timesheet = allTimesheets.FirstOrDefault(x => x.Id == expenseentry.Timesheetid);
if (timesheet != null && timesheet.Periodaccountid == BillingPeriodAccountID &&
expenseentry.IsDeleted == false)
total += expenseentry.Cost;
}
return total;
}
public ExpenseEntryCollection FetchByTimesheetID(int timesheetid)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection().Where(ExpenseEntry.Columns.Timesheetid, timesheetid).OrderByAsc(ExpenseEntry.Columns.Expensedate).Load();
return coll;
}
public ExpenseEntryCollection FetchByID(object Id)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection().Where("id", Id).Load();
return(coll);
}