private void ConfirmNewRecipe_FormClosing(object sender, FormClosingEventArgs e)
{
CreateNewRecipie cr = (CreateNewRecipie)this.Owner;
cr.Enabled = true;
this.Hide();
}
private void buttonCansel_Click(object sender, EventArgs e)
{
CreateNewRecipie cr = (CreateNewRecipie)this.Owner;
cr.Enabled = true;
this.Hide();
success = false;
}
private void новыйЧекToolStripMenuItem_Click(object sender, EventArgs e)
{
CreateNewRecipie cn = new CreateNewRecipie(user);
cn.Owner = this;
this.Enabled = false;
cn.ShowDialog();
dataGridView2.Rows.Clear();
AddToDGV();
}
private async void buttonConfirm_Click(object sender, EventArgs e)
{
HelperClass hc = new HelperClass();
//Преобразование списка продуктов в строку
string listString = JsonConvert.SerializeObject(list);
closed = true;
string connectToRecipies = @"Data Source = DESKTOP-NLAJBQI; Initial Catalog = Kass; Integrated Security = True";
string sqlCommand = "INSERT INTO Recipes(Id, Datetime, ProductList, Price, PaymentType, TakeAway, Comment, Cashier)" +
" VALUES(@Id, @Datetime, @ProductList, @Price, @PaymentType, @TakeAway, @Comment, @Cashier)";
using (SqlConnection connection = new SqlConnection(connectToRecipies))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand("SELECT * FROM dbo.Recipes", connection);
var reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
reader.Close();
command.CommandText = "SELECT MAX(Id) FROM dbo.Recipes";
id = Convert.ToInt32(await command.ExecuteScalarAsync());
id++;
}
else
{
id = 0;
}
reader.Close();
command.CommandText = sqlCommand;
command.Parameters.AddWithValue("@Id", id);
command.Parameters.AddWithValue("@Datetime", datetime);
command.Parameters.AddWithValue("@ProductList", listString);
command.Parameters.AddWithValue("@Price", price);
command.Parameters.AddWithValue("@PaymentType", paymentType);
command.Parameters.AddWithValue("@TakeAway", takeAway);
command.Parameters.AddWithValue("@Comment", Comment);
command.Parameters.AddWithValue("@Cashier", cashier);
await command.ExecuteNonQueryAsync();
}
foreach (var i in listBoxFinal.Items)
{
listBoxFinalStrings.Add(i.ToString());
}
//печать чека
hc.PrintRecipie(datetime, price, paymentType, takeAway, listBoxFinalStrings, cashier);
hc.SendRecipieToPrinter();
CreateNewRecipie cr = (CreateNewRecipie)this.Owner;
cr.Enabled = true;
this.Hide();
success = true;
}