private void CreateChangesInfoFinal()
{
HelperClass hc = new HelperClass();
if (!hc.CheckIfChangeOpen())
{
MessageBox.Show("Сначала откройте смену.");
return;
}
string connectToChanges = @"Data Source = DESKTOP-NLAJBQI; Initial Catalog = Kass; Integrated Security = True";
string sqlCommand = "UPDATE dbo.Changes SET ChangesInfo = @list WHERE Id = @id";
int id = hc.GetIdCurrentChange();
using (SqlConnection connection = new SqlConnection(connectToChanges))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlCommand, connection);
string str = CreateChangesInfo();
SqlParameter listParam = new SqlParameter("@list", str);
command.Parameters.Add(listParam);
SqlParameter idParam = new SqlParameter("@id", id);
command.Parameters.Add(idParam);
command.ExecuteNonQuery();
}
}
private void FillDGV()
{
HelperClass hc = new HelperClass();
int id = hc.GetIdCurrentChange();
if (hc.CheckIfChangeOpen())
{
id--;
}
string connectToChanges = @"Data Source = DESKTOP-NLAJBQI; Initial Catalog = Kass; Integrated Security = True";
string sqlExpr = "SELECT * FROM dbo.Changes";
using (SqlConnection connection = new SqlConnection(connectToChanges))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpr, connection);
var reader = command.ExecuteReader();
for (int i = 0; i <= id; i++)
{
reader.Read();
dataGridView1.Rows.Add(reader.GetInt32(0), reader.GetDateTime(1), reader.GetDateTime(2), reader.GetString(3),
reader.GetString(4), reader.GetInt32(5));
}
}
}
public async void AddToDGV()
{
HelperClass hc = new HelperClass();
if (!hc.CheckIfChangeOpen())
{
MessageBox.Show("Смена не открыта. Откройте ее в меню администратора и повторите попытку.");
Application.Exit();
}
string connectToRecipies = @"Data Source = DESKTOP-NLAJBQI; Initial Catalog = Kass; Integrated Security = True";
string sqlCommand = "SELECT * FROM dbo.Recipes";
string place;
List <Product> DBList = new List <Product>();
using (SqlConnection connection = new SqlConnection(connectToRecipies))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(sqlCommand, connection);
var reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
string str = reader.GetString(2);
DBList = JsonConvert.DeserializeObject <List <Product> >(str);
str = "";
foreach (var i in DBList)
{
str += i.Name + " (x" + i.Amount + "), ";
}
str = str.TrimEnd(',', ' ');
if (reader.GetBoolean(5))
{
place = "На вынос";
}
else
{
place = "В кафе";
}
dataGridView2.Rows.Add(reader.GetInt32(0), reader.GetDateTime(1), str, reader.GetInt32(3),
reader.GetString(4), place, reader.GetString(6), reader.GetString(7));
}
}
}
}
private void OpenChange()
{
int id = 0;
HelperClass hc = new HelperClass();
if (hc.CheckIfChangeOpen())
{
MessageBox.Show("Смена уже создана.");
return;
}
else
{
id = hc.GetIdCurrentChange();
if (id == -1)
{
id = 0;
}
else
{
id++;
}
}
string connectToChanges = @"Data Source = DESKTOP-NLAJBQI; Initial Catalog = Kass; Integrated Security = True";
string sqlCommand = "INSERT INTO dbo.Changes (Id, DateTimeOpen) VALUES (@Id, @DateTimeOpen)";
DateTime dateTime = DateTime.Now.ToLocalTime();
using (SqlConnection connection = new SqlConnection(connectToChanges))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlCommand, connection);
command.Parameters.AddWithValue("@Id", id);
command.Parameters.AddWithValue("@DateTimeOpen", dateTime);
command.ExecuteNonQueryAsync();
MessageBox.Show("Смена успешно создана.");
}
}
private void CloseChange()
{
HelperClass hc = new HelperClass();
if (hc.CheckIfChangeOpen())
{
CreateChangesInfoFinal();
CountAmountSelled();
CountProceed();
SetDateTimeCLose();
TruncateTable();
MessageBox.Show("Смена " + hc.GetIdCurrentChange().ToString() + " успешно закрыта.");
dataGridView1.Rows.Clear();
FillDGV();
}
else
{
MessageBox.Show("Сначала откройте смену");
}
}
