public OutLoanInformation GetLoanInformationByCustomer(double customerID) { OutLoanInformation loanInformation = new OutLoanInformation(); try { RequisitionDAO dao = new RequisitionDAO(); loanInformation = dao.GetLoanInformationByCustomer(customerID); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanInformationByCustomer", ex, ""); } return(loanInformation); }
public OutLoanInformation GetLoanInformationByLoanOfficer(double officerID, DateTime startDate, DateTime endDate) { OutLoanInformation loanInformation = new OutLoanInformation(); try { RequisitionDAO dao = new RequisitionDAO(); loanInformation = dao.GetLoanInformationByLoanOfficer(officerID, startDate, endDate); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanInformationByLoanOfficer", ex, ""); } return(loanInformation); }
public OutLoanInformation GetLoanInformationByCustomer(double customerID) { string connectionString = DataBaseHelper.GetConnectionString("DLG"); OutLoanInformation response = new OutLoanInformation(); LoanInformation loan; List <LoanInformation> lst = new List <LoanInformation>(); var ora = new OracleServer(connectionString); //LoanDetail detail; string command = string.Empty; try { command = "SELECT NUMERO_CARPETA, NUMERO_IDENTIFICACION, NOMBRE_PERSONA, CODIGO_ESTADO_CARPETA, NOMBRE_ESTADO_CARPETA, "; command = command + "LINEA_CREDITO, MONTO_SOLICITUD, MONTO_APROBADO, PLAZO_APROBADO, TASA_APROBADA, CODIGO_ASESOR, "; command = command + "FECHA_CREACION, CODIGO_ZONA, CODIGO_SUCURSAL, NOMBRE_SUCURSAL, CODIGO_CONVENIO, NOMBRE_CONVENIO, "; command = command + "CODIGO_PAGADURIA, NOMRE_CONVENIO, ANALISTA_APROBACION, CODIGO_NOVEDAD, NOMBRE_NOVEDAD, CODIGO_JEFE_CCIAL, "; command = command + "NOMBRE_JEFE_CCIAL, CEDULA_EJECUTIVO, NOMBRE_EJECUTIVO "; command = command + string.Format("FROM BBS_LIQCOM_V_CARPETAS WHERE NUMERO_IDENTIFICACION = '{0}'", customerID); var rdr = ora.ExecuteCommand(command); while (rdr.Read()) { loan = new LoanInformation(); loan.folderNumber = DBNull.Value.Equals(rdr["NUMERO_CARPETA"]) ? 0 : double.Parse(rdr["NUMERO_CARPETA"].ToString()); loan.numberID = DBNull.Value.Equals(rdr["NUMERO_IDENTIFICACION"]) ? string.Empty : rdr["NUMERO_IDENTIFICACION"].ToString(); loan.personName = DBNull.Value.Equals(rdr["NOMBRE_PERSONA"]) ? string.Empty : rdr["NOMBRE_PERSONA"].ToString(); loan.folderStateCode = DBNull.Value.Equals(rdr["CODIGO_ESTADO_CARPETA"]) ? 0 : double.Parse(rdr["CODIGO_ESTADO_CARPETA"].ToString()); loan.folderStateName = DBNull.Value.Equals(rdr["NOMBRE_ESTADO_CARPETA"]) ? string.Empty : rdr["NOMBRE_ESTADO_CARPETA"].ToString(); loan.loanLine = DBNull.Value.Equals(rdr["LINEA_CREDITO"]) ? 0 : double.Parse(rdr["LINEA_CREDITO"].ToString()); loan.requisitionAmount = DBNull.Value.Equals(rdr["MONTO_SOLICITUD"]) ? 0 : double.Parse(rdr["MONTO_SOLICITUD"].ToString()); loan.amountApproved = DBNull.Value.Equals(rdr["MONTO_APROBADO"]) ? 0 : double.Parse(rdr["MONTO_APROBADO"].ToString()); loan.termApproved = DBNull.Value.Equals(rdr["PLAZO_APROBADO"]) ? 0 : int.Parse(rdr["PLAZO_APROBADO"].ToString()); loan.rateApproved = DBNull.Value.Equals(rdr["TASA_APROBADA"]) ? 0 : decimal.Parse(rdr["TASA_APROBADA"].ToString()); loan.loanOfficerCode = DBNull.Value.Equals(rdr["CODIGO_ASESOR"]) ? 0 : double.Parse(rdr["CODIGO_ASESOR"].ToString()); loan.creationDate = DBNull.Value.Equals(rdr["FECHA_CREACION"]) ? DateTime.Today.ToString() : rdr["FECHA_CREACION"].ToString(); loan.zoneCode = DBNull.Value.Equals(rdr["CODIGO_ZONA"]) ? 0 : double.Parse(rdr["CODIGO_ZONA"].ToString()); loan.branchCode = DBNull.Value.Equals(rdr["CODIGO_SUCURSAL"]) ? 0 : double.Parse(rdr["CODIGO_SUCURSAL"].ToString()); loan.branchName = DBNull.Value.Equals(rdr["NOMBRE_SUCURSAL"]) ? string.Empty : rdr["NOMBRE_SUCURSAL"].ToString(); loan.agreementCode = DBNull.Value.Equals(rdr["CODIGO_CONVENIO"]) ? 0 : double.Parse(rdr["CODIGO_CONVENIO"].ToString()); loan.agreementName = DBNull.Value.Equals(rdr["NOMBRE_CONVENIO"]) ? string.Empty : rdr["NOMBRE_CONVENIO"].ToString(); loan.payamentCode = DBNull.Value.Equals(rdr["CODIGO_PAGADURIA"]) ? 0 : double.Parse(rdr["CODIGO_PAGADURIA"].ToString()); loan.payamentName = DBNull.Value.Equals(rdr["NOMRE_CONVENIO"]) ? string.Empty : rdr["NOMRE_CONVENIO"].ToString(); loan.analystsApproved = DBNull.Value.Equals(rdr["ANALISTA_APROBACION"]) ? "-" : rdr["ANALISTA_APROBACION"].ToString(); loan.noveltyCode = DBNull.Value.Equals(rdr["CODIGO_NOVEDAD"]) ? 0 : double.Parse(rdr["CODIGO_NOVEDAD"].ToString()); loan.noveltyName = DBNull.Value.Equals(rdr["NOMBRE_NOVEDAD"]) ? string.Empty : rdr["NOMBRE_NOVEDAD"].ToString(); loan.commercialBossCode = DBNull.Value.Equals(rdr["CODIGO_JEFE_CCIAL"]) ? 0 : double.Parse(rdr["CODIGO_JEFE_CCIAL"].ToString()); loan.commercialBossName = DBNull.Value.Equals(rdr["NOMBRE_JEFE_CCIAL"]) ? string.Empty : rdr["NOMBRE_JEFE_CCIAL"].ToString(); loan.executiveID = DBNull.Value.Equals(rdr["CEDULA_EJECUTIVO"]) ? string.Empty : rdr["CEDULA_EJECUTIVO"].ToString(); loan.executiveName = DBNull.Value.Equals(rdr["NOMBRE_EJECUTIVO"]) ? string.Empty : rdr["NOMBRE_EJECUTIVO"].ToString(); lst.Add(loan); } rdr.Close(); response.loanInformationList = lst; response.msg = new Response(); response.msg.errorCode = "200"; response.msg.errorMessage = "OK"; } catch (Exception ex) { throw new Exception("RequisitionDAO.GetLoanInformationByCustomer", ex); } finally { ora.Dispose(); } return(response); }