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