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());
}
}
