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