Пример #1
0
 private void aflaValoareTotalaToolStripMenuItem_Click(object sender, EventArgs e)
 {
     if (listView1.SelectedItems.Count > 0)
     {
         ListViewItem rand   = listView1.SelectedItems[0];
         Produs       produs = (Produs)rand.Tag;
         MessageBox.Show(string.Format("Valoarea totala a produsului selectat este de: {0} ron ", (decimal)produs));
     }
 }
Пример #2
0
 private void modificareToolStripMenuItem_Click(object sender, EventArgs e)
 {
     if (listView1.SelectedItems.Count > 0)
     {
         ListViewItem rand     = listView1.SelectedItems[0];
         Produs       produs   = (Produs)rand.Tag;
         Form2        formular = new Form2(produs, true, false);
         formular.ShowDialog();
         listView1.Items.Clear();
         AfisareProduse();
     }
 }
Пример #3
0
        private void stergereToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count > 0)
            {
                ListViewItem rand   = listView1.SelectedItems[0];
                Produs       produs = (Produs)rand.Tag;

                DbProviderFactory factory = DbProviderFactories.GetFactory(providerName);
                using (DbConnection connection = factory.CreateConnection())
                {
                    connection.ConnectionString = connString;
                    connection.Open();
                    DbCommand delete = connection.CreateCommand();
                    delete.CommandText = "DELETE FROM Produse WHERE Id=" + produs.Id;
                    delete.ExecuteNonQuery();
                }
                listView1.Items.RemoveAt(rand.Index);
            }
        }
Пример #4
0
        private void AfisareProduse()
        {
            List <Produs>     produse = new List <Produs>();
            DbProviderFactory factory = DbProviderFactories.GetFactory(providerName);

            using (DbConnection connection = factory.CreateConnection())
            {
                connection.ConnectionString = connString;
                connection.Open();

                DbCommand cmdSelect = connection.CreateCommand();
                cmdSelect.CommandText = "SELECT * FROM Produse";
                using (DbDataReader reader = cmdSelect.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Produs produs = new Produs(
                            reader.GetInt32(0),
                            reader.GetString(1),
                            reader.GetInt32(2),
                            reader.GetDecimal(3),
                            reader.GetInt32(4));
                        produse.Add(produs);
                    }
                }
            }

            produse.Sort();
            foreach (Produs produs in produse)
            {
                ListViewItem rand = new ListViewItem();
                rand.Text = produs.Id.ToString();
                rand.SubItems.Add(produs.Nume);
                rand.SubItems.Add(produs.Unitati.ToString());
                rand.SubItems.Add(produs.Pret.ToString());
                rand.SubItems.Add(produs.FurnizorId.ToString());
                rand.Tag = produs;
                listView1.Items.Add(rand);
            }

            //filtrare
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 1))
            {
                nrFurnizor1++;
            }
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 2))
            {
                nrFurnizor2++;
            }
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 3))
            {
                nrFurnizor3++;
            }
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 5))
            {
                nrFurnizor5++;
            }
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 6))
            {
                nrFurnizor6++;
            }
            foreach (Produs produs in produse.Where(x => x.FurnizorId == 7))
            {
                nrFurnizor7++;
            }
        }