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); }