public OutLoanDetail GetLoanDetailList(double folderNumber)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutLoanDetail response = new OutLoanDetail();
var ora = new OracleServer(connectionString);
LoanDetail detail;
List <LoanDetail> list = new List <LoanDetail>();
string command = string.Empty;
try
{
command = "SELECT NUMERO_CARPETA, TIPO_TRAMITE, DESC_TIPO_TRAMITE, FECHA_TRAMITE, USUARIO_TRAMITE, CODIGO_ESTADO_ANTERIOR, ";
command = command + "NOMBRE_ESTADO_ANT, CODIGO_ESTADO_NUEVO,NOMBRE_ESTADO_NVO, OBSERVACIONES,TIPO_LOG ";
command = command + string.Format("FROM BBS_LIQCOM_V_DET_CARPETAS WHERE NUMERO_CARPETA = {0} ORDER BY FECHA_TRAMITE", folderNumber);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
detail = new LoanDetail();
detail.folderNumber = DBNull.Value.Equals(rdr["NUMERO_CARPETA"]) ? 0 : double.Parse(rdr["NUMERO_CARPETA"].ToString());
detail.processType = DBNull.Value.Equals(rdr["TIPO_TRAMITE"]) ? 0 : double.Parse(rdr["TIPO_TRAMITE"].ToString());
detail.processTypeDescription = DBNull.Value.Equals(rdr["DESC_TIPO_TRAMITE"]) ? string.Empty : rdr["DESC_TIPO_TRAMITE"].ToString();
detail.processDate = DBNull.Value.Equals(rdr["FECHA_TRAMITE"]) ? DateTime.Today.ToString() : rdr["FECHA_TRAMITE"].ToString();
detail.processUser = DBNull.Value.Equals(rdr["USUARIO_TRAMITE"]) ? string.Empty : rdr["USUARIO_TRAMITE"].ToString();
detail.previousStateCode = DBNull.Value.Equals(rdr["CODIGO_ESTADO_ANTERIOR"]) ? 0 : double.Parse(rdr["CODIGO_ESTADO_ANTERIOR"].ToString());
detail.previousStateName = DBNull.Value.Equals(rdr["NOMBRE_ESTADO_ANT"]) ? string.Empty : rdr["NOMBRE_ESTADO_ANT"].ToString();
detail.NewStateCode = DBNull.Value.Equals(rdr["CODIGO_ESTADO_NUEVO"]) ? 0 : double.Parse(rdr["CODIGO_ESTADO_NUEVO"].ToString());
detail.NewStateName = DBNull.Value.Equals(rdr["NOMBRE_ESTADO_NVO"]) ? string.Empty : rdr["NOMBRE_ESTADO_NVO"].ToString();
detail.observations = DBNull.Value.Equals(rdr["OBSERVACIONES"]) ? string.Empty : rdr["OBSERVACIONES"].ToString();
detail.LogType = DBNull.Value.Equals(rdr["TIPO_LOG"]) ? 0 : double.Parse(rdr["TIPO_LOG"].ToString());
list.Add(detail);
}
rdr.Close();
response.loanDetailList = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("RequisitionDAO.GetLoanDetailList", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public OutLoanDetail GetLoanDetailList(double folderNumber)
{
OutLoanDetail loanDetail = new OutLoanDetail();
try
{
RequisitionDAO dao = new RequisitionDAO();
loanDetail = dao.GetLoanDetailList(folderNumber);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanDetailList", ex, "");
}
return(loanDetail);
}
