public TOProduct LoadRecent(TOUser user, int recent) { TOProduct i = new TOProduct(); try { string sql = "select * from tbl_product where product_id = (select (max(product_id)-" + recent + ") from tbl_product) and product_status = true;"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); MySqlDataReader dtreader = cmd.ExecuteReader(); while (dtreader.Read()) //If there's any data. { i.Id = dtreader.GetInt16("product_id"); i.Link = dtreader.GetString("product_link"); i.Name = dtreader.GetString("product_name"); i.Type = dtreader.GetString("product_type"); i.Price = dtreader.GetDouble("product_price"); i.Store = dtreader.GetString("product_store"); i.BuyingDate = dtreader.GetDateTime("product_buyingDate").ToString("dd-MM-yyyy"); } con.Close(); } catch (MySqlException e) { throw new Exception(e.Message); } return(i); }
public ACTProductRegistration(TOUser u, TOProduct p) { i = 2; product = p; //setting textboxes. InitializeComponent(); user = u; txtLink.Text = p.Link; txtPrice.Text = p.Price.ToString(); txtProduct.Text = p.Name; txtStore.Text = p.Store; txtType.Text = p.Type; //set comboboxes. if (product.Priority == 1) { cbxPriority.SelectedValue = "Muito baixa"; } else if (product.Priority == 2) { cbxPriority.SelectedValue = "Baixa"; } else if (product.Priority == 3) { cbxPriority.SelectedValue = "Normal"; } else if (product.Priority == 4) { cbxPriority.SelectedValue = "Alta"; } else if (product.Priority == 5) { cbxPriority.SelectedValue = "Muito Alta"; } //setting radioButton. if (product.Status == true) { rdbComprado.IsChecked = true; } else { rdbListaDesejo.IsChecked = true; } //disabling all components. txtLink.IsEnabled = false; txtPrice.IsEnabled = false; txtProduct.IsEnabled = false; txtStore.IsEnabled = false; txtType.IsEnabled = false; cbxPriority.IsEnabled = false; rdbComprado.IsEnabled = false; rdbListaDesejo.IsEnabled = false; btnRegister.IsEnabled = false; btnEdit.Visibility = Visibility.Visible; }
private void lblRecentTitle_3_MouseDown(object sender, MouseButtonEventArgs e) { TOProduct product = new TOProduct(); product = DAOProd.Selection(lblRecentTitle_3.Content.ToString()); ACTProductRegistration pr = new ACTProductRegistration(user, product); pr.ShowDialog(); LoadScreen(user, status); }
private void tblProduct_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (TableValues(1) != null) { TOProduct product = new TOProduct(); product = DAOProd.Selection(TableValues(1)); ACTProductRegistration pr = new ACTProductRegistration(user, product); pr.ShowDialog(); } LoadScreen(user, status); }
private void btnEdit_Click(object sender, RoutedEventArgs e) { if (TableValues(1) != null) { TOProduct product = new TOProduct(); product = DAOProd.Selection(TableValues(1)); ACTProductRegistration pr = new ACTProductRegistration(user, product); pr.ShowDialog(); user = pr.ReturnUser; LoadScreen(user, status); } }
public bool Registration(TOProduct product, TOUser user) { bool i = false; try { string sql = @"insert into tbl_product(product_name, product_status, product_type, product_description, product_link, product_store, product_price, product_buyingDate, user_id, priority_id) values( '" + product.Name + "', " + product.Status + ", '" + product.Type + "', '" + product.Description + "', '" + product.Link + "', '" + product.Store + "', " + product.Price + ", '" + product.BuyingDate + "', " + user.Id + ", " + product.Priority + ");"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); string select = "select * from tbl_product where product_name = '" + product.Name + "';"; con.Open(); MySqlCommand command = new MySqlCommand(select, con); MySqlDataReader dtreader = command.ExecuteReader(); if (dtreader.Read())//If there's any data. { //registration sucessful i = true; } } catch (MySqlException e) { throw new Exception(e.Message); } finally { con.Close(); } return(i); }
public bool UpdateDate(TOProduct product, string date) { bool i = false; try { string sql = @"update tbl_product set product_buyingDate = (REPLACE('" + date + "', '/', '-')) where product_id = " + product.Id + ";"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); string select = "select * from tbl_product where product_id = '" + product.Id + "';"; con.Open(); MySqlCommand command = new MySqlCommand(select, con); MySqlDataReader dtreader = command.ExecuteReader(); if (dtreader.Read())//If there's any data. { //registration sucessful i = true; } } catch (MySqlException e) { throw new Exception(e.Message); } finally { con.Close(); } return(i); }
public bool Update(TOProduct product, TOUser user) { bool i = false; try { string sql = @"update tbl_product set product_id = " + product.Id + ", product_name = '" + product.Name + "', product_status = " + product.Status + ", product_type = '" + product.Type + "', product_description = '', product_link = '" + product.Link + "', product_store = '" + product.Store + "', product_price = " + product.Price + ", user_id = " + user.Id + ", priority_id = " + product.Priority + " where product_id = " + product.Id + ";"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); string select = "select * from tbl_product where product_id = '" + product.Id + "';"; con.Open(); MySqlCommand command = new MySqlCommand(select, con); MySqlDataReader dtreader = command.ExecuteReader(); if (dtreader.Read())//If there's any data. { //registration sucessful i = true; } } catch (MySqlException e) { throw new Exception(e.Message); } finally { con.Close(); } return(i); }
public List <TOProduct> SearchPrice(TOUser user, bool status, double lowPrice, double highPrice) { List <TOProduct> i = new List <TOProduct>(); string sql = @"select * from tbl_product where user_id = " + user.Id + " and product_status = " + status + " and product_price between " + lowPrice + " and " + highPrice + ";"; try { con = ConnectionFactory.Connection(); con.Open(); MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader dtreader = cmd.ExecuteReader(); while (dtreader.Read()) { TOProduct p = new TOProduct(); p.Id = dtreader.GetInt16("product_id"); p.Type = dtreader.GetString("product_type"); p.Name = dtreader.GetString("product_name"); p.Link = dtreader.GetString("product_link"); p.Store = dtreader.GetString("product_store"); p.Price = dtreader.GetDouble("product_price"); p.BuyingDate = dtreader.GetDateTime("product_buyingDate").ToString("dd-MM-yyyy"); i.Add(p); } con.Close(); } catch (MySqlException e) { throw new Exception(e.Message); } return(i); }
public TOProduct Selection(string product) { TOProduct i = new TOProduct(); try { MySqlConnection con = null; string sql = "select * from tbl_product where product_name = '" + product + "';"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); MySqlDataReader dtreader = cmd.ExecuteReader(); while (dtreader.Read())//If there's any data. { i.Id = dtreader.GetInt16("product_id"); i.Link = dtreader.GetString("product_link"); i.Name = dtreader.GetString("product_name"); i.Type = dtreader.GetString("product_type"); i.Price = dtreader.GetDouble("product_price"); i.Priority = dtreader.GetInt16("priority_id"); i.Status = dtreader.GetBoolean("product_status"); i.Store = dtreader.GetString("product_store"); } con.Close(); } catch (MySqlException e) { throw new Exception(e.Message); } return(i); }
public ACTBuyingDate(TOProduct product) { InitializeComponent(); p = product; }
public void LoadMenu() { //load quickmenu informations. TOProduct recent_1 = DAOProd.LoadRecent(user, 0); TOProduct recent_2 = DAOProd.LoadRecent(user, 1); TOProduct recent_3 = DAOProd.LoadRecent(user, 2); if (recent_1.Id == 0) { lblRecentTitle_1.Visibility = Visibility.Hidden; price_1.Visibility = Visibility.Hidden; type_1.Visibility = Visibility.Hidden; img_1.Visibility = Visibility.Hidden; separator_1.Visibility = Visibility.Hidden; date_1.Visibility = Visibility.Hidden; } else { recent_transaction.Visibility = Visibility.Hidden; lblRecentTitle_1.Content = recent_1.Name; price_1.Content = "- R$" + recent_1.Price; type_1.Content = recent_1.Type; date_1.Content = recent_1.BuyingDate; lblRecentTitle_1.Visibility = Visibility.Visible; price_1.Visibility = Visibility.Visible; type_1.Visibility = Visibility.Visible; img_1.Visibility = Visibility.Visible; separator_1.Visibility = Visibility.Visible; date_1.Visibility = Visibility.Visible; btnViewTransactions.Visibility = Visibility.Visible; } if (recent_2.Id == 0) { lblRecentTitle_2.Visibility = Visibility.Hidden; price_2.Visibility = Visibility.Hidden; type_2.Visibility = Visibility.Hidden; img_2.Visibility = Visibility.Hidden; separator_2.Visibility = Visibility.Hidden; date_2.Visibility = Visibility.Hidden; } else { lblRecentTitle_2.Content = recent_2.Name; price_2.Content = "- R$" + recent_2.Price; type_2.Content = recent_2.Type; date_2.Content = recent_2.BuyingDate; lblRecentTitle_2.Visibility = Visibility.Visible; price_2.Visibility = Visibility.Visible; type_2.Visibility = Visibility.Visible; img_2.Visibility = Visibility.Visible; separator_2.Visibility = Visibility.Visible; date_2.Visibility = Visibility.Visible; btnViewTransactions.Visibility = Visibility.Visible; } if (recent_3.Id == 0) { lblRecentTitle_3.Visibility = Visibility.Hidden; price_3.Visibility = Visibility.Hidden; type_3.Visibility = Visibility.Hidden; img_3.Visibility = Visibility.Hidden; separator_3.Visibility = Visibility.Hidden; date_3.Visibility = Visibility.Hidden; } else { lblRecentTitle_3.Content = recent_3.Name; price_3.Content = "- R$" + recent_3.Price; type_3.Content = recent_3.Type; date_3.Content = recent_3.BuyingDate; lblRecentTitle_3.Visibility = Visibility.Visible; price_3.Visibility = Visibility.Visible; type_3.Visibility = Visibility.Visible; img_3.Visibility = Visibility.Visible; separator_3.Visibility = Visibility.Visible; date_3.Visibility = Visibility.Visible; btnViewTransactions.Visibility = Visibility.Visible; } if (recent_1.Id == 0) { if (recent_2.Id == 0) { if (recent_3.Id == 0) { recent_transaction.Visibility = Visibility.Visible; btnViewTransactions.Visibility = Visibility.Hidden; } } } lblMoney.Content = "R$ " + user.CreditAvaliable + ",00"; lblUserName.Content = user.Name + " " + user.SirName; lblEmail.Content = user.Email; //loading configuration information. //loading menu configuration txtAccount.Text = user.Account; txtName.Text = user.Name; ver = txtAccount.Text; txtSirName.Text = user.SirName; txtEmail.Text = user.Email; txtPassword.Text = user.Password; txtCurrentCapital.Text = user.Credit.ToString(); txtTotalSpentCapital.Text = user.CreditSpent.ToString(); psbCurrentPassword.Password = user.Password; PasswordStrengh.Value = (user.verifyPassword(user.Password)); if (PasswordStrengh.Value <= 25) { PasswordStrengh.Foreground = Brushes.Red; } else if (PasswordStrengh.Value <= 50) { PasswordStrengh.Foreground = Brushes.Yellow; } else if (PasswordStrengh.Value >= 75) { PasswordStrengh.Foreground = Brushes.Green; } }
private void btnRegister_Click(object sender, RoutedEventArgs e) { if (i == 1) { if (rdbComprado.IsChecked == true) { product.BuyingDate = "0000-00-00 00:00:00"; Model.DAO.DAOProduct d = new Model.DAO.DAOProduct(); if (d.Registration(product, user)) { product = d.Selection(txtProduct.Text.ToString()); ACTBuyingDate date = new ACTBuyingDate(product); date.ShowDialog(); Model.DAO.DAOUser uDAO = new Model.DAO.DAOUser(); user = uDAO.CreditSpent(user, product.Price); user = uDAO.TotalCredit(user); user = uDAO.Update(user); ACTMessages message = new ACTMessages(user, "eBuy", "Produto registrado com sucesso.", 1); message.ShowDialog(); this.Close(); } else { ACTMessages message = new ACTMessages(user, "eBuy", "Algo errado aconteceu. Por favor, tente novamente mais tarde.", 3); message.ShowDialog(); } } else { product.BuyingDate = "0000-00-00 00:00:00"; Model.DAO.DAOProduct d = new Model.DAO.DAOProduct(); if (d.Registration(product, user)) { ACTMessages message = new ACTMessages(user, "eBuy", "Produto registrado com sucesso.", 1); message.ShowDialog(); this.Close(); } else { ACTMessages message = new ACTMessages(user, "eBuy", "Algo errado aconteceu. Por favor, tente novamente mais tarde.", 3); message.ShowDialog(); } } } else { if (rdbComprado.IsChecked == true) { ACTBuyingDate date = new ACTBuyingDate(product); date.ShowDialog(); Model.DAO.DAOProduct dPRO = new Model.DAO.DAOProduct(); if (dPRO.Update(product, user)) { Model.DAO.DAOUser uDAO = new Model.DAO.DAOUser(); user = uDAO.CreditSpent(user, product.Price); user = uDAO.TotalCredit(user); user = uDAO.Update(user); ACTMessages message = new ACTMessages(user, "eBuy", "Produto atualizado com sucesso.", 1); message.ShowDialog(); this.Close(); } else { ACTMessages message = new ACTMessages(user, "eBuy", "Algo errado aconteceu. Por favor, tente novamente mais tarde.", 3); message.ShowDialog(); } } else { Model.DAO.DAOProduct dPRO = new Model.DAO.DAOProduct(); if (dPRO.Update(product, user)) { ACTMessages message = new ACTMessages(user, "eBuy", "Produto atualizado com sucesso.", 1); message.ShowDialog(); this.Close(); } else { ACTMessages message = new ACTMessages(user, "eBuy", "Algo errado aconteceu. Por favor, tente novamente mais tarde.", 3); message.ShowDialog(); } } } }
public List <TOProduct> LoadProduct(TOUser user, bool status) { List <TOProduct> i = new List <TOProduct>(); try { string sql = "select * from tbl_product where user_id = " + user.Id + " and product_status = " + status + ";"; con = ConnectionFactory.Connection(); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); MySqlDataReader dtreader = cmd.ExecuteReader(); if (status == true) { while (dtreader.Read())//If there's any data. { TOProduct x = new TOProduct(); x.Id = dtreader.GetInt16("product_id"); x.Link = dtreader.GetString("product_link"); x.Name = dtreader.GetString("product_name"); x.Type = dtreader.GetString("product_type"); x.Price = dtreader.GetDouble("product_price"); x.Store = dtreader.GetString("product_store"); x.BuyingDate = dtreader.GetDateTime("product_buyingDate").ToString("dd-MM-yyyy");; i.Add(x); } con.Close(); } else { while (dtreader.Read())//If there's any data. { TOProduct x = new TOProduct(); x.Id = dtreader.GetInt16("product_id"); x.Link = dtreader.GetString("product_link"); x.Name = dtreader.GetString("product_name"); x.Type = dtreader.GetString("product_type"); x.Price = dtreader.GetDouble("product_price"); x.Store = dtreader.GetString("product_store"); i.Add(x); } con.Close(); } } catch (MySqlException e) { throw new Exception(e.Message); } return(i); }