/// <summary>
/// метод для изменения номера заказа если роль заказа = закупка
/// </summary>
private void Button_Click_7(object sender, RoutedEventArgs e)
{
DataRowView selectedDataRow = (DataRowView)dataGrid.SelectedItem;
string conString = @"Data Source = DESKTOP-P6DOUN2\MSSQLSERVER02;Integrated Security = true;Initial Catalog=Cake";
SqlConnection connection = new SqlConnection(conString);
try
{
connection.Open();
String query = "SELECT [Статус] FROM Заказ where [Номер] = @nomerr";
SqlCommand sqlCommand = new SqlCommand(query, connection);
sqlCommand.Parameters.AddWithValue("@nomerr", Convert.ToString(selectedDataRow.Row.ItemArray[0]));
string rol = Convert.ToString(sqlCommand.ExecuteScalar());
if (rol == "Закупка")
{
DataSet2 = new DataSet2();
ЗаказTableAdapter = new ЗаказTableAdapter();
ЗаказTableAdapter.UpdateQueryProizvodstvo((Convert.ToString(selectedDataRow.Row.ItemArray[0])));
ЗаказTableAdapter.Fill(DataSet2.Заказ);
}
else
{
MessageBox.Show("вы не можете изменять");
}
}
finally
{
connection.Close();
}
}
/// <summary>
/// метод для удаления выбранной строки пользователем
/// </summary>
private void Button_Click_2(object sender, RoutedEventArgs e)
{
DataRowView selectedDataRow = (DataRowView)DataGrid.SelectedItem;
ЗаказTableAdapter = new ЗаказTableAdapter();
ЗаказTableAdapter.DeleteZakaz(Convert.ToString(selectedDataRow.Row.ItemArray[0]));
ЗаказTableAdapter.Fill(DataSet2.Заказ);
}
