public override async Task <ICollection <Code> > FindAll()
{
CMDText = FINDALL_STMT;
CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new CodeMapToObject(logger);
return(await base.FindAll());
}
public async Task <ICollection <Code> > FindAllByCategory(int category)
{
IList <SqlParameter> parms = new List <SqlParameter>();
CMDText = FINDALLBYCATEGORY_STMT;
CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new CodeMapToObject(logger);
parms.Add(new SqlParameter("@cat", category));
return(await base.FindAll(parms));
}
public async Task <IPager <Code> > FindAll(IPager <Code> pager)
{
string storedProcedure = String.Empty;
MapToObject = new CodeMapToObject(logger);
storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == FINDALL_PAGEDPROC);
if (storedProcedure == null)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = String.Format(FINDALLPAGER_STMT, pager.PageSize * pager.PageNbr, pager.PageSize);
pager.Entities = await base.FindAll();
}
else
{
SqlCommandType = Constants.DBCommandType.SPROC;
CMDText = storedProcedure;
pager.Entities = await base.FindAllPaged(pager.PageSize *pager.PageNbr, pager.PageSize);
}
CMDText = FINDALLCOUNT_STMT;
pager.RowCount = await base.FindAllCount();
return(pager);
}
public override async Task <Code> FindByPK(IPrimaryKey pk)
{
CMDText = FINDBYPK_STMT;
MapToObject = new CodeMapToObject(logger);
return(await base.FindByPK(pk));
}
