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