private void guardardatos()
{
DataTable dtFormaPago = new DataTable();
DataSet dsFormaPago = new DataSet();
DataTable dtFactura = new DataTable();
DataSet dsFactura = new DataSet();
DataSet dsViajeros;
DataSet dsOtraInfo;
DataSet dsInfoEmergencia;
DataSet ds = new DataSet();
DataSet dsProducto;
DataSet dsProveedor;
DataSet dsPrecioPesos;
DataSet dsPrecioDolar;
DataSet dsCantidad;
DataSet dsDatosViaje;
dsViajeros = (DataSet)Session["Viajeros"];
dsOtraInfo = (DataSet)Session["OtraInfoViajeros"];
dsInfoEmergencia = (DataSet)Session["InfoEmergencia"];
dsFormaPago = (DataSet)Session["InfoFormasdePago"];
dsFactura = (DataSet)Session["InfoFactura"];
dsDatosViaje = (DataSet)Session["DatosViaje"];
dsProducto = (DataSet)Session["Productos"];
dsProveedor = (DataSet)Session["Proveedor"];
dsPrecioPesos = (DataSet)Session["PrecioPesos"];
dsPrecioDolar = (DataSet)Session["PrecioDolar"];
dsCantidad = (DataSet)Session["Cantidad"];
String opciones = "";
String[] Datos;
int EsProductoAdicional = 0;
String IdOperacionRetorno = "";
SqlDataAdapter adapter;
try
{
MP mp = new MP("3592982235689583", "iwzO6CMeOH6gA0dMYnCtvZZo7L6aUYO3");
mp.sandboxMode(true);
Dictionary<String, String> filters = new Dictionary<String, String>();
filters.Add("status", "success");
Hashtable searchResult = mp.searchPayment(filters);
////Hashtable payment_info = mp.getPaymentInfo(Request["id"]);
////if ((int)payment_info["status"] == 200){
//// Response.Write(payment_info["response"]);
////}
Hashtable payment = (Hashtable)searchResult["response"];
ArrayList collection = (ArrayList)payment["results"];
Hashtable items = (Hashtable)collection[0];
Hashtable item = (Hashtable)items["collection"];
opciones = Request.QueryString["op"];
Datos = opciones.Split('_');
Session.Remove("Viajeros");
Session.Remove("OtraInfoViajeros");
Session.Remove("InfoEmergencia");
Session.Remove("InfoFormasdePago");
Session.Remove("InfoFactura");
Session.Remove("DatosViaje");
Session.Remove("Productos");
Session.Remove("Proveedor");
Session.Remove("PrecioPesos");
Session.Remove("PrecioDolar");
Session.Remove("Cantidad");
try
{
if ((dsFactura != null) && (dsFactura.Tables[0].Rows.Count > 0))
{
if ((dsFormaPago != null) && (dsFormaPago.Tables[0].Rows.Count > 0))
{
System.Data.SqlClient.SqlConnection conn;
conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn.Open();
SqlCommand command = new SqlCommand("spOperaciones", conn);
command.CommandType = CommandType.StoredProcedure;
SqlParameter paramCodRetorno = new SqlParameter("pCodigo", SqlDbType.Int);
paramCodRetorno.Direction = ParameterDirection.Output;
command.Parameters.Add(paramCodRetorno);
command.Parameters.AddWithValue("Facturacion_CodSituacionFiscal", Convert.ToInt32(dsFactura.Tables[0].Rows[0]["SituacionFiscal"].ToString()));
command.Parameters.AddWithValue("Facturacion_NombreoRazonSocial", dsFactura.Tables[0].Rows[0]["RazonSocial"].ToString());
command.Parameters.AddWithValue("Facturacion_CUILCUIT", dsFactura.Tables[0].Rows[0]["CUILCUIT"].ToString());
command.Parameters.AddWithValue("Facturacion_CodigoPostal", dsFactura.Tables[0].Rows[0]["CodigoPostal"].ToString());
command.Parameters.AddWithValue("Facturacion_Domicilio", dsFactura.Tables[0].Rows[0]["Domicilio"].ToString());
command.Parameters.AddWithValue("Facturacion_Ciudad", dsFactura.Tables[0].Rows[0]["CiudadDomicilio"].ToString());
command.Parameters.AddWithValue("Facturacion_IdPais", Convert.ToInt32(dsFactura.Tables[0].Rows[0]["PaisDomicilio"].ToString()));
command.Parameters.AddWithValue("Facturacion_TipoTelefono", Convert.ToInt32(dsFactura.Tables[0].Rows[0]["TipoTelefono"].ToString()));
command.Parameters.AddWithValue("Facturacion_IdPaisTelefono", Convert.ToInt32(dsFactura.Tables[0].Rows[0]["PaisTelefono"].ToString()));
command.Parameters.AddWithValue("Facturacion_CodArea", dsFactura.Tables[0].Rows[0]["CodAreaCiudad"].ToString());
command.Parameters.AddWithValue("Facturacion_NroTelefono", dsFactura.Tables[0].Rows[0]["NroLocal"].ToString());
command.Parameters.AddWithValue("IdOrigen", Convert.ToInt32(dsDatosViaje.Tables[0].Rows[0]["IdOrigen"].ToString()));
command.Parameters.AddWithValue("IdDestino", Convert.ToInt32(dsDatosViaje.Tables[0].Rows[0]["IdDestino"].ToString()));
command.Parameters.AddWithValue("IdProducto", Convert.ToInt32(dsDatosViaje.Tables[0].Rows[0]["IdProducto"].ToString()));
command.Parameters.AddWithValue("FechaPartida", Datos[0].ToString());
command.Parameters.AddWithValue("FechaRegreso", Datos[1].ToString());
command.Parameters.AddWithValue("ImporteTarifaPesos", Convert.ToDecimal(Datos[2].ToString()));
command.Parameters.AddWithValue("ImporteTarifaDolar", Convert.ToDecimal(Datos[3].ToString()));
command.Parameters.AddWithValue("IdFormadePago", Convert.ToInt32(dsFormaPago.Tables[0].Rows[0]["TipoPago"].ToString()));
command.Parameters.AddWithValue("IdBancoEmisor", 0);
command.Parameters.AddWithValue("IdTarjeta", 0);
command.Parameters.AddWithValue("NroTarjeta", 0);
command.Parameters.AddWithValue("VtoDia", 0);
command.Parameters.AddWithValue("VtoAnio", 0);
command.Parameters.AddWithValue("CodigoSeguridad", 0);
command.Parameters.AddWithValue("NroCuotas", 0);
//command.Parameters.AddWithValue("Id_OperacionMercadoPago", Convert.ToInt32(item["id"]));
command.Parameters.AddWithValue("Id_OperacionMercadoPago", 1);
command.Parameters.AddWithValue("Estado", 3);
command.Parameters.AddWithValue("TipoTelefono", Convert.ToInt32(dsFormaPago.Tables[0].Rows[0]["TipoTelefono"].ToString()));
command.Parameters.AddWithValue("CodArea", dsFormaPago.Tables[0].Rows[0]["CodAreaTelefono"].ToString());
command.Parameters.AddWithValue("NroTelefono", dsFormaPago.Tables[0].Rows[0]["NroTelefono"].ToString());
command.Parameters.AddWithValue("IdPais", Convert.ToInt32(dsFormaPago.Tables[0].Rows[0]["PaisTelefono"].ToString()));
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
conn.Close();
IdOperacionRetorno = paramCodRetorno.SqlValue.ToString();
lblOperacion.Text = IdOperacionRetorno;
if ((dsViajeros != null) && (dsViajeros.Tables[0].Rows.Count > 0))
{
//if ((dsOtraInfo != null) && (dsOtraInfo.Tables[0].Rows.Count > 0))
//{
for (int y = 0; y < dsViajeros.Tables[0].Rows.Count; y++)
{
System.Data.SqlClient.SqlConnection conn1;
conn1 = new System.Data.SqlClient.SqlConnection();
conn1.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn1.Open();
SqlCommand command1 = new SqlCommand("spPasajeros", conn1);
command1.CommandType = CommandType.StoredProcedure;
SqlParameter paramCodRetorno1 = new SqlParameter("pCodigo", SqlDbType.Int);
paramCodRetorno1.Direction = ParameterDirection.Output;
command1.Parameters.Add(paramCodRetorno1);
command1.Parameters.AddWithValue("Nombre", dsViajeros.Tables[0].Rows[y]["Nombre"].ToString());
command1.Parameters.AddWithValue("Apellido", dsViajeros.Tables[0].Rows[y]["Apellido"].ToString());
command1.Parameters.AddWithValue("FechaNac", dsViajeros.Tables[0].Rows[y]["Fecha"].ToString());
command1.Parameters.AddWithValue("Edad", Convert.ToInt32(dsViajeros.Tables[0].Rows[y]["Edad"].ToString()));
command1.Parameters.AddWithValue("TipoDocu", 1);
command1.Parameters.AddWithValue("NroDocumento", Convert.ToInt32(dsViajeros.Tables[0].Rows[y]["DNI"].ToString()));
command1.Parameters.AddWithValue("IdPaisResidencia", Convert.ToInt32(dsViajeros.Tables[0].Rows[y]["Pais"].ToString()));
command1.Parameters.AddWithValue("Ciudad", dsViajeros.Tables[0].Rows[y]["Ciudad"].ToString());
command1.Parameters.AddWithValue("Domicilio", "");
command1.Parameters.AddWithValue("TipoTelefono", 0);
command1.Parameters.AddWithValue("CodArea", "");
command1.Parameters.AddWithValue("Telefono", "");
command1.Parameters.AddWithValue("Email", dsViajeros.Tables[0].Rows[y]["Email"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_Apellido", dsInfoEmergencia.Tables[0].Rows[0]["Apellido"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_Nombre", dsInfoEmergencia.Tables[0].Rows[0]["Nombre"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_TipoTelefono", Convert.ToInt32(dsInfoEmergencia.Tables[0].Rows[0]["TipoTelefono"].ToString()));
command1.Parameters.AddWithValue("ContactoEmergencia_CodArea", dsInfoEmergencia.Tables[0].Rows[0]["CodCiudad"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_Telefono", dsInfoEmergencia.Tables[0].Rows[0]["NumeroLocal"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_Email", dsInfoEmergencia.Tables[0].Rows[0]["Email"].ToString());
command1.Parameters.AddWithValue("ContactoEmergencia_IdPaisResidencia", Convert.ToInt32(dsInfoEmergencia.Tables[0].Rows[0]["Pais"].ToString()));
command1.Parameters.AddWithValue("ContactoEmergencia_Ciudad", "");
command1.Parameters.AddWithValue("InfoContacto_Apellido", dsOtraInfo.Tables[0].Rows[0]["Apellido"].ToString());
command1.Parameters.AddWithValue("InfoContacto_Nombre", dsOtraInfo.Tables[0].Rows[0]["Nombre"].ToString());
command1.Parameters.AddWithValue("InfoContacto_TipoTelefono", Convert.ToInt32(dsOtraInfo.Tables[0].Rows[0]["TipoTelefono"].ToString()));
command1.Parameters.AddWithValue("InfoContacto_CodArea", dsOtraInfo.Tables[0].Rows[0]["CodCiudad"].ToString());
command1.Parameters.AddWithValue("InfoContacto_Telefono", dsOtraInfo.Tables[0].Rows[0]["NumeroLocal"].ToString());
command1.Parameters.AddWithValue("InfoContacto_Email", dsOtraInfo.Tables[0].Rows[0]["Email"].ToString());
command1.Parameters.AddWithValue("InfoContacto_IdPaisResidencia", Convert.ToInt32(dsOtraInfo.Tables[0].Rows[0]["Pais"].ToString()));
command1.Parameters.AddWithValue("InfoContacto_Ciudad", "");
command1.ExecuteNonQuery();
adapter = new SqlDataAdapter(command1);
conn1.Close();
if (paramCodRetorno1.SqlValue.ToString() != null)
{
System.Data.SqlClient.SqlConnection conn2;
conn2 = new System.Data.SqlClient.SqlConnection();
conn2.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn2.Open();
SqlCommand command2 = new SqlCommand("spOperacionesPasajeros", conn2);
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.AddWithValue("IdOperacion", Convert.ToInt32(paramCodRetorno.SqlValue.ToString()));
command2.Parameters.AddWithValue("IdPasajero", Convert.ToInt32(paramCodRetorno1.SqlValue.ToString()));
command2.ExecuteNonQuery();
adapter = new SqlDataAdapter(command2);
adapter.Fill(ds);
conn2.Close();
ds.Dispose();
}
}
//}
}
if ((dsProducto != null) && (dsProducto.Tables[0].Rows.Count > 0))
{
for (int z = 0; z < dsProducto.Tables[0].Rows.Count; z++)
{
System.Data.SqlClient.SqlConnection conn3;
conn3 = new System.Data.SqlClient.SqlConnection();
conn3.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn3.Open();
SqlCommand command3 = new SqlCommand("spOperacionesProductosAdicionales", conn3);
command3.CommandType = CommandType.StoredProcedure;
command3.Parameters.AddWithValue("IdOperacion", Convert.ToInt32(paramCodRetorno.SqlValue.ToString()));
command3.Parameters.AddWithValue("IdProducto", Convert.ToInt32(dsProducto.Tables[0].Rows[z]["IdProductos"].ToString()));
command3.Parameters.AddWithValue("IdProveedor", Convert.ToInt32(dsProveedor.Tables[0].Rows[z]["IdProveedor"].ToString()));
command3.Parameters.AddWithValue("ImporteTarifa", Convert.ToDecimal(dsPrecioPesos.Tables[0].Rows[z]["PrecioPesos"].ToString()));
command3.Parameters.AddWithValue("IdMoneda", Convert.ToInt32(1));
command3.Parameters.AddWithValue("Cantidad", Convert.ToInt32(dsCantidad.Tables[0].Rows[z]["Cantidad"].ToString()));
command3.ExecuteNonQuery();
adapter = new SqlDataAdapter(command3);
adapter.Fill(dsProducto);
conn3.Close();
dsProducto.Dispose();
}
}
}
}
cargarvinculos(dsViajeros, IdOperacionRetorno);
dsFormaPago.Dispose();
dsFactura.Dispose();
dsViajeros.Dispose();
dsOtraInfo.Dispose();
dsInfoEmergencia.Dispose();
dsProducto.Dispose();
dsProveedor.Dispose();
dsCantidad.Dispose();
dsPrecioPesos.Dispose();
dsPrecioDolar.Dispose();
dsDatosViaje.Dispose();
muestrareporte(IdOperacionRetorno);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
private JObject RetornaMovimentos(MP m, Int32 offset)
{
// Sets the filters you want
Dictionary<String, String> filters = new Dictionary<String, String>();
filters.Add("site_id", "MLB"); // Argentina: MLA; Brasil: MLB
return m.searchPayment(filters, offset, 0);
}