public static Cont findUser(Cont obj) { Cont c = null; c = (Cont)ReflectionDAO.select(obj, "Cont"); return(c); }
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()); } }
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"))); }
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"); }