public IEnumerable <Old> GetOldItems()
{
try
{
//Run a raw sql query, considering that the entity already exists. This saves me from having to migrate data and export another bacpac file
return(this._contentMngr.RawSqlQuery <Old>(QueryConstants.GetOldItemsQuery(), (oldItem) => MapOldItemFromSql(oldItem)));
}
catch (Exception ex)
{
//Add some logging here...
throw ex;
}
}
internal static string GetBranchesQuery(DateFilter dateFilter)
{
if (dateFilter.FilterType == DateFilter.Type.AllTime)
{
return(QueryConstants.BranchesBeginningQuery);
}
string whereClause = QueryConstants.GetDateWhereClause(
dateFilter.GetFilterDate(DateTime.UtcNow));
return(string.Format("{0} {1}",
QueryConstants.BranchesBeginningQuery,
whereClause));
}
