private void button_Click(object sender, RoutedEventArgs e) { try { DB db = new DB(); db.openConnection(connStr); ProductsList path = prodGrid.SelectedItem as ProductsList; db.startDelivery(path.id, path.price, Convert.ToInt32(textBox.Text), textBox1.Text, Convert.ToInt32(textBox2.Text)); MessageBox.Show("Выполнено !!!"); db.closeConnection(); } catch { MessageBox.Show("Ошибка запроса"); } }
private void button8_Click(object sender, RoutedEventArgs e) { try { DB db = new DB(); db.openConnection(connStr); ProductsList path = prodGrid.SelectedItem as ProductsList; db.updatePriceProduct(path.id, path.price); MessageBox.Show("Выполнено !!!"); db.closeConnection(); } catch { MessageBox.Show("Ошибка запроса"); } }
static void Main(string[] args) { Console.OutputEncoding = Encoding.UTF8; Console.InputEncoding = Encoding.UTF8; //string[] data = { "Вася", "Омск", "10000", "200" }; Informer seller = new Informer(); User user = new User(seller.Greeting()); ProductsList.List(); Console.WriteLine(Help); while (true) { int input = Convert.ToInt32(Console.ReadLine()); if (input == 0) { break; } else { switch (input) { case -1: Console.WriteLine(Help); break; case -2: Console.WriteLine($"Ваш баланс {user.Balance}$\r\n"); break; case -3: ProductsList.List(); break; default: seller.Buy(user, ProductsList.Mass[input - 1]); break; } } } Console.ReadKey(); }
public void getAllProducts() { using (SqlCommand cmd = new SqlCommand("selectProducts", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; var reader = cmd.ExecuteReader(); if (reader.HasRows) { ProductsList.prodList.Clear(); while (reader.Read()) { ProductsList pl = new ProductsList(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetString(3), reader.GetInt32(4), reader.GetString(5), reader.GetString(6)); ProductsList.prodList.Add(pl); } } reader.Close(); } }
public void filtrProduct(int id) { using (SqlCommand cmd = new SqlCommand("filtrProduct", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", id); var reader = cmd.ExecuteReader(); if (reader.HasRows) { ProductsList.prodList.Clear(); while (reader.Read()) { ProductsList pl = new ProductsList(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetString(3), reader.GetInt32(4), reader.GetString(5), reader.GetString(6)); ProductsList.prodList.Add(pl); } } reader.Close(); } }
private void button2_Click(object sender, RoutedEventArgs e) { try { ProductsList path = pGrid.SelectedItem as ProductsList; DB db = new DB(); db.openConnection(connStr); if (path.ammount < Convert.ToInt32(textBox.Text)) { MessageBox.Show("Отсутствует введённое количество товара"); } else { db.buySelectedProduct(path.id, Convert.ToInt32(textBox.Text)); MessageBox.Show("Куплено"); } db.closeConnection(); } catch { MessageBox.Show("Ошибка запроса"); } }