//-------------------------------------------------------
//Get CtaCteDetallle
//-------------------------------------------------------
public DataTable Get_CtaCteDetalle(BE_ReqCtaCteDetalle ctaCteDetalle)
{
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Get_CtaCteDetalle]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cCtaCteRecibo", ctaCteDetalle.cCtaCteRecibo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
//----------------------
// Insert CtaCteDetalle
//----------------------
public bool Ins_CtaCteDetalle(BE_ReqCtaCteDetalle Request)
{
bool exito = false;
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Ins_CtaCteDetalle]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo);
cm.Parameters.AddWithValue("nSerCodigo", Request.nSerCodigo); //servicios de CtaCteServicios
cm.Parameters.AddWithValue("nCtaCteCantidad", Request.nCtaCteCantidad);
cm.Parameters.AddWithValue("nMoneda", Request.nMoneda);
cm.Parameters.AddWithValue("fCtaCteTC", Request.fCtaCteTC);
cm.Parameters.AddWithValue("fCtaCteIGV", Request.fCtaCteIGV);
cm.Parameters.AddWithValue("fCtaCteDetimporte", Request.fCtaCteDetimporte);
cm.Parameters.AddWithValue("dCtaCteDetRegistro", Request.dCtaCteDetRegistro);
cm.Parameters.AddWithValue("nCtaCtedetEstado", Request.nCtaCtedetEstado);
cm.Connection = cn;
if (cm.ExecuteNonQuery() > 0)
{
exito = true;
}
else
{
throw new ApplicationException("Se ha producido error procedimiento almacenado: [usp_Ins_CtaCteDetalle]; Consulte al administrador del sistema");
}
}
}
}
catch (Exception)
{
throw;
}
return(exito);
}
//-------------------
// INSERT CtaCtePago
//-------------------
public bool Ins_CtaCteDetalle(BE_ReqCtaCteDetalle Request)
{
bool exito = false;
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Ins_CtaCteDetalle]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nCtaCtePagCodigo", Request.nCtaCtePagCodigo);
cm.Parameters.AddWithValue("nCtaCteForPago", Request.nCtaCteForPago);
cm.Parameters.AddWithValue("nPerCtaCodigo", Request.nPerCtaCodigo);
cm.Parameters.AddWithValue("cPerjurCodigoFin", Request.cPerjurCodigoFin);
cm.Parameters.AddWithValue("dCtaCteFecTransacion", Request.dCtaCteFecTransacion);
cm.Parameters.AddWithValue("cCtaCtePagTracer", Request.cCtaCtePagTracer);
cm.Parameters.AddWithValue("nMonCodigo", Request.nMonCodigo);
cm.Parameters.AddWithValue("nCtaCtePagImpMon", Request.nCtaCtePagImpMon);
cm.Parameters.AddWithValue("nTC", Request.nTC);
cm.Parameters.AddWithValue("nCtaCtePagImporte", Request.nCtaCtePagImporte);
cm.Connection = cn;
if (cm.ExecuteNonQuery() > 0)
{
exito = true;
}
else
{
throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Ins_CtaCteDetalle]; Consulte al administrador del sistema");
}
}
}
}
catch (Exception)
{
throw;
}
return(exito);
}
public DataTable Get_CtaCteDetalle(BE_ReqCtaCteDetalle ctaCteDetalle)
{
DA_CtaCteDetalle Obj = new DA_CtaCteDetalle();
return(Obj.Get_CtaCteDetalle(ctaCteDetalle));
}
