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("Ошибка запроса");
}
}
