public User LoginUser(string username, string password) { User dto = null; try { OracleDao dao = new OracleDao(Configs.ConnectionString); OracleCommand command = dao.GetSprocCommand("idemia.SP_LoginUser"); command.Parameters.Add(dao.CreateParameter("pUserName", username)); command.Parameters.Add(dao.CreateParameter("pPassword", password)); command.Parameters.Add(dao.CreateOutputParameter("RESULTSET", OracleDbType.RefCursor)); dto = dao.GetCBOSingle <User>(command); }//end try catch (Exception ex) { } return(dto); }
public Request GetNextRequest() { Request dto = new Request(); try { OracleDao dao = new OracleDao(Configs.ConnectionString); OracleCommand command = dao.GetSprocCommand("idemia.SP_GETNextRequest"); command.Parameters.Add(dao.CreateOutputParameter("RESULTSET", OracleDbType.RefCursor)); if (command.Connection.State == System.Data.ConnectionState.Closed) { command.Connection.Open(); } dto = dao.GetCBOSingle <Request>(command); } //end try catch (Exception ex) { } return(dto); }