private void btnInapoi_Click(object sender, EventArgs e) { this.Hide(); var MeniuPersonal = new MeniuPersonalRestaurant_Meniuri(ContPersonal); MeniuPersonal.ShowDialog(); this.Close(); }
private void btn_meniuri_Click_1(object sender, EventArgs e) { this.Hide(); var vizualizareMeniu = new MeniuPersonalRestaurant_Meniuri(cont); vizualizareMeniu.ShowDialog(); this.Close(); }
private void btn_salveaza_Click_1(object sender, EventArgs e) { String numeMeniu = txtNume.Text; String pret = txtPret.Text; lblErrorNume.Text = ""; lblErrorPret.Text = ""; if (numeMeniu == "") { lblErrorNume.Text = "Denumirea meniului este obligatorie!"; } else if (pret == "") { lblErrorNume.Text = "Pretul meniului este obligatorie!"; } else { // TO TO: Inregistrarea noului utilizator OleDbCommand cmdSelect, cmdInsert, cmdInsertDetalii; string insert, insertDetalii; OleDbDataReader reader; insert = "INSERT INTO Meniu([NumeMeniu],[Pret]) VALUES ('" + txtNume.Text + "','" + txtPret.Text + "')"; cmdInsert = new OleDbCommand(insert, conn); OleDbDataAdapter adapter = new OleDbDataAdapter(); try { // inserarea in meniu conn.Open(); adapter.InsertCommand = new OleDbCommand(insert, conn); adapter.InsertCommand.ExecuteNonQuery(); cmdInsert.Dispose(); // inserarea in meniuPreparat cmdSelect = new OleDbCommand("SELECT idMeniu FROM Meniu where Meniu.idMeniu = @Meniu", conn); cmdSelect.Parameters.AddWithValue("@Meniu", this.txtNume.Text); reader = cmdSelect.ExecuteReader(); reader.Read(); /* * var contMeniu = reader.GetValue(0); * * int numar = chLB_preparate.CheckedItems.Count; * for(int i =0; i<=numar; i++) * { * insertDetalii = "INSERT INTO MeniuPreparate([idMeniu],[idPreparat]) VALUES ('" + contMeniu + "' , '" + chLB_preparate.CheckedItems[i] + "')"; * cmdInsertDetalii = new OleDbCommand(insertDetalii, conn); * adapter.InsertCommand = new OleDbCommand(insertDetalii, conn); * adapter.InsertCommand.ExecuteNonQuery(); * cmdInsertDetalii.Dispose(); * } */ MessageBox.Show("Meniul a fost adaugat!"); conn.Close(); //deschidere meniu this.Hide(); var meniu = new MeniuPersonalRestaurant_Meniuri(ContPersonal); meniu.ShowDialog(); this.Close(); } catch (OleDbException ex) { MessageBox.Show(ex.Message); } } }