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 UserSessions()
{
B1SampleEntities entities = new B1SampleEntities();
DataAccessMgr daMgr = Global.GetDataAccessMgr(this.HttpContext);
var query = from a in entities.UserSessions
select new { a.AppCode, a.UserId };
DbCommand dbCmd = daMgr.BuildSelectDbCommand(query, null);
return(PartialView("_UserSessions", daMgr.ExecuteCollection <UserSession>(dbCmd, null)));
}
public ActionResult TestSequences2()
{
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, 10);
return(PartialView(Constants._Page_PagingMgrView, testSequenceMgr));
}
private void TestSequenceButton_Click(object sender, RoutedEventArgs e)
{
DataAccessMgr daMgr = new DataAccessMgr(ConfigurationManager.AppSettings["ConnectionKey"]);
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 };
MainGridControl.PagingMgr = new PagingMgr(daMgr, query, DataAccess.Constants.PageSize, 10);
MainGridControl.SetPage(PagingMgr.PagingDbCmdEnum.First);
}
public ActionResult UserEditForm(int userCode)
{
B1SampleEntities entities = new B1SampleEntities();
DataAccessMgr daMgr = Global.GetDataAccessMgr(this.HttpContext);
var query = from a in entities.UserMasters
where a.UserCode == userCode
select new { a.UserCode, a.UserId, a.FirstName };
DbCommand dbCmd = daMgr.BuildSelectDbCommand(query, null);
return(PartialView(Constants._Page_UserEdit, daMgr.ExecuteCollection <UserMaster>(dbCmd, null).First()));
}
//?? 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));
}
