public OutAccumulatedClarifications GetAccumulatedClarifications(string executiveID)
{
OutAccumulatedClarifications data = new OutAccumulatedClarifications();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetAccumulatedClarifications(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetAccumulatedClarifications", ex, "");
}
return(data);
}
public OutAccumulatedClarifications GetAccumulatedClarifications(string executiveID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutAccumulatedClarifications response = new OutAccumulatedClarifications();
var ora = new OracleServer(connectionString);
AccumulatedClarifications accumulated;
List <AccumulatedClarifications> list = new List <AccumulatedClarifications>();
string command = string.Empty;
try
{
command = "SELECT MES,NUMERO_ACLARACIONES,NUMERO_RESPONDIDAS,NUMERO_PENDIENTES,PORCENTAJE_RESPONDIDAS,PORCENTAJE_PENDIENTES ";
command = command + string.Format(" FROM BBS_LIQCOM_V_PQR_RESUM WHERE BBS_LIQCOM_V_PQR_RESUM.CODIGO_ASESOR = '{0}' ", executiveID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
accumulated = new AccumulatedClarifications();
accumulated.month = DBNull.Value.Equals(rdr["MES"]) ? string.Empty : rdr["MES"].ToString();
accumulated.total = DBNull.Value.Equals(rdr["NUMERO_ACLARACIONES"]) ? 0 : double.Parse(rdr["NUMERO_ACLARACIONES"].ToString());
accumulated.answered = DBNull.Value.Equals(rdr["NUMERO_RESPONDIDAS"]) ? 0 : double.Parse(rdr["NUMERO_RESPONDIDAS"].ToString());
accumulated.pending = DBNull.Value.Equals(rdr["NUMERO_PENDIENTES"]) ? 0 : double.Parse(rdr["NUMERO_PENDIENTES"].ToString());
accumulated.percentageAnswered = DBNull.Value.Equals(rdr["PORCENTAJE_RESPONDIDAS"]) ? 0 : double.Parse(rdr["PORCENTAJE_RESPONDIDAS"].ToString());
accumulated.percentagePending = DBNull.Value.Equals(rdr["PORCENTAJE_PENDIENTES"]) ? 0 : double.Parse(rdr["PORCENTAJE_PENDIENTES"].ToString());
list.Add(accumulated);
}
rdr.Close();
response.lstAccumulatedClarifications = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetAccumulatedClarifications", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
