public BillingPeriodAccountsJoinCollection FetchByPeriodIDWithoutCityPerdiem(Int32 periodid)
{
var billingCityRateController = new BillingCityRateController();
var billingCityCol = billingCityRateController.FetchAllActive();
var billingPeriodsCol = new BillingPeriodAccountsJoinCollection().Where(BillingPeriodAccountsJoin.Columns.Periodid, periodid).OrderByAsc(BillingPeriodAccountsJoin.Columns.Accountname).Load();
var billingCityPeriodAccountIds = new List<int>();
var retBillingPeriodAccountCol = new BillingPeriodAccountsJoinCollection();
billingCityPeriodAccountIds.AddRange(billingCityCol.Select(billingCity => billingCity.Periodaccountid));
foreach (var billingPeriod in billingPeriodsCol)
{
if(!billingCityPeriodAccountIds.Contains(billingPeriod.Id))
retBillingPeriodAccountCol.Add(billingPeriod);
}
return retBillingPeriodAccountCol;
}
public BillingPeriodAccountsJoinCollection FetchByPeriodIDWithoutCityPerdiem(Int32 periodid)
{
var billingCityRateController = new BillingCityRateController();
var billingCityCol = billingCityRateController.FetchAllActive();
var billingPeriodsCol = new BillingPeriodAccountsJoinCollection().Where(BillingPeriodAccountsJoin.Columns.Periodid, periodid).OrderByAsc(BillingPeriodAccountsJoin.Columns.Accountname).Load();
var billingCityPeriodAccountIds = new List <int>();
var retBillingPeriodAccountCol = new BillingPeriodAccountsJoinCollection();
billingCityPeriodAccountIds.AddRange(billingCityCol.Select(billingCity => billingCity.Periodaccountid));
foreach (var billingPeriod in billingPeriodsCol)
{
if (!billingCityPeriodAccountIds.Contains(billingPeriod.Id))
{
retBillingPeriodAccountCol.Add(billingPeriod);
}
}
return(retBillingPeriodAccountCol);
}
