private void Agregar_Cliente_Load(object sender, EventArgs e)
{
Pedir_Dni form = new Pedir_Dni();
form.ShowDialog();
this.txtDni.Text = form.dniIngresado;
llenarDatos(this.txtDni.Text);
try
{
using (SqlCommand cmd = new SqlCommand("BONDIOLA.listarButacasLibres", conn, ts))
{
cmd.CommandType = CommandType.StoredProcedure;
SQL_Library.agregarParametro(cmd, "@codigoViaje", codigoViaje);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable tabla = new DataTable();
da.Fill(tabla);
dgButacas.DataSource = tabla;
dgButacas.Refresh();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnComprar_Click(object sender, EventArgs e)
{
if (chkEncomienda.Checked)
{
if (String.IsNullOrEmpty(this.txtDniEncomienda.Text))
{
MessageBox.Show("Ingrese un DNI para la encomienda.");
return;
}
try
{
using (SqlCommand cmd = new SqlCommand("BONDIOLA.crearEncomienda", conn, ts))
{
cmd.CommandType = CommandType.StoredProcedure;
SQL_Library.agregarParametro(cmd, "@voucher", this.numeroVoucher);
SQL_Library.agregarParametro(cmd, "@peso", this.nudKg.Value);
SQL_Library.agregarParametro(cmd, "@dniCliente", this.txtDniEncomienda.Text);
SQL_Library.agregarParametro(cmd, "@codigoViaje", this.codigoViaje);
SQL_Library.agregarParametro(cmd, "@puntosAcumulados", Math.Round(this.nudMontoKg.Value/5));
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
if (pagoConTarjeta)
new Checkout(this.nudTotal.Value, this.numeroVoucher, conn, ts).ShowDialog();
else
{
if(MessageBox.Show("El pago es con tarjeta de crédito?","Consulta",MessageBoxButtons.YesNo) == DialogResult.Yes){
new Checkout(this.nudTotal.Value, this.numeroVoucher, conn, ts).ShowDialog();
} else
{
Pedir_Dni form = new Pedir_Dni();
form.ShowDialog();
String dniPagador = form.dniIngresado;
try
{
using (SqlCommand cmd = new SqlCommand("BONDIOLA.actualizarCompra", conn, ts))
{
cmd.CommandType = CommandType.StoredProcedure;
SQL_Library.agregarParametro(cmd, "@voucher", this.numeroVoucher);
SQL_Library.agregarParametro(cmd, "@dniPagador", dniPagador);
SQL_Library.agregarParametro(cmd, "@tipoPago", "Efectivo");
SQL_Library.agregarParametro(cmd, "@monto", this.nudTotal.Value);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
this.Close();
}