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); }