private void go_products(object sender, RoutedEventArgs e)
{
WindowProducts product = new WindowProducts();
this.Close();
product.Show();
}
private void go_back(object sender, RoutedEventArgs e)
{
WindowProducts winproducts = new WindowProducts();
this.Close();
winproducts.Show();
}
private void go_add(object sender, RoutedEventArgs e)
{
if (imagepath != null)
{
string title = title_box.Text.Trim();
string description = Desription_box.Text.Trim();
string price = cost_box.Text.Trim();
//GenderCode
DB db = new DB();
SqlCommand command = new SqlCommand("INSERT INTO Product ( Name, Price, Description, ImagePath)"
+ "VALUES (@title, @cost, @Description, @imagepath)", db.getConnection());
command.Parameters.Add("@title", SqlDbType.VarChar).Value = title;
command.Parameters.Add("@Description", SqlDbType.VarChar).Value = description;
command.Parameters.Add("@cost", SqlDbType.VarChar).Value = price;
command.Parameters.Add("@imagepath", SqlDbType.VarChar).Value = imagepath;
db.openConnection();
if (CheckTextBoxes())
{
if (command.ExecuteNonQuery() == 1)
{
WindowProducts winproducts = new WindowProducts();
MessageBox.Show("Продукт успешно добавлена!");
this.Close();
winproducts.Show();
}
else
{
MessageBox.Show("Проверьте правильность введеных данных");
}
}
else
{
MessageBox.Show("Заполните пустые поля");
}
}
else
{
MessageBox.Show("Выберите изображение!");
}
}
private void go_save(object sender, RoutedEventArgs e)
{
DB db = new DB();
SqlCommand command = new SqlCommand("UPDATE Product SET Name = @title, Price = @cost, Description = @desk, ImagePath = @image Where ID = @ids", db.getConnection());
command.Parameters.AddWithValue("@title", title_box.Text);
command.Parameters.AddWithValue("@cost", cost_box.Text);
command.Parameters.AddWithValue("@desk", deck_box.Text);
command.Parameters.AddWithValue("@image", Service.MainImagePath);
command.Parameters.AddWithValue("@ids", Service.ID);
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
WindowProducts winadm = new WindowProducts();
MessageBox.Show("Продукт успешно отредактирована!");
this.Close();
winadm.Show();
}
}