public Task <ResponseControl> ObtenerLiquidacionManual(string idproceso, int idproducto, int idbanco, string StrProforma, string fechaInicio, string fechaFin, string usercode)
{
bool exito = true;
CultureInfo cultureInfo = new CultureInfo("es-PE");
List <OracleParameter> parameters = new List <OracleParameter>();
ResponseControl Response = new ResponseControl(ResponseControl.Status.Ok);
List <Conciliacion> ObjListaConciliacion = new List <Conciliacion>();
State_voucher voucher;
try
{
parameters.Add(new OracleParameter("P_SIDPROCESS", OracleDbType.Varchar2, idproceso, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NIDBANK", OracleDbType.Int32, idbanco, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NPRODUCT", OracleDbType.Int32, idproducto, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_SPROFORMA", OracleDbType.Varchar2, StrProforma, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_DFECHAINI", OracleDbType.Date, DateTime.Parse(fechaInicio, cultureInfo), ParameterDirection.Input));
parameters.Add(new OracleParameter("P_DFECHAFIN", OracleDbType.Date, DateTime.Parse(fechaFin, cultureInfo), ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NUSERCODE", OracleDbType.Varchar2, usercode, 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_LIQUIDACION_MANUAL", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion))
{
while (dr.Read())
{
var _conciliacion = new Conciliacion();
_conciliacion.IsValido = true;
_conciliacion.IdProceso = idproceso;
_conciliacion.IdProducto = idproducto;
_conciliacion.NumeroRecibo = dr["SPROFORMA"] == DBNull.Value ? string.Empty : dr["SPROFORMA"].ToString();
_conciliacion.Importe = dr["NPREMIUM"] == DBNull.Value ? string.Empty : dr["NPREMIUM"].ToString();
_conciliacion.FechaVencimiento = dr["DEXPIRDAT"] == DBNull.Value ? string.Empty : dr["DEXPIRDAT"].ToString().Substring(0, 10);
_conciliacion.FechaPago = dr["DCOMPDATE"] == DBNull.Value ? string.Empty : dr["DCOMPDATE"].ToString().Substring(0, 10);
_conciliacion.IdMoneda = dr["NCURRENCY"] == DBNull.Value ? string.Empty : dr["NCURRENCY"].ToString();
_conciliacion.NumeroDocuento = dr["SIDDOC"] == DBNull.Value ? string.Empty : dr["SIDDOC"].ToString();
ObjListaConciliacion.Add(_conciliacion);
}
Response.Data = ObjListaConciliacion;
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> GeneraPlanillaFactura(string idproceso, int idproducto, int idbanco, string tipooperacion, int usercode)
{
bool exito = true;
List <OracleParameter> parameters = new List <OracleParameter>();
ResponseControl Response = new ResponseControl(ResponseControl.Status.Ok);
List <State_voucher> state_Vouchers = new List <State_voucher>();
State_voucher voucher;
try {
parameters.Add(new OracleParameter("P_SIDPROCESS", OracleDbType.Varchar2, idproceso, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NPRODUCT", OracleDbType.Varchar2, idproducto, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NIDBANK", OracleDbType.Varchar2, idbanco, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_STYPEOPE", OracleDbType.Varchar2, tipooperacion, ParameterDirection.Input));
parameters.Add(new OracleParameter("P_NUSERCODE", OracleDbType.Varchar2, usercode, 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_GENERA_PLANILLA_DOCUMENTO", parameters, ConnectionBase.enuTypeDataBase.OracleConciliacion))
{
while (dr.Read())
{
voucher = new State_voucher
{
SCAMPO = (dr["SCAMPO"] != null ? dr["SCAMPO"].ToString() : ""),
SGRUPO = (dr["SGRUPO"] != null ? dr["SGRUPO"].ToString() : ""),
SMENSAJE = (dr["SMENSAJE"] != null ? dr["SMENSAJE"].ToString() : ""),
SVALOR = (dr["SVALOR"] != null ? dr["SVALOR"].ToString() : ""),
BILLTYPE = (dr["SBILLTYPE"] != null ? dr["SBILLTYPE"].ToString() : ""),
SBILING = (dr["SBILLING"] != null ? dr["SBILLING"].ToString() : ""),
NINSUR_AREA = (dr["NINSUR_AREA"] != null ? dr["NINSUR_AREA"].ToString() : ""),
NBILLNUM = (dr["NBILLNUM"] != null ? dr["NBILLNUM"].ToString() : ""),
OPERADOR = (dr["SCORREO_OPE"] != null ? dr["SCORREO_OPE"].ToString() : "")
};
state_Vouchers.Add(voucher);
}
Response.Data = state_Vouchers;
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> 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));
}
