public OutProductivity GetProductivity(string executiveID)
{
OutProductivity data = new OutProductivity();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetProductivity(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetProductivity", ex, "");
}
return(data);
}
public OutProductivity GetProductivity(string executiveID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutProductivity response = new OutProductivity();
var ora = new OracleServer(connectionString);
Productivity productivity;
List <Productivity> list = new List <Productivity>();
string command = string.Empty;
try
{
command = "SELECT FIGURA,NRO_CREDITOS,MONTO_CREDITOS,PROMEDIO FROM BBS_LIQCOM_V_PROD_JEFE WHERE ";
command = command + string.Format(" CEDULA_ASESOR = '{0}' ", executiveID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
productivity = new Productivity();
productivity.Figure = DBNull.Value.Equals(rdr["FIGURA"]) ? string.Empty : rdr["FIGURA"].ToString();
productivity.LoanCount = DBNull.Value.Equals(rdr["NRO_CREDITOS"]) ? 0 : double.Parse(rdr["NRO_CREDITOS"].ToString());
productivity.LoanAmount = DBNull.Value.Equals(rdr["MONTO_CREDITOS"]) ? 0 : double.Parse(rdr["MONTO_CREDITOS"].ToString());
productivity.Average = DBNull.Value.Equals(rdr["PROMEDIO"]) ? 0 : double.Parse(rdr["PROMEDIO"].ToString());
list.Add(productivity);
}
rdr.Close();
response.lstProductivity = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetProductivity", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
