public override async Task <State> FindByPK(IPrimaryKey pk)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = FINDBYPK_STMT;
MapToObject = new StateMapToObject(logger);
return(await base.FindByPK(pk));
}
public override async Task <ICollection <State> > FindAll()
{
CMDText = FINDALL_STMT;
CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new StateMapToObject(logger);
return(await base.FindAll());
}
public override async Task <ICollection <State> > FindAll()
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = FINDALL_STMT;
CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new StateMapToObject(logger);
return(await base.FindAll());
}
public IPager <State> FindAll(IPager <State> pager)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = String.Format(FINDALLPAGER_STMT, pager.PageSize, pager.PageSize * pager.PageNbr);
//CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new StateMapToObject(logger);
pager.Entities = base.FindAll();
CMDText = FINDALLCOUNT_STMT;
pager.RowCount = base.FindAllCount();
return(pager);
}
public async Task <IPager <State> > FindAll(IPager <State> pager)
{
CMDText = String.Format(FINDALLPAGER_STMT, pager.PageSize * pager.PageNbr, pager.PageSize);
//CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new StateMapToObject(logger);
pager.Entities = await base.FindAll();
CMDText = FINDALLCOUNT_STMT;
pager.RowCount = await base.FindAllCount();
return(pager);
}
public override async Task <State> FindByPK(IPrimaryKey pk)
{
CMDText = FINDBYPK_STMT;
MapToObject = new StateMapToObject(logger);
return(await base.FindByPK(pk));
}
