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