public int Inserta_FEComprobanteVenta(CE_FE_Comprobante_Venta dObj_Venta, List <CE_FE_Comprobante_Vta_Det> dObj_ListaDetalle)
{
int valor = 0;
int valorDet = 0;
int valorPago = 0;
try
{
valor = venta.Inserta_FEComprobanteVenta(dObj_Venta);
if (valor > 0)
{
foreach (CE_FE_Comprobante_Vta_Det dObj_VentaDet in dObj_ListaDetalle)
{
dObj_VentaDet.Ide_Venta = valor;
valorDet = venta.Inserta_FEComprobanteVentaDetalle(dObj_VentaDet);
}
//if (valorDet > 0)
//{
// dObj_VentaPago.Ide_Venta = valor;
// valorPago = Trans.Inserta_FEComprobanteVentaPago(dObj_VentaPago);
// if (valorPago > 0)
// {
// return valor;
// }
//}
}
}
catch (Exception ex)
{
return(0);
}
return(valor);
}
public int Inserta_FEComprobanteVenta(CE_FE_Comprobante_Venta dObj_Venta)
{
SqlConnection pCnx = new SqlConnection();
int dRpta = 0;
pCnx = objSql.AbrirConexion();
//SqlTransaction objTrans = objSql.begintrans(pCnx);
/*try
* {*/
SqlCommand Cmd = new SqlCommand("[Caja].[SP_FEComprobanteVentaInsertaVenta_INS]", pCnx);
SqlParameter dPar = new SqlParameter();
Cmd.Parameters.Clear();
Cmd.CommandType = CommandType.StoredProcedure;
//Cmd.Transaction = objTrans;
dPar = Cmd.Parameters.Add("@vIde_Cliente", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.Ide_Cliente;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Comp_Pago", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_Comp_Pago;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vNum_Serie_Venta", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.Num_Serie_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vNum_Doc_Venta", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.Num_Doc_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vFec_Emite_Venta", SqlDbType.Date);
dPar.Value = dObj_Venta.Fec_Emite_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vNum_Ruc_Venta", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.Num_Ruc_Venta;
dPar.Direction = ParameterDirection.Input;
/*dPar = Cmd.Parameters.Add("@vIde_Empresa_Fact", SqlDbType.Int);
* dPar.Value = dObj_Venta.Ide_Empresa_Fact;
* dPar.Direction = ParameterDirection.Input;*/
dPar = Cmd.Parameters.Add("@vDes_Nombre_Venta", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.Des_Nombre_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vDes_Direc_Venta", SqlDbType.NVarChar);
dPar.Value = dObj_Venta.des_Direc_Venta;
dPar.Direction = ParameterDirection.Input;
/*dPar = Cmd.Parameters.Add("@vIde_Tipo_Venta", SqlDbType.Int);
* dPar.Value = dObj_Venta.Ide_Tipo_Venta;
* dPar.Direction = ParameterDirection.Input;*/
/*dPar = Cmd.Parameters.Add("@vCan_Dias_Pago_Venta", SqlDbType.Int);
* dPar.Value = dObj_Venta.Can_Dias_Pago_Venta;
* dPar.Direction = ParameterDirection.Input;*/
/*dPar = Cmd.Parameters.Add("@vFec_Vmto_Venta", SqlDbType.Date);
* dPar.Value = dObj_Venta.Fec_Vmto_Venta;
* dPar.Direction = ParameterDirection.Input;*/
/*dPar = Cmd.Parameters.Add("@vIde_Motivo_NotCred", SqlDbType.Int);
* dPar.Value = dObj_Venta.Ide_Motivo_Notcred;
* dPar.Direction = ParameterDirection.Input;*/
dPar = Cmd.Parameters.Add("@vRef_Num_Serie_Venta", SqlDbType.NVarChar);
dPar.Value = (object)dObj_Venta.Ref_Num_Serie_Venta == null? DBNull.Value: (object)dObj_Venta.Ref_Num_Serie_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vRef_Num_Doc_Venta", SqlDbType.NVarChar);
dPar.Value = (object)dObj_Venta.Ref_Num_Doc_Venta == null ? DBNull.Value : (object)dObj_Venta.Ref_Num_Doc_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Tipo_Cambio_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Tipo_Cambio_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Moneda", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_moneda;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Valor_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Valor_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Depo_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Depo_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Total_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Total_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vPor_Impto_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Por_Impto_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Impto_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Impto_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Precio_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Precio_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Val_Inaf_Venta", SqlDbType.Decimal);
dPar.Value = (object)dObj_Venta.Imp_Val_Inaf_Venta == null ? DBNull.Value : (object)dObj_Venta.Imp_Val_Inaf_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Depo_Inaf_Venta", SqlDbType.Decimal);
dPar.Value = (object)dObj_Venta.Imp_Depo_Inaf_Venta == null ? DBNull.Value : (object)dObj_Venta.Imp_Depo_Inaf_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Precio_Inaf_Venta", SqlDbType.Decimal);
dPar.Value = (object)dObj_Venta.Imp_Precio_Inaf_Venta == null ? DBNull.Value : (object)dObj_Venta.Imp_Precio_Inaf_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Precio_Total_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Precio_Total_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Paga_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Paga_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vImp_Saldo_Venta", SqlDbType.Decimal);
dPar.Value = dObj_Venta.Imp_Saldo_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Punto_Venta", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_Punto_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Area ", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_Area;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Estado_Venta", SqlDbType.Int);
//Cmd.P
dPar.Value = dObj_Venta.Ide_Estado_Venta;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vIde_Usuario", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_Usuario;
dPar.Direction = ParameterDirection.Input;
/*dPar = Cmd.Parameters.Add("@vFec_Factu_Comp_Venta", SqlDbType.Date);
* dPar.Value = dObj_Venta.Fec_Factu_Comp_Venta;
* dPar.Direction = ParameterDirection.Input;
*
* dPar = Cmd.Parameters.Add("@vIde_Motivo_Anula_Venta", SqlDbType.Int);
* dPar.Value = dObj_Venta.Ide_Motivo_Anula_Venta;
* dPar.Direction = ParameterDirection.Input;*/
dPar = Cmd.Parameters.Add("@vIde_Sucursal", SqlDbType.Int);
dPar.Value = dObj_Venta.Ide_Sucursal;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vDes_Obs_Motivo_Anula", SqlDbType.NVarChar);
dPar.Value = (object)dObj_Venta.Des_Obs_Motivo_Anula == null ? DBNull.Value : (object)dObj_Venta.Des_Obs_Motivo_Anula;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@vObs_comp_vta_estado", SqlDbType.NVarChar);
dPar.Value = (object)dObj_Venta.Obs_comp_vta_estado == null ? DBNull.Value : (object)dObj_Venta.Obs_comp_vta_estado;
dPar.Direction = ParameterDirection.Input;
dPar = Cmd.Parameters.Add("@valor", SqlDbType.Int);
dPar.Direction = ParameterDirection.Output;
Cmd.ExecuteNonQuery();
dRpta = int.Parse(Cmd.Parameters["@valor"].Value.ToString());
//dRpta = 1;
/*if (dRpta > 0)
* {
* objSql.committrans(objTrans);
* Cmd.Dispose();
* }
* else
* {
* objSql.rollbacktrans(objTrans);
* strError = "Error";
* Cmd.Dispose();
* }
* }
* catch (SqlException ExSql)
* {
* strError = ExSql.Message;
* Console.WriteLine(strError);
* objSql.rollbacktrans(objTrans);
* }
*
* catch (Exception Ex)
* {
* strError = Ex.Message;
* Console.WriteLine(strError);
* objSql.rollbacktrans(objTrans);
* }
* finally
* {
*
* pCnx.Close();
* }*/
return(dRpta);
}
