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); }