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