public List <MenuAuthentication> GetMenuAuthentication(string userId)
{
List <MenuAuthentication> menuAuthenList = null;
MenuAuthentication menuAuthen;
try
{
ProcParam procPara = new ProcParam(2);
procPara.ProcedureName = "ADMINISTRATOR_PACK.GETMENUAUTHENTICATION";
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strUserId", userId);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
menuAuthenList = new List <MenuAuthentication>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
menuAuthen = new MenuAuthentication();
menuAuthen.ProgramType = OraDataReader.Instance.GetString("PROG_TYPE");
menuAuthen.ProgramTypeName = OraDataReader.Instance.GetString("PROG_TYPE_NAME");
menuAuthen.ProgramTypeImage = OraDataReader.Instance.GetString("PROG_TYPE_ICON");
menuAuthen.ProgramID = OraDataReader.Instance.GetString("PROG_ID");
menuAuthen.ProgramKey = OraDataReader.Instance.GetString("PROG_KEY");
menuAuthen.ProgramName = OraDataReader.Instance.GetString("PROG_NAME");
menuAuthen.IconImage = OraDataReader.Instance.GetString("ICON");
menuAuthenList.Add(menuAuthen);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
menuAuthenList = null;
}
return(menuAuthenList);
}
public List <MenuAuthentication> GetMenuAuthentication(int userId)
{
List <MenuAuthentication> menuAuthenList = null;
MenuAuthentication menuAuthen;
try
{
SQLiteParam param = new SQLiteParam(1)
{
CommandText = StoreProcedure.Instance.GetScript("GetMenuAuthentication")
};
param.ParamInt32(0, "@USER_ID", userId);
SQLiteReader.Instance.SLReader = GlobalSqliteDB.Instance.DataAc.ExecuteDataReader(param);
if (SQLiteReader.Instance.HasRows)
{
menuAuthenList = new List <MenuAuthentication>();
while (SQLiteReader.Instance.SLReader.Read())
{
menuAuthen = new MenuAuthentication();
menuAuthen.PROG_TYPE_ID = SQLiteReader.Instance.GetInteger("PROG_TYPE_ID");
menuAuthen.PROG_TYPE_NAME = SQLiteReader.Instance.GetString("PROG_TYPE_NAME");
menuAuthen.PG_ICON = SQLiteReader.Instance.GetString("PG_ICON");
menuAuthen.PROG_TYPE_RESOURCE = SQLiteReader.Instance.GetString("PROG_TYPE_RESOURCE");
menuAuthen.PROG_ID = SQLiteReader.Instance.GetInteger("PROG_ID");
menuAuthen.PROG_NAME = SQLiteReader.Instance.GetString("PROG_NAME");
menuAuthen.ICON = SQLiteReader.Instance.GetString("ICON");
menuAuthen.PROG_KEY = SQLiteReader.Instance.GetString("PROG_KEY");
menuAuthen.PROG_RESOURCE = SQLiteReader.Instance.GetString("PROG_RESOURCE");
menuAuthenList.Add(menuAuthen);
}
}
//Always call Close when done reading.
SQLiteReader.Instance.Close();
}
catch (Exception ex)
{
menuAuthenList = null;
}
return(menuAuthenList);
}
