public Task <ResponseControl> ObtenerFormaPago(int idBanco, string idProceso)
{
List <OracleParameter> parameters = new List <OracleParameter>();
ResponseControl Response = new ResponseControl(ResponseControl.Status.Ok);
List <ListaConciliacion> ListFormaPago = new List <ListaConciliacion>();
ListaConciliacion conciliacion;
try
{
parameters.Add(new OracleParameter("P_SIDPROCESS", OracleDbType.Varchar2, idProceso, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NIDBANK", OracleDbType.Int16, idBanco, ParameterDirection.Input));
var pCode = new OracleParameter("P_NCODE", OracleDbType.Int16, ParameterDirection.Output);
var p_Message = new OracleParameter("P_SMESSAGE", OracleDbType.NVarchar2, ParameterDirection.Output);
var table = new OracleParameter("C_TABLE", OracleDbType.RefCursor, ParameterDirection.Output);
p_Message.Size = 2500;
table.Size = 4000;
parameters.Add(pCode);
parameters.Add(p_Message);
parameters.Add(table);
//_connectionBase.ExecuteByStoredProcedure("PKG_SCTR_COBRANZAS.SPS_GENERA_PLANILLA_DOCUMENTO", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion);
using (OracleDataReader dr = (OracleDataReader)_connectionBase.ExecuteByStoredProcedure("PKG_SCTR_COBRANZAS.SPS_PLANILLA_AUTOMATICA", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion))
{
while (dr.Read())
{
conciliacion = new ListaConciliacion
{
IdMoneda = (dr["NIDCURRENCY"] != null ? dr["NIDCURRENCY"].ToString() : string.Empty),
IdTipoPago = (dr["NIDPAIDTYPE"] != null ? dr["NIDPAIDTYPE"].ToString() : string.Empty),
IdCuentaBanco = (dr["NIDACCOUNTBANK"] != null ? dr["NIDACCOUNTBANK"].ToString() : string.Empty),
IdBanco = (dr["NIDBANK"] != null ? dr["NIDBANK"].ToString() : string.Empty),
NumeroOperacion = (dr["SOPERATION_NUMBER"] != null ? dr["SOPERATION_NUMBER"].ToString() : string.Empty),
FechaOperacion = (dr["DOPERATION_DATE"] != null ? dr["DOPERATION_DATE"].ToString() : string.Empty),
Referencia = (dr["SREFERENCE"] != null ? dr["SREFERENCE"].ToString() : string.Empty),
MontoFormaPago = (dr["NAMOUNT"] != null ? dr["NAMOUNT"].ToString() : string.Empty),
};
ListFormaPago.Add(conciliacion);
}
Response.Data = ListFormaPago;
Response.message = p_Message.Value.ToString();
if (!(pCode.Value.ToString() == "0"))
{
Response.Code = pCode.Value.ToString();
throw new Exception(p_Message.Value.ToString());
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(Task.FromResult <ResponseControl>(Response));
}
public Task <ResponseControl> Validar_Planilla_Factura(ListaConciliacion listaConciliacions)
{
ResponseControl response = new ResponseControl(ResponseControl.Status.Ok);
try
{
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(new OracleParameter("P_SIDPROCESS", OracleDbType.Varchar2, listaConciliacions.IdProceso ?? string.Empty, ParameterDirection.Input));
var nnoBills = new OracleParameter("P_NNOBILLS", OracleDbType.Int16, ParameterDirection.Output);
parameters.Add(nnoBills);
_connectionBase.ExecuteByStoredProcedure("PKG_SCTR_COBRANZAS.SPS_VALIDA_PLANILLA", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion);
response.Data = nnoBills.Value.ToString() == "1" ? true : false;
}
catch (Exception ex)
{
response.message = ex.Message;
response.Code = "1";
}
return(Task.FromResult <ResponseControl>(response));
}