public OutGoalSupervisor GetGoalSupervisor(string executiveID)
{
OutGoalSupervisor data = new OutGoalSupervisor();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetGoalSupervisor(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetGoalSupervisor", ex, "");
}
return(data);
}
public OutGoalSupervisor GetGoalSupervisor(string supervisorID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutGoalSupervisor response = new OutGoalSupervisor();
var ora = new OracleServer(connectionString);
try
{
var po_executiveID = new OracleParameter("fa_cedula_asesor", OracleDbType.Varchar2, supervisorID, 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_JEFE");
response.goalSupervisor = new GoalSupervisor();
response.goalSupervisor.goalValue = double.Parse(ora.GetParameter("fa_META_VLR").ToString());
response.goalSupervisor.complianceValue = double.Parse(ora.GetParameter("fa_CUMPLIMIENTO_VLR").ToString());
response.goalSupervisor.compliancePercentage = double.Parse(ora.GetParameter("fa_CUMPLIMIENTO_PORC").ToString());
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetGoalSupervisor", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
