public string TestSequences()
{
DataAccessMgr daMgr = Global.GetDataAccessMgr(this.HttpContext);
B1SampleEntities entities = new B1SampleEntities();
var query = from a in entities.TestSequences
orderby new { a.AppSequenceName, a.AppSequenceId }
select new { a.AppSequenceId, a.AppSequenceName, a.DbSequenceId };
PagingMgr testSequenceMgr = new PagingMgr(daMgr, query, DataAccess.Constants.PageSize, 20);
return(testSequenceMgr.ToHtmlString(this));
}
//?? public ActionResult AppSessions()
public string AppSessions()
{
B1SampleEntities entities = new B1SampleEntities();
DataAccessMgr daMgr = Global.GetDataAccessMgr(this.HttpContext);
var query = from a in entities.AppSessions
orderby new { a.AppCode, a.MultipleSessionCode }
select new { a.AppCode, a.AppId, a.MultipleSessionCode };
PagingMgr testSequenceMgr = new PagingMgr(daMgr, query, DataAccess.Constants.PageSize, 20);
return(testSequenceMgr.ToHtmlString <AppSession>(PagingMgr.PagingDbCmdEnum.First).ToHtmlString());
//DbCommand dbCmd = daMgr.BuildSelectDbCommand(query, null);
//return PartialView("_AppSessions", daMgr.ExecuteCollection<AppSession>(dbCmd, null));
}