public static Cont findUser(Cont obj)
        {
            Cont c = null;

            c = (Cont)ReflectionDAO.select(obj, "Cont");
            return(c);
        }
Beispiel #2
0
 public void populateComboBox()
 {
     categorii = ReflectionDAO.createListOfObjects("select * from CategoriiProdus", "CategoriiProdus");
     comboBoxCategorie.Items.Add("Toate");
     for (int i = 0; i < categorii.Count; i++)
     {
         comboBoxCategorie.Items.Add(((CategoriiProdus)categorii[i]).Categorie.ToString());
     }
 }
Beispiel #3
0
 public void selectDetaliiComanda(DetaliiComanda dc)
 {
     ReflectionDAO.select(dc, "DetaliiComanda");
 }
 public static void deleteClient(Client client)
 {
     ReflectionDAO.delete(client, "Client");
 }
 public static void updateClient(Client clientModificat, Client clientOriginal)
 {
     ReflectionDAO.update(clientModificat, clientOriginal, "Client");
 }
 public static void insertClient(Client c)
 {
     ReflectionDAO.insert(c, "Client");
 }
        public void deseneazaForme()
        {
            stackPanel.Children.Clear();

            categorii = ReflectionDAO.createListOfObjects("select * from CategoriiProdus", "CategoriiProdus");

            if (categorieProdusValue == "Toate")
            {
                produse = ReflectionDAO.createListOfObjects("select * from Produs", "Produs");
            }
            else
            {
                produse = ReflectionDAO.createListOfObjects("select * from Produs where categorie = '" + categorieProdusValue + "'", "Produs");
            }

            nrProduse = produse.Count();

            canvas          = new Canvas[nrProduse];
            categorie       = new Label[nrProduse];
            dateProdus      = new Label[nrProduse];
            descriere       = new TextBox[nrProduse];
            detaliu         = new Label[nrProduse];
            cantitateProdus = new TextBox[nrProduse];
            btnProdus       = new Button[nrProduse];

            index = 0;

            int height = 15;

            for (int i = 0; i < nrProduse; i++)
            {
                if (categorieProdusValue == "Toate" || ((Produs)produse[i]).Categorie == categorieProdusValue)
                {
                    canvas[i] = new Canvas();
                    stackPanel.Children.Add(canvas[i]);
                    canvas[i].Width  = 650;
                    canvas[i].Height = 100;
                    canvas[i].Margin = new Thickness(0, height, 0, 0);
                    //height += 100 + 15;
                    canvas[i].Background          = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                    canvas[i].Visibility          = Visibility.Visible;
                    canvas[i].HorizontalAlignment = HorizontalAlignment.Left;
                    canvas[i].VerticalAlignment   = VerticalAlignment.Top;

                    //label categorie
                    categorie[i] = new Label();
                    canvas[i].Children.Add(categorie[i]);
                    categorie[i].Width      = 90;
                    categorie[i].Margin     = new Thickness(5, 37, 0, 0);
                    categorie[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    categorie[i].FontFamily = new FontFamily("Times New Roman");
                    categorie[i].FontSize   = 14;
                    categorie[i].Content    = ((Produs)produse[i]).Categorie.ToString();
                    categorie[i].HorizontalContentAlignment = HorizontalAlignment.Center;

                    //bara verticala
                    Border b = new Border();
                    canvas[i].Children.Add(b);
                    b.Height          = 80;
                    b.Width           = 3;
                    b.BorderThickness = new Thickness(2);
                    b.BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    b.Margin          = new Thickness(100, 10, 0, 0);

                    //date produs
                    dateProdus[i] = new Label();
                    canvas[i].Children.Add(dateProdus[i]);
                    dateProdus[i].Margin     = new Thickness(120, 10, 0, 0);
                    dateProdus[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    dateProdus[i].FontFamily = new FontFamily("Times New Roman");
                    dateProdus[i].FontSize   = 14;
                    dateProdus[i].Content    = ((Produs)produse[i]).Nume.ToString();
                    dateProdus[i].FontWeight = FontWeights.Bold;

                    //descriere produs
                    descriere[i] = new TextBox();
                    canvas[i].Children.Add(descriere[i]);
                    descriere[i].Margin              = new Thickness(120, 35, 0, 0);
                    descriere[i].Background          = new SolidColorBrush(Color.FromArgb(0, 0, 0, 0));
                    descriere[i].Foreground          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    descriere[i].BorderThickness     = new Thickness(0);
                    descriere[i].Width               = 290;
                    descriere[i].Height              = 55;
                    descriere[i].Text                = "(" + ((Produs)produse[i]).Descriere.ToString() + ")";
                    descriere[i].HorizontalAlignment = HorizontalAlignment.Stretch;
                    descriere[i].VerticalAlignment   = VerticalAlignment.Stretch;
                    descriere[i].TextWrapping        = TextWrapping.Wrap;

                    //detaliu
                    detaliu[i] = new Label();
                    canvas[i].Children.Add(detaliu[i]);
                    detaliu[i].Width      = 125;
                    detaliu[i].Margin     = new Thickness(440, 28, 0, 0);
                    detaliu[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    detaliu[i].FontFamily = new FontFamily("Times New Roman");
                    detaliu[i].FontSize   = 14;
                    detaliu[i].Content    = ((Produs)produse[i]).Gramaj.ToString() + " grame \n" + ((Produs)produse[i]).Pret.ToString() + " lei";
                    //btnCumparaturi[i].Click += istoricCumparaturi_Click;

                    //caseta cantitate
                    Border b2 = new Border();
                    canvas[i].Children.Add(b2);
                    b2.Width                                      = 60;
                    b2.Height                                     = 30;
                    b2.BorderThickness                            = new Thickness(2);
                    b2.CornerRadius                               = new CornerRadius(15);
                    b2.BorderBrush                                = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    b2.Margin                                     = new Thickness(560, 15, 0, 0);
                    b2.ToolTip                                    = "Cantitate produs";
                    cantitateProdus[i]                            = new TextBox();
                    b2.Child                                      = cantitateProdus[i];
                    cantitateProdus[i].Margin                     = new Thickness(10, 0, 10, 0);
                    cantitateProdus[i].Background                 = new SolidColorBrush(Color.FromArgb(0, 0, 0, 0));
                    cantitateProdus[i].Foreground                 = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    cantitateProdus[i].BorderThickness            = new Thickness(0);
                    cantitateProdus[i].FontFamily                 = new FontFamily("Times New Roman");
                    cantitateProdus[i].FontSize                   = 14;
                    cantitateProdus[i].ToolTip                    = "Cantitate produs";
                    cantitateProdus[i].HorizontalContentAlignment = HorizontalAlignment.Center;
                    cantitateProdus[i].VerticalContentAlignment   = VerticalAlignment.Center;

                    btnProdus[i] = new Button();
                    canvas[i].Children.Add(btnProdus[i]);
                    btnProdus[i].Width  = 60;
                    btnProdus[i].Height = 30;
                    btnProdus[i].Style  = this.Resources["btnGlass"] as Style;
                    //btnProdus[i].BorderThickness = new Thickness(4);
                    btnProdus[i].BorderBrush = btnProdus[i].Background = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    btnProdus[i].Foreground  = new SolidColorBrush(Color.FromRgb(255, 229, 195));
                    btnProdus[i].Name        = "btnProdus" + i.ToString();
                    btnProdus[i].Content     = "Add";
                    btnProdus[i].FontStyle   = FontStyles.Italic;
                    btnProdus[i].Margin      = new Thickness(560, 55, 0, 0);
                    btnProdus[i].Cursor      = Cursors.Hand;
                    btnProdus[i].ToolTip     = "Adaugă în coș";
                    btnProdus[i].Click      += addToCart_Click;
                }
            }
        }
        public void deseneazaForme()
        {
            stackPanel.Children.Clear();

            conturi = ReflectionDAO.createListOfObjects("select * from Cont where username not in ('admin')", "Cont");
            clienti = ReflectionDAO.createListOfObjects("select * from Client order by username", "Client");

            nrConturi        = conturi.Count;
            canvas           = new Canvas[nrConturi];
            fidelitate       = new Image[nrConturi];
            btnCont          = new Button[nrConturi];
            btnCumparaturi   = new Button[nrConturi];
            dataUser         = new Label[nrConturi];
            adresaUser       = new Label[nrConturi];
            telefonEmailUser = new Label[nrConturi];

            index = 0;

            int height = 15;

            for (int i = 0; i < nrConturi; i++)
            {
                canvas[i] = new Canvas();
                stackPanel.Children.Add(canvas[i]);
                canvas[i].Width  = 800;
                canvas[i].Height = 100;
                canvas[i].Margin = new Thickness(15, height, 0, 0);
                //height += 100 + 15;
                canvas[i].Background          = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                canvas[i].Visibility          = Visibility.Visible;
                canvas[i].HorizontalAlignment = HorizontalAlignment.Left;
                canvas[i].VerticalAlignment   = VerticalAlignment.Top;

                //stea pentru fidelitate
                fidelitate[i] = new Image();
                if (((Client)clienti[i]).EClientLoial == 'Y')
                {
                    fidelitate[i].Source = new BitmapImage(new Uri("/Resources/star.png", UriKind.Relative));
                }
                canvas[i].Children.Add(fidelitate[i]);
                fidelitate[i].Margin = new Thickness(25, 25, 0, 0);
                fidelitate[i].Width  = fidelitate[i].Height = 50;

                //bara verticala
                Border b = new Border();
                canvas[i].Children.Add(b);
                b.Height          = 80;
                b.Width           = 3;
                b.BorderThickness = new Thickness(2);
                b.BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                b.Margin          = new Thickness(100, 10, 0, 0);

                //label-uri cu informatii
                dataUser[i] = new Label();
                canvas[i].Children.Add(dataUser[i]);
                dataUser[i].Content             = ((Cont)conturi[i]).Username + ", " + ((Client)clienti[i]).Nume + " " + ((Client)clienti[i]).Prenume;
                dataUser[i].Margin              = new Thickness(120, 10, 0, 0);
                dataUser[i].Foreground          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                dataUser[i].FontFamily          = new FontFamily("Times New Roman");
                dataUser[i].HorizontalAlignment = HorizontalAlignment.Center;
                dataUser[i].FontSize            = 14;

                //adresa
                adresaUser[i] = new Label();
                canvas[i].Children.Add(adresaUser[i]);
                adresaUser[i].Content             = ((Client)clienti[i]).AdresaLivrare;
                adresaUser[i].Margin              = new Thickness(120, 36, 0, 0);
                adresaUser[i].Foreground          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                adresaUser[i].FontFamily          = new FontFamily("Times New Roman");
                adresaUser[i].HorizontalAlignment = HorizontalAlignment.Center;
                adresaUser[i].FontSize            = 14;

                //telefon si email
                telefonEmailUser[i] = new Label();
                canvas[i].Children.Add(telefonEmailUser[i]);
                telefonEmailUser[i].Content             = ((Client)clienti[i]).NrTelefon + ", " + ((Client)clienti[i]).Email;
                telefonEmailUser[i].Margin              = new Thickness(120, 64, 0, 0);
                telefonEmailUser[i].Foreground          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                telefonEmailUser[i].FontFamily          = new FontFamily("Times New Roman");
                telefonEmailUser[i].HorizontalAlignment = HorizontalAlignment.Center;
                telefonEmailUser[i].FontSize            = 14;

                //buton istoric cumparaturi
                btnCumparaturi[i] = new Button();
                canvas[i].Children.Add(btnCumparaturi[i]);
                btnCumparaturi[i].Margin          = new Thickness(600, 10, 0, 0);
                btnCumparaturi[i].Width           = btnCumparaturi[i].Height = 80;
                btnCumparaturi[i].Style           = this.Resources["btnGlass"] as Style;
                btnCumparaturi[i].BorderThickness = new Thickness(4);
                btnCumparaturi[i].BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));

                Uri resourceUri = new Uri("Resources/shoppingHistory.png", UriKind.Relative);
                StreamResourceInfo streamInfo = Application.GetResourceStream(resourceUri);
                BitmapFrame        temp       = BitmapFrame.Create(streamInfo.Stream);
                var brush = new ImageBrush();
                brush.ImageSource            = temp;
                btnCumparaturi[i].Background = brush;
                btnCumparaturi[i].Cursor     = Cursors.Hand;
                btnCumparaturi[i].ToolTip    = "Istoric cumparaturi";
                btnCumparaturi[i].Name       = "btnCumparaturi" + i.ToString();
                btnCumparaturi[i].Click     += istoricCumparaturi_Click;

                //buton modificari cont
                btnCont[i] = new Button();
                canvas[i].Children.Add(btnCont[i]);
                btnCont[i].Margin          = new Thickness(700, 10, 0, 0);
                btnCont[i].Width           = btnCont[i].Height = 80;
                btnCont[i].Style           = this.Resources["btnGlass"] as Style;
                btnCont[i].BorderThickness = new Thickness(4);
                btnCont[i].BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));

                resourceUri           = new Uri("Resources/settings.png", UriKind.Relative);
                streamInfo            = Application.GetResourceStream(resourceUri);
                temp                  = BitmapFrame.Create(streamInfo.Stream);
                brush                 = new ImageBrush();
                brush.ImageSource     = temp;
                btnCont[i].Background = brush;
                btnCont[i].Cursor     = Cursors.Hand;
                btnCont[i].ToolTip    = "Modificari cont";
                btnCont[i].Name       = "btnCont" + i.ToString();
                btnCont[i].Click     += modifConturi_Click;
                //MessageBox.Show(objects.ElementAt(i).ToString());
            }
        }
 public static Produs selectProdus(Produs a)
 {
     return((Produs)ReflectionDAO.select(a, "Produs"));
 }
 public static void insertCategorie(CategoriiProdus obj)
 {
     ReflectionDAO.insert(obj, "CategoriiProdus");
 }
        public void deseneazaForme()
        {
            stackPanel.Children.Clear();

            comenzi = ReflectionDAO.createListOfObjects("select * from Comanda where idClient = " + clientOriginal.IdClient, "Comanda");
            //MessageBox.Show(comenzi.Count.ToString());

            int height    = 15;
            int nrComenzi = comenzi.Count;

            for (int i = 0; i < nrComenzi; i++)
            {
                Canvas canvas = new Canvas();
                stackPanel.Children.Add(canvas);
                canvas.Width  = 800;
                canvas.Height = 35;
                canvas.Margin = new Thickness(15, height, 0, 0);
                //height += 100 + 15;
                //canvas.Background = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                canvas.Background          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                canvas.Visibility          = Visibility.Visible;
                canvas.HorizontalAlignment = HorizontalAlignment.Left;
                canvas.VerticalAlignment   = VerticalAlignment.Top;

                Label label = new Label();
                canvas.Children.Add(label);
                label.Content                  = "#" + ((Comanda)comenzi[i]).IdComanda;
                label.Height                   = 35;
                label.Margin                   = new Thickness(10, 0, 0, 0);
                label.Foreground               = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                label.FontFamily               = new FontFamily("Times New Roman");
                label.HorizontalAlignment      = HorizontalAlignment.Center;
                label.VerticalContentAlignment = VerticalAlignment.Center;
                label.FontSize                 = 14;

                Label data = new Label();
                canvas.Children.Add(data);
                data.Content                  = ((Comanda)comenzi[i]).DataComanda;
                data.Height                   = 35;
                data.Margin                   = new Thickness(200, 0, 0, 0);
                data.Foreground               = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                data.FontFamily               = new FontFamily("Times New Roman");
                data.HorizontalAlignment      = HorizontalAlignment.Center;
                data.VerticalContentAlignment = VerticalAlignment.Center;
                data.FontSize                 = 14;

                Label pret = new Label();
                canvas.Children.Add(pret);
                pret.Content                  = ((Comanda)comenzi[i]).PretTotal + " lei";
                pret.Height                   = 35;
                pret.Margin                   = new Thickness(500, 0, 0, 0);
                pret.Foreground               = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                pret.FontFamily               = new FontFamily("Times New Roman");
                pret.HorizontalAlignment      = HorizontalAlignment.Center;
                pret.VerticalContentAlignment = VerticalAlignment.Center;
                pret.FontSize                 = 14;

                Label plata = new Label();
                canvas.Children.Add(plata);
                plata.Content                  = ((Comanda)comenzi[i]).ModalitatePlata;
                plata.Height                   = 35;
                plata.Margin                   = new Thickness(700, 0, 0, 0);
                plata.Foreground               = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                plata.FontFamily               = new FontFamily("Times New Roman");
                plata.HorizontalAlignment      = HorizontalAlignment.Center;
                plata.VerticalContentAlignment = VerticalAlignment.Center;
                plata.FontSize                 = 14;

                detaliuComanda = ReflectionDAO.createListOfObjects("select * from DetaliiComanda where idComanda = " + ((Comanda)comenzi[i]).IdComanda.ToString(), "DetaliiComanda");
                //MessageBox.Show(detaliuComanda.Count.ToString());
                int nrDetalii = detaliuComanda.Count;

                for (int j = 0; j < nrDetalii; j++)
                {
                    Canvas canvasDetaliu = new Canvas();
                    stackPanel.Children.Add(canvasDetaliu);
                    canvasDetaliu.Width  = 800;
                    canvasDetaliu.Height = 35;
                    canvasDetaliu.Margin = new Thickness(15, height, 0, 0);
                    //height += 100 + 15;
                    canvasDetaliu.Background          = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                    canvasDetaliu.Visibility          = Visibility.Visible;
                    canvasDetaliu.HorizontalAlignment = HorizontalAlignment.Left;
                    canvasDetaliu.VerticalAlignment   = VerticalAlignment.Top;

                    Label labelProdus = new Label();
                    canvasDetaliu.Children.Add(labelProdus);
                    labelProdus.Content                  = ((DetaliiComanda)detaliuComanda[j]).NumeProdus;
                    labelProdus.Height                   = 35;
                    labelProdus.Margin                   = new Thickness(150, 0, 0, 0);
                    labelProdus.Foreground               = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    labelProdus.FontFamily               = new FontFamily("Times New Roman");
                    labelProdus.HorizontalAlignment      = HorizontalAlignment.Center;
                    labelProdus.VerticalContentAlignment = VerticalAlignment.Center;
                    labelProdus.FontSize                 = 14;
                    labelProdus.FontWeight               = FontWeights.Bold;

                    Label labelProdusCantitate = new Label();
                    canvasDetaliu.Children.Add(labelProdusCantitate);
                    labelProdusCantitate.Content                  = ((DetaliiComanda)detaliuComanda[j]).Pret + " x " + ((DetaliiComanda)detaliuComanda[j]).Cantitate + " = " + (((DetaliiComanda)detaliuComanda[j]).Pret * ((DetaliiComanda)detaliuComanda[j]).Cantitate).ToString() + " lei";
                    labelProdusCantitate.Height                   = 35;
                    labelProdusCantitate.Margin                   = new Thickness(550, 0, 0, 0);
                    labelProdusCantitate.Foreground               = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    labelProdusCantitate.FontFamily               = new FontFamily("Times New Roman");
                    labelProdusCantitate.HorizontalAlignment      = HorizontalAlignment.Center;
                    labelProdusCantitate.VerticalContentAlignment = VerticalAlignment.Center;
                    labelProdusCantitate.FontSize                 = 14;
                }
            }
        }
 public static void insertUser(Cont obj)
 {
     //System.Windows.MessageBox.Show("Cont");
     ReflectionDAO.insert(obj, "Cont");
 }
 public static void deleteProdus(Produs produs)
 {
     ReflectionDAO.delete(produs, "Produs");
 }
 public static void updateProdus(Produs produsModificat, Produs produsOriginal)
 {
     ReflectionDAO.update(produsModificat, produsOriginal, "Produs");
 }
 public static CategoriiProdus findCategorie(CategoriiProdus obj)
 {
     return((CategoriiProdus)(ReflectionDAO.select(obj, "CategoriiProdus")));
 }
Beispiel #16
0
        public void deseneazaForme()
        {
            stackPanel.Children.Clear();

            categorii = ReflectionDAO.createListOfObjects("select * from CategoriiProdus", "CategoriiProdus");

            if (categorieProdusValue == "Toate")
            {
                produse = ReflectionDAO.createListOfObjects("select * from Produs", "Produs");
            }
            else
            {
                produse = ReflectionDAO.createListOfObjects("select * from Produs where categorie = '" + categorieProdusValue + "'", "Produs");
            }

            nrProduse = produse.Count();

            canvas     = new Canvas[nrProduse];
            categorie  = new Label[nrProduse];
            dateProdus = new Label[nrProduse];
            descriere  = new TextBox[nrProduse];
            detaliu    = new Label[nrProduse];
            btnProdus  = new Button[nrProduse];

            index = 0;

            int height = 15;

            for (int i = 0; i < nrProduse; i++)
            {
                if (categorieProdusValue == "Toate" || ((Produs)produse[i]).Categorie == categorieProdusValue)
                {
                    canvas[i] = new Canvas();
                    stackPanel.Children.Add(canvas[i]);
                    canvas[i].Width  = 800;
                    canvas[i].Height = 100;
                    canvas[i].Margin = new Thickness(15, height, 0, 0);
                    //height += 100 + 15;
                    canvas[i].Background          = new SolidColorBrush(Color.FromRgb(252, 228, 200));
                    canvas[i].Visibility          = Visibility.Visible;
                    canvas[i].HorizontalAlignment = HorizontalAlignment.Left;
                    canvas[i].VerticalAlignment   = VerticalAlignment.Top;

                    //label categorie
                    categorie[i] = new Label();
                    canvas[i].Children.Add(categorie[i]);
                    categorie[i].Width      = 125;
                    categorie[i].Margin     = new Thickness(20, 37, 0, 0);
                    categorie[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    categorie[i].FontFamily = new FontFamily("Times New Roman");
                    categorie[i].FontSize   = 14;
                    categorie[i].Content    = ((Produs)produse[i]).Categorie.ToString();
                    categorie[i].HorizontalContentAlignment = HorizontalAlignment.Center;

                    //bara verticala
                    Border b = new Border();
                    canvas[i].Children.Add(b);
                    b.Height          = 80;
                    b.Width           = 3;
                    b.BorderThickness = new Thickness(2);
                    b.BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    b.Margin          = new Thickness(150, 10, 0, 0);

                    //date produs
                    dateProdus[i] = new Label();
                    canvas[i].Children.Add(dateProdus[i]);
                    dateProdus[i].Margin     = new Thickness(170, 10, 0, 0);
                    dateProdus[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    dateProdus[i].FontFamily = new FontFamily("Times New Roman");
                    dateProdus[i].FontSize   = 14;
                    dateProdus[i].Content    = ((Produs)produse[i]).Nume.ToString();
                    dateProdus[i].FontWeight = FontWeights.Bold;

                    //descriere produs
                    descriere[i] = new TextBox();
                    canvas[i].Children.Add(descriere[i]);
                    descriere[i].Margin              = new Thickness(170, 35, 0, 0);
                    descriere[i].Background          = new SolidColorBrush(Color.FromArgb(0, 0, 0, 0));
                    descriere[i].Foreground          = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    descriere[i].BorderThickness     = new Thickness(0);
                    descriere[i].Width               = 290;
                    descriere[i].Height              = 55;
                    descriere[i].Text                = "(" + ((Produs)produse[i]).Descriere.ToString() + ")";
                    descriere[i].HorizontalAlignment = HorizontalAlignment.Stretch;
                    descriere[i].VerticalAlignment   = VerticalAlignment.Stretch;
                    descriere[i].TextWrapping        = TextWrapping.Wrap;

                    //detaliu
                    detaliu[i] = new Label();
                    canvas[i].Children.Add(detaliu[i]);
                    detaliu[i].Width      = 125;
                    detaliu[i].Margin     = new Thickness(500, 38, 0, 0);
                    detaliu[i].Foreground = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    detaliu[i].FontFamily = new FontFamily("Times New Roman");
                    detaliu[i].FontSize   = 14;
                    detaliu[i].Content    = ((Produs)produse[i]).Gramaj.ToString() + " grame, " + ((Produs)produse[i]).Pret.ToString() + " lei";

                    //buton modificari cont
                    btnProdus[i] = new Button();
                    canvas[i].Children.Add(btnProdus[i]);
                    btnProdus[i].Margin          = new Thickness(700, 10, 0, 0);
                    btnProdus[i].Width           = btnProdus[i].Height = 80;
                    btnProdus[i].Style           = this.Resources["btnGlass"] as Style;
                    btnProdus[i].BorderThickness = new Thickness(4);
                    btnProdus[i].BorderBrush     = new SolidColorBrush(Color.FromRgb(179, 68, 38));
                    btnProdus[i].Name            = "btnProdus" + i.ToString();
                    btnProdus[i].Click          += produs_Click;

                    Uri resourceUri = new Uri("Resources/settings.png", UriKind.Relative);
                    StreamResourceInfo streamInfo = Application.GetResourceStream(resourceUri);
                    BitmapFrame        temp       = BitmapFrame.Create(streamInfo.Stream);
                    var brush = new ImageBrush();
                    brush.ImageSource       = temp;
                    btnProdus[i].Background = brush;
                    btnProdus[i].Cursor     = Cursors.Hand;
                    btnProdus[i].ToolTip    = "Modificare date produs";
                    btnProdus[i].Name       = "btnProdus" + i.ToString();
                    //btnCumparaturi[i].Click += istoricCumparaturi_Click;
                }
            }
        }
 public static void insertProdus(Produs p)
 {
     ReflectionDAO.insert(p, "Produs");
 }