private void listBoxPreparate_SelectedIndexChanged(object sender, EventArgs e) { if (listBoxPreparate.SelectedIndex >= 0) { try { clearListIngrediente(); clearTextBoxPrep(); clearComboPrep(); conn = new SqlConnection(); conn.ConnectionString = sqlConnection1.ConnectionString; SqlDataAdapter dp = new SqlDataAdapter(); dp.SelectCommand = new SqlCommand("select codP, codC, numeP, pret, timp_preparare from Preparate", conn); DataSet prep = new DataSet(); dp.Fill(prep, "preparate"); SqlDataAdapter di = new SqlDataAdapter(); di.SelectCommand = new SqlCommand("select i.numeI, r.cantitate from Retete r, Ingrediente i where r.codI=i.codI and codP=@codP", conn); DataRowCollection dc = prep.Tables["preparate"].Rows; Preparat p = new Preparat(); string s = listBoxPreparate.SelectedItem.ToString(); string[] fields = s.Split('\t'); p.numeP = fields[0]; p.pret = float.Parse(fields[1]); p.timp_prep = Convert.ToInt32(fields[2]); foreach (DataRow d in dc) { if (d["numeP"].ToString() == p.numeP) { textBoxNumeP.Text = p.numeP; textBoxPretP.Text = p.pret.ToString(); textBoxTimpP.Text = p.timp_prep.ToString(); di.SelectCommand.Parameters.AddWithValue("codP", d["codP"]); break; } } DataSet ingr = new DataSet(); di.Fill(ingr, "ingrediente"); dc = ingr.Tables["ingrediente"].Rows; foreach (DataRow d in dc) { string[] row = { d["numeI"].ToString(), d["cantitate"].ToString() }; var item = new ListViewItem(row); listViewReteta.Items.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { clearTextBoxPrep(); } }
private void comboBoxCategorii_SelectedIndexChanged(object sender, EventArgs e) { try { clearTextBoxPrep(); clearListIngrediente(); clearComboPrep(); conn = new System.Data.SqlClient.SqlConnection(); conn.ConnectionString = sqlConnection1.ConnectionString; conn.Open(); cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select numeP, pret, timp_preparare from Preparate where codC in (select codC from Categorii where numeC = @numeC)"; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "numeC"; if (comboBoxCategorii.SelectedIndex >= 0) { p1.Value = comboBoxCategorii.SelectedItem.ToString(); } else { MessageBox.Show("Nicio categorie selectata.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } cmd.Parameters.Clear(); cmd.Parameters.Add(p1); SqlDataReader dr; dr = cmd.ExecuteReader(); clearListBoxPreparate(); while (dr.Read()) { Preparat p = new Preparat(); p.numeP = dr.GetString(0); p.pret = (float)dr.GetDouble(1); p.timp_prep = dr.GetInt32(2); listBoxPreparate.Items.Add(p); } dr.Close(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void listBoxPreparate_SelectedIndexChanged(object sender, EventArgs e) { if (listBoxPreparate.SelectedIndex >= 0) { try { clearListIngrediente(); clearTextBoxPrep(); clearComboPrep(); conn = new SqlConnection(); conn.ConnectionString = sqlConnection1.ConnectionString; SqlDataAdapter dp = new SqlDataAdapter(); dp.SelectCommand = new SqlCommand("select codP, codC, numeP, pret, timp_preparare from Preparate", conn); DataSet prep = new DataSet(); dp.Fill(prep, "preparate"); SqlDataAdapter di = new SqlDataAdapter(); di.SelectCommand = new SqlCommand("select i.numeI, r.cantitate from Retete r, Ingrediente i where r.codI=i.codI and codP=@codP", conn); DataRowCollection dc = prep.Tables["preparate"].Rows; Preparat p = new Preparat(); string s = listBoxPreparate.SelectedItem.ToString(); string[] fields = s.Split('\t'); p.numeP = fields[0]; p.pret = float.Parse(fields[1]); p.timp_prep = Convert.ToInt32(fields[2]); foreach (DataRow d in dc) if (d["numeP"].ToString() == p.numeP) { textBoxNumeP.Text = p.numeP; textBoxPretP.Text = p.pret.ToString(); textBoxTimpP.Text = p.timp_prep.ToString(); di.SelectCommand.Parameters.AddWithValue("codP", d["codP"]); break; } DataSet ingr = new DataSet(); di.Fill(ingr, "ingrediente"); dc = ingr.Tables["ingrediente"].Rows; foreach (DataRow d in dc) { string[] row = { d["numeI"].ToString(), d["cantitate"].ToString() }; var item = new ListViewItem(row); listViewReteta.Items.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else clearTextBoxPrep(); }
private void comboBoxCategorii_SelectedIndexChanged(object sender, EventArgs e) { try { clearTextBoxPrep(); clearListIngrediente(); clearComboPrep(); conn = new System.Data.SqlClient.SqlConnection(); conn.ConnectionString = sqlConnection1.ConnectionString; conn.Open(); cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select numeP, pret, timp_preparare from Preparate where codC in (select codC from Categorii where numeC = @numeC)"; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "numeC"; if (comboBoxCategorii.SelectedIndex >= 0) p1.Value = comboBoxCategorii.SelectedItem.ToString(); else MessageBox.Show("Nicio categorie selectata.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmd.Parameters.Clear(); cmd.Parameters.Add(p1); SqlDataReader dr; dr = cmd.ExecuteReader(); clearListBoxPreparate(); while (dr.Read()) { Preparat p = new Preparat(); p.numeP = dr.GetString(0); p.pret = (float)dr.GetDouble(1); p.timp_prep = dr.GetInt32(2); listBoxPreparate.Items.Add(p); } dr.Close(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }