public OutNextCategory GetNextCategory(string executiveID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
var ora = new OracleServer(connectionString);
OutNextCategory response = new OutNextCategory();
try
{
var pi_documentID = new OracleParameter("fa_codigo_asesor", OracleDbType.Varchar2, executiveID, ParameterDirection.Input);
ora.AddParameter(pi_documentID);
var pi_amount = new OracleParameter("fa_MONTO_COLOCAR", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(pi_amount);
var pi_categoryCode = new OracleParameter("fa_CODIGO_CATEGORIA", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(pi_categoryCode);
var pi_categoryName = new OracleParameter("fa_NOMBRE_CATEGORIA", OracleDbType.Varchar2, ParameterDirection.Output);
pi_categoryName.Size = 100;
ora.AddParameter(pi_categoryName);
var pi_schemeCode = new OracleParameter("fa_codigo_esquema", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(pi_schemeCode);
var pi_subscheme = new OracleParameter("fa_codigo_subesquema", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(pi_subscheme);
var po_ErrorCode = new OracleParameter("fa_Error", OracleDbType.Double, ParameterDirection.Output);
var po_ErrorMessage = new OracleParameter("fa_Descripcion_Error", OracleDbType.Varchar2, ParameterDirection.Output);
po_ErrorMessage.Size = 100;
ora.AddParameter(po_ErrorCode);
ora.AddParameter(po_ErrorMessage);
ora.ExecuteProcedureNonQuery("BBS_LIQCOM2_F_BUSCA_SIG_CAT");
response.msg = new Response();
response.amount = double.Parse(ora.GetParameter("fa_MONTO_COLOCAR").ToString());
response.categoryName = ora.GetParameter("fa_NOMBRE_CATEGORIA").ToString();
response.msg.errorCode = ora.GetParameter("fa_Error").ToString();
response.msg.errorMessage = ora.GetParameter("fa_Descripcion_Error").ToString();
ora.Dispose();
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetNextCategory", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public OutNextCategory GetNextCategory(string executiveID)
{
OutNextCategory data = new OutNextCategory();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetNextCategory(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetNextCategory", ex, "");
}
return(data);
}
