public OutLoanResume GetLoanResume(double loanNumber) { var response = new OutLoanResume(); try { PqrDAO dao = new PqrDAO(); response = dao.GetLoanResume(loanNumber); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "ManagerPQR", "GetLoanResume", ex, ""); } return(response); }
public OutLoanResume GetLoanResume(double loanNumber) { string connectionString = DataBaseHelper.GetConnectionString("DLG"); OutLoanResume response = new OutLoanResume(); var ora = new OracleServer(connectionString); string command = string.Empty; try { command = "SELECT NUMERO_CREDITO, FECHA_INICIO_CREDITO, MONTO, VALOR_DESEMBOSO, CODIGO_ASESOR," + " CODIGO_SUCURSAL, NOMBRE_CODIGO_SUCURSAL, CEDULA_ASESOR FROM BBS_LIQCOM_V_CREDITOSMX "; command = command + string.Format(" WHERE NUMERO_CREDITO = {0} ", loanNumber.ToString()); var rdr = ora.ExecuteCommand(command); while (rdr.Read()) { response.loanNumber = DBNull.Value.Equals(rdr["NUMERO_CREDITO"]) ? 0 : double.Parse(rdr["NUMERO_CREDITO"].ToString()); response.startDate = DBNull.Value.Equals(rdr["FECHA_INICIO_CREDITO"]) ? DateTime.Today.ToString("dd/MM/yyyy") : DateTime.Parse(rdr["FECHA_INICIO_CREDITO"].ToString()).ToString("dd/MM/yyyy"); response.amount = DBNull.Value.Equals(rdr["MONTO"]) ? 0 : double.Parse(rdr["MONTO"].ToString()); response.disbursement = DBNull.Value.Equals(rdr["VALOR_DESEMBOSO"]) ? 0 : double.Parse(rdr["VALOR_DESEMBOSO"].ToString()); response.executiveCode = DBNull.Value.Equals(rdr["CODIGO_ASESOR"]) ? 0 : double.Parse(rdr["CODIGO_ASESOR"].ToString()); response.branchCode = DBNull.Value.Equals(rdr["CODIGO_SUCURSAL"]) ? 0 : double.Parse(rdr["CODIGO_SUCURSAL"].ToString()); response.branchName = DBNull.Value.Equals(rdr["NOMBRE_CODIGO_SUCURSAL"]) ? string.Empty : rdr["NOMBRE_CODIGO_SUCURSAL"].ToString(); response.documentID = DBNull.Value.Equals(rdr["CEDULA_ASESOR"]) ? string.Empty : rdr["CEDULA_ASESOR"].ToString(); } rdr.Close(); response.msg = new Response(); response.msg.errorCode = "200"; response.msg.errorMessage = "OK"; } catch (Exception ex) { throw new Exception("PqrDAO.GetLoanResume", ex); } finally { ora.Dispose(); } return(response); }