private void Button_Click(object sender, RoutedEventArgs e)
{
if (int.Parse(count.Text) > product.count)
{
MessageBox.Show("Введите меньшее количество для продажи", "Ошибка");
}
else
{
if (int.Parse(count.Text) == 0)
{
MainWindow.sellList.RemoveAll(x => x.id == product.id);
}
else if (MainWindow.sellList.Where(x => x.id == product.id).Count() == 0)
{
product.sell = int.Parse(count.Text);
MainWindow.sellList.Add(product);
}
else
{
for (int i = 0; i < MainWindow.sellList.Count; i++)
{
var item = MainWindow.sellList[i];
if (item.id == product.id)
{
ProductATT temp = item;
temp.sell = int.Parse(count.Text);
MainWindow.sellList[i] = temp;
break;
}
}
}
}
this.Close();
}
public Sell()
{
InitializeComponent();
table.Items.Clear();
product = DBQueries.GetProductATT(MainWindow.att, MainWindow.product.id);
table.Items.Add(product);
count.Text = MainWindow.product.sell.ToString();
}
public static List <ProductATT> GetProductsATT(int att)
{
List <ProductATT> products = new List <ProductATT>();
string query =
"SELECT att_list.id, product.title, active.title as active, box.title as box, " +
"product.count as inside, measures.title as measures, creator.title as creator, " +
"form.title as form, type.title as type, product.recipe as recipe, att_list.count as count, " +
"att_list.price as price, att_list.date as date, ADDDATE(att_list.date, product.valid) as valid, att_list.arrival as arrival " +
"FROM att_list, product, box, creator, form, type, active, measures " +
"WHERE att_list.product = product.id AND product.active = active.id " +
"AND product.box = box.id AND product.creator = creator.id " +
"AND product.measures = measures.id AND product.form = form.id " +
"AND product.type = type.id AND NOT ISNULL(ADDDATE(att_list.date, product.valid)) AND att_list.att = " + att;
DBHelper.GetConnect().Open();
MySqlCommand command = DBHelper.GetConnect().CreateCommand();
command.CommandText = query;
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ProductATT product = new ProductATT()
{
id = reader.GetInt32(0),
title = reader.GetString(1),
active = reader.GetString(2),
box = reader.GetString(3),
inside = reader.GetString(4),
measures = reader.GetString(5),
creator = reader.GetString(6),
form = reader.GetString(7),
type = reader.GetString(8),
count = reader.GetInt32(10),
price = reader.GetDouble(11),
date = reader.GetString(12).Split(' ')[0],
valid = reader.GetString(13).Split(' ')[0],
arrival = reader.GetString(14).Split(' ')[0],
};
if (reader.GetBoolean(9))
{
product.recipe = "Да";
}
else
{
product.recipe = "Нет";
}
products.Add(product);
}
DBHelper.GetConnect().Close();
return(products);
}
public static ProductATT GetProductATT(int att, int product_id)
{
ProductATT product = new ProductATT();
string query = "SELECT att_list.id, product.title, active.title as active, box.title as box, " +
"product.count as inside, measures.title as measures, creator.title as creator, " +
"form.title as form, type.title as type, product.recipe as recipe, att_list.count as count, " +
"att_list.price as price, att_list.date as date, ADDDATE(att_list.date, product.valid) as valid, att_list.arrival as arrival " +
"FROM att_list, product, box, creator, form, type, active, measures " +
"WHERE att_list.product = product.id AND product.active = active.id " +
"AND product.box = box.id AND product.creator = creator.id " +
"AND product.measures = measures.id AND product.form = form.id " +
$"AND product.type = type.id AND att_list.att = {att} " +
$"AND att_list.id = {product_id}";
DBHelper.GetConnect().Open();
MySqlCommand command = DBHelper.GetConnect().CreateCommand();
command.CommandText = query;
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
product.id = reader.GetInt32(0);
product.title = reader.GetString(1);
product.active = reader.GetString(2);
product.box = reader.GetString(3);
product.inside = reader.GetString(4);
product.measures = reader.GetString(5);
product.creator = reader.GetString(6);
product.form = reader.GetString(7);
product.type = reader.GetString(8);
product.count = reader.GetInt32(10);
product.price = reader.GetDouble(11);
product.date = reader.GetString(12).Split(' ')[0];
product.valid = reader.GetString(13).Split(' ')[0];
product.arrival = reader.GetString(14).Split(' ')[0];
if (reader.GetBoolean(9))
{
product.recipe = "Да";
}
else
{
product.recipe = "Нет";
}
}
DBHelper.GetConnect().Close();
return(product);
}
