private void GenerarReservaButton_Click(object sender, EventArgs e)
{
FormGenerarReserva r = new FormGenerarReserva();
this.Hide();
r.ShowDialog();
this.Close();
}
private void GenerarReservaButton_Click(object sender, EventArgs e)
{
FormGenerarReserva r = new FormGenerarReserva();
this.Hide();
r.ShowDialog();
this.Close();
}
private void modificarButton_Click(object sender, EventArgs e)
{
conexion.Open();
string id = "SELECT ID_Cliente " +
"FROM AEFI.TL_Reserva " +
"WHERE ID_Reserva = " + BaseDeDatos.agregarApostrofos(txbCodigoReserva.Text);
SqlCommand comando = new SqlCommand(id, conexion);
SqlDataReader reader = comando.ExecuteReader();
reader.Read();
idCliente = Convert.ToInt32(reader[0]);
conexion.Close();
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
FormGenerarReserva alta = new FormGenerarReserva(idCliente, Convert.ToInt32(txbCodigoReserva.Text), row.Cells);
this.Hide();
alta.ShowDialog();
this.Close();
}
}
private void modificarButton_Click(object sender, EventArgs e)
{
conexion.Open();
string id = "SELECT ID_Cliente " +
"FROM AEFI.TL_Reserva " +
"WHERE ID_Reserva = " + BaseDeDatos.agregarApostrofos(txbCodigoReserva.Text);
SqlCommand comando = new SqlCommand(id, conexion);
SqlDataReader reader = comando.ExecuteReader();
reader.Read();
idCliente = Convert.ToInt32(reader[0]);
conexion.Close();
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
FormGenerarReserva alta = new FormGenerarReserva(idCliente,Convert.ToInt32(txbCodigoReserva.Text) ,row.Cells);
this.Hide();
alta.ShowDialog();
this.Close();
}
}
private void CrearButton_Click(object sender, EventArgs e)
{
if (verificarTextBoxNoVacios())
{
try
{
conexion.Open();
if (x == 0)
{
SqlCommand comando = new SqlCommand("AEFI.insertar_cliente", conexion);
comando.CommandType = CommandType.StoredProcedure;
aniadirParametros(comando);
}
else if (x == 1)
{
SqlCommand comando = new SqlCommand("AEFI.actualizar_cliente", conexion);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.Add(new SqlParameter("@ID_Cliente", id_cliente));
aniadirParametros(comando);
}
else if (x == 2)
{
SqlCommand comando = new SqlCommand("AEFI.insertar_cliente", conexion);
comando.CommandType = CommandType.StoredProcedure;
aniadirParametros(comando);
string consultaID = "SELECT ID_Cliente "
+ "FROM AEFI.TL_Cliente "
+ "WHERE Mail = " + BaseDeDatos.agregarApostrofos(txbMail.Text);//ya que no hay 2 mails iguales
SqlCommand comandoId = new SqlCommand(consultaID, conexion);
SqlDataReader readerId = comandoId.ExecuteReader();
readerId.Read();
int id = Convert.ToInt32(readerId[0]);
readerId.Close();
string cantidadDeClientes = "SELECT COUNT(ID_Cliente) " +
"FROM AEFI.TL_Cliente ";
//perdon Esme la costumbre gana, tengo que crear otro commando :P
SqlCommand comandoCant = new SqlCommand(cantidadDeClientes, conexion);
SqlDataReader readerCant = comandoCant.ExecuteReader();
readerCant.Read();
int cantDeClientesDespues = Convert.ToInt32(readerCant[0]);
if (cantDeClientesAntes != cantDeClientesDespues)
{//significa que si se ingreso un cliente
FormGenerarReserva r = new FormGenerarReserva(id);
this.Hide();
r.ShowDialog();
this.Close();
}
else
{
FormMenu m = new FormMenu();
this.Hide();
m.ShowDialog();
this.Close();
}
}
}
catch (Excepciones exc)
{
MessageBox.Show(exc.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conexion.Close();
FormMenu m = new FormMenu();
this.Hide();
m.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("Debe completar todos los campos", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}