private void emitirBoleta_Click(object sender, EventArgs e)
{
this.Hide();
gestionCarta gC = new gestionCarta();
gC.Show();
}
private void materialFlatButton3_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || comboBox1.Text == "")
{
MessageBox.Show("No puede dejar ningun dato vacio");
}
else if (comboBox1.Text == "Comida")
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
String sql;
sql = "insert into comida values('" + textBox1.Text + "'," + textBox3.Text + ",'" + textBox2.Text + "',1)";
command = new SqlCommand(sql, BD.cnn);
adapter.InsertCommand = new SqlCommand(sql, BD.cnn);
adapter.InsertCommand.ExecuteNonQuery();
MessageBox.Show("Insertado Correctamente");
}
else if (comboBox1.Text == "Bebida")
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
String sql;
sql = "insert into bebida values('" + textBox1.Text + "'," + textBox3.Text + ",'" + textBox2.Text + "',1)";
command = new SqlCommand(sql, BD.cnn);
adapter.InsertCommand = new SqlCommand(sql, BD.cnn);
adapter.InsertCommand.ExecuteNonQuery();
MessageBox.Show("Insertado Correctamente");
}
BD.cnn.Close();
gestionCarta gC2 = new gestionCarta();
this.Hide();
gC2.Show();
}
private void materialFlatButton2_Click(object sender, EventArgs e)
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
String sql;
if (comida)
{
if (materialRadioButton1.Checked == true)
{
sql = "update comida set nombre = '" + textBox1.Text + "', precio= '" + textBox3.Text + "', descripcion= '" + textBox2.Text + "', estado = 1 where id = " + identificador;
}
else
{
sql = "update comida set nombre = '" + textBox1.Text + "', precio= '" + textBox3.Text + "', descripcion= '" + textBox2.Text + "', estado = 0 where id = " + identificador;
}
}
else
{
if (materialRadioButton1.Checked == true)
{
sql = "update bebida set nombre = '" + textBox1.Text + "', precio= '" + textBox3.Text + "', descripcion= '" + textBox2.Text + "', estado = 1 where id = " + identificador;
}
else
{
sql = "update bebida set nombre = '" + textBox1.Text + "', precio= '" + textBox3.Text + "', descripcion= '" + textBox2.Text + "', estado = 0 where id = " + identificador;
}
}
command = new SqlCommand(sql, BD.cnn);
adapter.UpdateCommand = new SqlCommand(sql, BD.cnn);
adapter.UpdateCommand.ExecuteNonQuery();
command.Dispose();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
materialRadioButton1.Hide();
materialRadioButton2.Hide();
materialFlatButton2.Hide();
dataGridView1.RefreshEdit();
MessageBox.Show("Modificado Correctamente");
BD.cnn.Close();
gestionCarta gC2 = new gestionCarta();
this.Hide();
gC2.Show();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "Ver")
{
materialFlatButton2.Hide();
string ident = "0";
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
ident = row.Cells[0].Value.ToString();
}
SqlCommand command;
String sql;
SqlDataReader dataReader;
sql = "select nombre, descripcion,precio,estado from comida where id = '" + ident + "'";
command = new SqlCommand(sql, BD.cnn);
dataReader = command.ExecuteReader();
dataReader.Read();
textBox1.Text = dataReader.GetValue(0).ToString();
textBox2.Text = dataReader.GetValue(1).ToString();
textBox3.Text = dataReader.GetValue(2).ToString();
materialLabel4.Show();
if (dataReader.GetValue(3).ToString() == "True")
{
materialRadioButton2.Hide();
materialRadioButton1.Show();
materialRadioButton1.Checked = true;
}
else if (dataReader.GetValue(3).ToString() == "False")
{
materialRadioButton1.Hide();
materialRadioButton2.Show();
materialRadioButton2.Checked = true;
}
comboBox1.SelectedItem = "Comida";
dataReader.Close();
}
else if (dataGridView1.Columns[e.ColumnIndex].Name == "Modificar")
{
materialFlatButton2.Show();
comida = true;
string ident = "0";
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
ident = row.Cells[0].Value.ToString();
identificador = ident;
}
materialLabel4.Show();
SqlCommand command;
String sql;
SqlDataReader dataReader;
sql = "select nombre, descripcion,precio,estado from comida where id = '" + ident + "'";
command = new SqlCommand(sql, BD.cnn);
dataReader = command.ExecuteReader();
dataReader.Read();
textBox1.Text = dataReader.GetValue(0).ToString();
textBox2.Text = dataReader.GetValue(1).ToString();
textBox3.Text = dataReader.GetValue(2).ToString();
comboBox1.SelectedItem = "Comida";
materialRadioButton1.Show();
materialRadioButton2.Show();
if (dataReader.GetValue(3).ToString() == "True")
{
materialRadioButton1.Checked = true;
}
else if (dataReader.GetValue(3).ToString() == "False")
{
materialRadioButton2.Checked = true;
}
dataReader.Close();
}
else if (dataGridView1.Columns[e.ColumnIndex].Name == "Eliminar")
{
string ident = "0";
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
ident = row.Cells[0].Value.ToString();
}
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
String sql = "delete from comida where id = " + ident;
command = new SqlCommand(sql, BD.cnn);
adapter.DeleteCommand = new SqlCommand(sql, BD.cnn);
adapter.DeleteCommand.ExecuteNonQuery();
MessageBox.Show("Borrado Exitosamente");
BD.cnn.Close();
gestionCarta gC2 = new gestionCarta();
this.Hide();
gC2.Show();
}
}
