public OutGoalExecutive GetGoalExecutive(string executiveID)
{
OutGoalExecutive data = new OutGoalExecutive();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetGoalExecutive(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetGoalExecutive", ex, "");
}
return(data);
}
public OutGoalExecutive GetGoalExecutive(string executiveID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutGoalExecutive response = new OutGoalExecutive();
var ora = new OracleServer(connectionString);
try
{
var po_executiveID = new OracleParameter("fa_cedula_asesor", OracleDbType.Varchar2, executiveID, ParameterDirection.Input);
ora.AddParameter(po_executiveID);
var po_goalValue = new OracleParameter("fa_META_VLR", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_goalValue);
var po_complianceValue = new OracleParameter("fa_CUMPLIMIENTO_VLR", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_complianceValue);
var po_compliancePercentage = new OracleParameter("fa_CUMPLIMIENTO_PORC", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_compliancePercentage);
var po_goalNewValue = new OracleParameter("fa_META_VLR_NUEVOS", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_goalNewValue);
var po_complianceNewValue = new OracleParameter("fa_CUMPLIMIENTO_VLR_NUEVOS", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_complianceNewValue);
var po_complianceNewPercentage = new OracleParameter("fa_CUMPLIMIENTO_PORC_NUEVOS", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_complianceNewPercentage);
var po_goalRenovatedValue = new OracleParameter("fa_META_VLR_RENOVADO", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_goalRenovatedValue);
var po_complianceRenovatedValue = new OracleParameter("fa_CUMPLIMIENTO_VLR_RENOVADO", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_complianceRenovatedValue);
var po_complianceRenovatedPercentage = new OracleParameter("fa_CUMPLIMIENTO_PORC_RENOVADO", OracleDbType.Double, ParameterDirection.Output);
ora.AddParameter(po_complianceRenovatedPercentage);
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_META_ASESOR");
response.goalExecutive = new GoalExecutive();
response.goalExecutive.goalValue = double.Parse(ora.GetParameter("fa_META_VLR").ToString());
response.goalExecutive.complianceValue = double.Parse(ora.GetParameter("fa_CUMPLIMIENTO_VLR").ToString());
response.goalExecutive.compliancePercentage = double.Parse(ora.GetParameter("fa_CUMPLIMIENTO_PORC").ToString());
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetGoalExecutive", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
