// Редактирование описания
private void dataGridContent_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DataRowView dataRowView = (DataRowView)dataGrid_Content.SelectedItem;
ContentEditView contentEditView = new ContentEditView(
dataRowView.Row[0].ToString(),
dataRowView.Row[1].ToString(),
dataRowView.Row[2].ToString(),
dataRowView.Row[3].ToString()
);
contentEditView.ShowDialog();
}
// Новое описание
private void NewProduct_Click(object sender, RoutedEventArgs e)
{
//string getNewOrdId = $"SELECT MAX(prd_id) FROM dbo.products;";
string getNewOrdId = $"SELECT IDENT_CURRENT ('dbo.products');";
SqlCommand sqlGetNewProdId = new SqlCommand(getNewOrdId, LoginView.connection);
if (LoginView.connection.State == ConnectionState.Closed)
{
LoginView.connection.Open();
}
ContentEditView contentEditView = new ContentEditView(
(Convert.ToInt32(sqlGetNewProdId.ExecuteScalar()) + 1).ToString(),
null,
null,
null
);
contentEditView.ShowDialog();
}
