public IPager <Contact> FindAllView(IPager <Contact> pager)
{
string storedProcedure = String.Empty;
//CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new ContactMapToObjectView(logger);
storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == FINDALL_PAGEDVIEWPROC);
if (storedProcedure == null)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = String.Format(FINDALLVIEWPAGER_STMT, pager.PageSize, pager.PageSize * pager.PageNbr);
pager.Entities = base.FindAll();
}
else
{
SqlCommandType = Constants.DBCommandType.SPROC;
CMDText = storedProcedure;
pager.Entities = base.FindAllPaged(pager.PageSize, pager.PageSize * pager.PageNbr);
}
CMDText = FINDALLCOUNT_STMT;
pager.RowCount = base.FindAllCount();
return(pager);
}
public Contact FindViewByPK(IPrimaryKey pk)
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = FINDBYPKVIEW_STMT;
MapToObject = new ContactMapToObjectView(logger);
return(base.FindByPK(pk));
}
public async Task <ICollection <Contact> > FindAllView()
{
CMDText = FINDALLVIEW_STMT;
CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new ContactMapToObjectView(logger);
return(await base.FindAll());
}
public ICollection <Contact> FindAllView()
{
SqlCommandType = Constants.DBCommandType.SQL;
CMDText = FINDALLVIEW_STMT;
//CMDText += ORDERBY_STMT + OrderBy;
MapToObject = new ContactMapToObjectView(logger);
return(base.FindAll());
}
public async Task <Contact> FindViewByPK(IPrimaryKey pk)
{
CMDText = FINDBYPKVIEW_STMT;
MapToObject = new ContactMapToObjectView(logger);
return(await base.FindByPK(pk));
}
