public Boolean VTEX_CHANGE_STATUS_VTEX_ORDER(string ls_pais, string _nroliq, int estado) { Boolean valida = false; string sqlquery = "USP_UPDATE_VTEX_ORDER"; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString())) { if (cn.State == 0) { cn.Open(); } using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Liq_Id", _nroliq); cmd.Parameters.Add("@Estado", estado); cmd.ExecuteNonQuery(); } } } catch (Exception) { valida = false; } return(valida); }
public static void insertar_codigo_hash(string ls_pais, string _ven_id, string _hash, string _estado, string url_pdf) { string sqlquery = "USP_Insertar_Codigo_Hash"; SqlConnection cn = null; SqlCommand cmd = null; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString()); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ven_id", _ven_id); cmd.Parameters.AddWithValue("@codigo_hash", _hash); cmd.Parameters.AddWithValue("@Estado", _estado); cmd.Parameters.AddWithValue("@url_pdf", url_pdf); cmd.ExecuteNonQuery(); } catch { } if (cn.State == ConnectionState.Open) { cn.Close(); } }
public Boolean VTEX_Existe_Pedido_Bata(string ls_pais, string _nroped) { Boolean valida = false; string sqlquery = "USP_ExistePedido_Prestashop"; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString())) { if (cn.State == 0) { cn.Open(); } using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@liq_id", _nroped); cmd.Parameters.Add("@existe", SqlDbType.Bit); cmd.Parameters["@existe"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); valida = (Boolean)cmd.Parameters["@existe"].Value; } } } catch (Exception) { valida = false; } return(valida); }
public static string insertar_venta(string ls_pais, string _liq, ref string _error) { string sqlquery = "USP_Insertar_Venta_Tda"; SqlConnection cn = null; SqlCommand cmd = null; string num_doc = ""; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString()); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@liq_id", _liq); cmd.Parameters.AddWithValue("@usu_creacion", 1 /*Ent_Global._bas_id_codigo*/); cmd.Parameters.Add("@numero_venta", SqlDbType.VarChar, 20); cmd.Parameters["@numero_venta"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); num_doc = cmd.Parameters["@numero_venta"].Value.ToString(); } catch (Exception exc) { num_doc = "-1"; _error = exc.Message; //throw; } return(num_doc); }
public static void VTEX_insertar_guia(string ls_pais, string _guino, Int32 _trans, string _liq, out Int32 _valida, string tda_id) { string sqlquery = "USP_Insertar_Guia_VTEX"; SqlConnection cn = null; SqlCommand cmd = null; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString()); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tra_gui_no", _guino); cmd.Parameters.AddWithValue("@tra_gui_traid", _trans); cmd.Parameters.AddWithValue("@liq_id", _liq); cmd.Parameters.Add("@valida_guia", SqlDbType.Int); cmd.Parameters["@valida_guia"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@tda_id", tda_id); cmd.ExecuteNonQuery(); _valida = Convert.ToInt32(cmd.Parameters["@valida_guia"].Value); } catch (Exception exc) { _valida = 1; throw; } }
/*public static void FE_QR(string _tipo_doc, string _num_doc, ref Byte[] img_qr, ref string _error) * { * string _formato_doc = ""; * try * { * _formato_doc = Dat_Venta._leer_formato_electronico(_tipo_doc, _num_doc, ref _error); * GeneratorCdp generatorCdp = new GeneratorCdp(); * if (_tipo_doc == "B" || _tipo_doc == "F") * { * img_qr = generatorCdp.GetImageQrCodeForInvoiceCdp(_formato_doc); * * } * else * { * img_qr = generatorCdp.GetImageQrCodeForNoteCdp(_formato_doc); * } * * } * catch (Exception exc) * { * * _error = exc.Message; * } * }*/ #region <METODO ESTATICA PARA LA FACTURACION ELECTRONICA> /// <summary> /// configuracion de la facturacion electronica paperless /// </summary> public static void config_ws_fe(string ls_pais) { string sqlquery = "USP_LeerConfig_FE"; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString())) { try { if (cn.State == 0) { cn.Open(); } using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ws_ruc", SqlDbType.VarChar, 20); cmd.Parameters.Add("@ws_login", SqlDbType.VarChar, 20); cmd.Parameters.Add("@ws_password", SqlDbType.VarChar, 20); cmd.Parameters.Add("@pr_factura", SqlDbType.VarChar, 1); cmd.Parameters["@ws_ruc"].Direction = ParameterDirection.Output; cmd.Parameters["@ws_login"].Direction = ParameterDirection.Output; cmd.Parameters["@ws_password"].Direction = ParameterDirection.Output; cmd.Parameters["@pr_factura"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); _ws_ruc = cmd.Parameters["@ws_ruc"].Value.ToString(); _ws_login = cmd.Parameters["@ws_login"].Value.ToString(); _ws_password = cmd.Parameters["@ws_password"].Value.ToString(); pr_facturador = cmd.Parameters["@pr_factura"].Value.ToString(); } } catch (Exception exc) { } if (cn != null) { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } catch { } }
public static string _leer_formato_electronico_PAPERLESS(string ls_pais, string _tipo_doc, string _num_doc, ref string _error, ref string return_numdoc) { string _formato_doc = ""; string sqlquery = "[USP_Leer_Formato_Electronico_Paperless]"; SqlConnection cn = null; SqlCommand cmd = null; try { string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString()); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tip", _tipo_doc); cmd.Parameters.AddWithValue("@doc_id", _num_doc); cmd.Parameters.Add("@formato_txt", SqlDbType.NVarChar, -1); cmd.Parameters["@formato_txt"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@num_doc_return", SqlDbType.VarChar, 15); cmd.Parameters["@num_doc_return"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); _formato_doc = cmd.Parameters["@formato_txt"].Value.ToString(); return_numdoc = cmd.Parameters["@num_doc_return"].Value.ToString(); } catch (Exception exc) { _formato_doc = ""; _error = exc.Message; } if (cn.State == ConnectionState.Open) { cn.Close(); } return(_formato_doc); }
//-----INICIO---SB-VTEX2020---20201119_18:07-- public string[] VTEX_Update_Pedido(string ls_pais, decimal _usu, string _tda_id, decimal _idCust, string _reference, decimal _discCommPctg, decimal _discCommValue, string _shipTo, string _specialInstr, List <Order_Dtl> _itemsDetail, decimal _varpercepcion, Int32 _estado, string _ped_id = "", string _liq = "", Int32 _liq_dir = 0, Int32 _PagPos = 0, string _PagoPostarjeta = "", string _PagoNumConsignacion = "", decimal _PagoTotal = 0, DataTable dtpago = null, Boolean _pago_credito = false, Decimal _porc_percepcion = 0, List <Order_Dtl_Temp> order_dtl_temp = null, string _Liq_Pst_Id = "0", string _Liq_Pst_Ref = "", Decimal _CostoE = 0, Cliente cl = null, Pagos pag = null, DateTime?_ped_fecha = null, decimal _liq_tot_cigv = 0, string _ped_ubigeo_ent = "", string _ped_dir_ent = "", string _ped_ref_ent = "", string _ped_nom_ent = "", string _ped_tel_ent = "", Decimal _det_peso = 0, DataTable pagos = null, string _name_courier = null) { string[] resultDoc = new string[2]; string sqlquery = "USP_Insertar_Modifica_Liquidacion"; SqlConnection cn = null; SqlCommand cmd = null; try { DataTable dt = new DataTable(); dt.Columns.Add("Ped_Det_Id", typeof(string)); dt.Columns.Add("Ped_Det_Items", typeof(Int32)); dt.Columns.Add("Ped_Det_ArtId", typeof(string)); dt.Columns.Add("Ped_Det_TalId", typeof(string)); dt.Columns.Add("Ped_Det_Cantidad", typeof(Int32)); dt.Columns.Add("Ped_Det_Costo", typeof(decimal)); dt.Columns.Add("Ped_Det_Precio", typeof(decimal)); dt.Columns.Add("Ped_Det_ComisionP", typeof(decimal)); dt.Columns.Add("Ped_Det_ComisionM", typeof(decimal)); dt.Columns.Add("Ped_Det_OfertaP", typeof(decimal)); dt.Columns.Add("Ped_Det_OfertaM", typeof(decimal)); dt.Columns.Add("Ped_Det_OfeID", typeof(decimal)); dt.Columns.Add("Ped_Det_ArtDes", typeof(string)); dt.Columns.Add("Ped_Det_Peso", typeof(decimal)); //-----INICIO---SB-VTEX2020---20201119_18:07-- dt.Columns.Add("Ped_Det_TdaId", typeof(string)); //-----FIN---SB-VTEX2020---20201119_18:07-- int i = 1; // Recorrer todas las lineas adicionAQUARELLAs al detalle if (_itemsDetail != null) { foreach (Order_Dtl item in _itemsDetail) { dt.Rows.Add(_ped_id, i, item._code, item._size, item._qty, 0, item._price, item._commissionPctg, Math.Round(item._commission, 2, MidpointRounding.AwayFromZero), item._ofe_porc, item._dscto, item._ofe_id, item._art_des, item._art_peso //-----INICIO---SB-VTEX2020---20201119_18:07-- , item._tda_id //-----FIN---SB-VTEX2020---20201119_18:07-- ); i++; } } /*pedido original*/ DataTable dtordertmp = new DataTable(); dtordertmp.Columns.Add("items", typeof(Int32)); dtordertmp.Columns.Add("articulo", typeof(string)); dtordertmp.Columns.Add("talla", typeof(string)); dtordertmp.Columns.Add("cantidad", typeof(Int32)); if (order_dtl_temp != null) { foreach (Order_Dtl_Temp item in order_dtl_temp) { dtordertmp.Rows.Add(item.items, item.articulo, item.talla, item.cantidad); } } //grabar pedido string ls_nameconnection = GetConexion.GetNameConnectionString(ls_pais); cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ls_nameconnection].ToString()); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Estado", _estado); cmd.Parameters.AddWithValue("@tienda_id", _tda_id); cmd.Parameters.AddWithValue("@Ped_Id", _ped_id); //id pedido //cmd.Parameters.AddWithValue("@LiqId", _liq); cmd.Parameters.Add("@LiqId", SqlDbType.VarChar, 16); cmd.Parameters["@LiqId"].Value = _liq; cmd.Parameters["@LiqId"].Direction = ParameterDirection.InputOutput; cmd.Parameters.AddWithValue("@Liq_BasId", _idCust); //id cliente cmd.Parameters.AddWithValue("@Liq_ComisionP", _discCommPctg); cmd.Parameters.AddWithValue("@Liq_PercepcionM", _varpercepcion); cmd.Parameters.AddWithValue("@Liq_Usu", _usu); // PRESTASHOP compos PK cmd.Parameters.AddWithValue("@Liq_Pst_Id", _Liq_Pst_Id); // id de prestashop numerico cmd.Parameters.AddWithValue("@Liq_Pst_Ref", _Liq_Pst_Ref); //id de prestashop alfanumerico cmd.Parameters.AddWithValue("@liq_costoe", _CostoE); cmd.Parameters.AddWithValue("@liq_fecha", _ped_fecha); cmd.Parameters.AddWithValue("@liq_tot_cigv", _liq_tot_cigv); cmd.Parameters.AddWithValue("@liq_Ubigeo_ent", _ped_ubigeo_ent); cmd.Parameters.AddWithValue("@liq_dir_ent", _ped_dir_ent); cmd.Parameters.AddWithValue("@liq_dir_ref", _ped_ref_ent); // Modificado por : Henry Morales - 21/05/2018 // Se agergaron los campos de nombre y telefono de referencia de entrega cmd.Parameters.AddWithValue("@liq_nom_ref", _ped_nom_ent); cmd.Parameters.AddWithValue("@liq_tel_ref", _ped_tel_ent); cmd.Parameters.AddWithValue("@liq_pes_tot", _det_peso); /*ingreso de clientes*/ cmd.Parameters.AddWithValue("@bas_nombres", cl.cli_nombres); cmd.Parameters.AddWithValue("@bas_apellidos", cl.cli_apellidos); cmd.Parameters.AddWithValue("@bas_email", cl.cli_email); cmd.Parameters.AddWithValue("@bas_ubigeo", cl.cli_ubigeo); cmd.Parameters.AddWithValue("@bas_direccion", cl.cli_direc); cmd.Parameters.AddWithValue("@bas_telf", cl.cli_telf); cmd.Parameters.AddWithValue("@bas_cel", cl.cli_telf_mov); cmd.Parameters.AddWithValue("@bas_dni", cl.cli_dni); /****************************/ /*METODO DE PAGOS*/ // Modificado por : Henry Morales - 19/06/2018 // Se agregó para mandar los diversos pagos hechos en la liquidación cmd.Parameters.AddWithValue("@Detalle_Pago_ps", pagos); /*cmd.Parameters.AddWithValue("@pag_metodo", pag.pag_metodo); * cmd.Parameters.AddWithValue("@pag_metodo", pag.pag_metodo); * cmd.Parameters.AddWithValue("@pag_nro_trans", pag.pag_nro_trans); * cmd.Parameters.AddWithValue("@pag_fecha", pag.pag_fecha); * cmd.Parameters.AddWithValue("@pag_monto", pag.pag_monto);*/ /******************/ cmd.Parameters.AddWithValue("@Detalle_Pedido", dt); cmd.Parameters.AddWithValue("@Liquidacion_Directa", _liq_dir); /*PEDIDO ORIGINAL*/ cmd.Parameters.AddWithValue("@pedido_original", dtordertmp); //opcional pago por pos liquidacion directa cmd.Parameters.AddWithValue("@Pago_Pos", _PagPos); cmd.Parameters.AddWithValue("@Pago_PosTarjeta", _PagoPostarjeta); cmd.Parameters.AddWithValue("@Pago_numconsigacion", _PagoNumConsignacion); cmd.Parameters.AddWithValue("@Pago_Total", _PagoTotal); //pago directo de la liquidacion cmd.Parameters.AddWithValue("@DetallePago", dtpago); cmd.Parameters.AddWithValue("@Pago_Credito", _pago_credito); //porcentaje percepcion cmd.Parameters.AddWithValue("@Ped_Por_Perc", _porc_percepcion); cmd.Parameters.AddWithValue("@name_courier", _name_courier); //da = new SqlDataAdapter(cmd); //da.Fill(ds); cmd.ExecuteNonQuery(); resultDoc[0] = cmd.Parameters["@LiqId"].Value.ToString(); } catch (Exception ex) { if (cn != null) { if (cn.State == ConnectionState.Open) { cn.Close(); } } resultDoc[0] = "-1"; resultDoc[1] = ex.Message; } if (cn != null) { if (cn.State == ConnectionState.Open) { cn.Close(); } } return(resultDoc); }