// Кнопка деталей товара
private void Details_Button(object sender, RoutedEventArgs e)
{
Button button = sender as Button; // !!!
catalog_goods good = button.DataContext as catalog_goods; // !!!
Manager.MainFrame.Navigate(new Admin_Product_Details(good.product_id));
}
/*конструктор*/
public User_Product_Details(int product_id, string ConnectionString)
{
InitializeComponent();
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
List <catalog_goods> goods_list = new List <catalog_goods>();
/* вывод информации о продукте*/
string sqlExpression = "SELECT * FROM Goods WHERE product_id=@product_id_value";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlParameter product_id_param = new SqlParameter("@product_id_value", product_id); command.Parameters.Add(product_id_param);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
TextBlock_Product_Name.Text = reader.GetString(1);
TextBlock_Product_description.Text = reader[2].ToString();
TextBlock_Product_Count.Text = reader.GetValue(3).ToString();
TextBlock_Product_price.Text = reader.GetValue(4).ToString();
st.image = reader[5] as byte[];
goods_list.Add(st);
Image_Product.DataContext = goods_list;
}
reader.Close();
}
else
{
reader.Close();
}
}
// Кнопка обновить каталог
private void Write_Admin_Goods_Button(object sender, RoutedEventArgs e)
{
Admin_Catalog_ListView.ItemsSource = null;
List <catalog_goods> goods_list = new List <catalog_goods>();
string client_id = tmp;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
/*вывод товаров*/
string sqlExpression = "SELECT * FROM Goods";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
st.product_id = reader.GetInt32(0);
st.product_name = reader.GetString(1);
st.description = reader.GetValue(2).ToString();
st.price = reader.GetValue(3).ToString();
st.count = reader.GetInt32(4);
st.image = reader[5] as byte[];
goods_list.Add(st);
}
Admin_Catalog_ListView.ItemsSource = goods_list;
reader.Close();
}
else
{
reader.Close();
}
}
/* конструктор */
public User(string client_id, string connectionString)
{
InitializeComponent();
ConnectionString = connectionString;
tmp = client_id;
List <catalog_goods> goods_list = new List <catalog_goods>();
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
string sqlExpression = "SELECT * FROM Goods";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
st.product_id = reader.GetInt32(0);
st.product_name = reader.GetString(1);
st.description = reader.GetValue(2).ToString();
st.price = reader.GetValue(3).ToString();
st.count = reader.GetInt32(4);
st.image = reader[5] as byte[];
goods_list.Add(st);
}
User_Catalog_ListView.ItemsSource = goods_list;
reader.Close();
}
else
{
reader.Close();
}
}
/* кнопка подробнее о товаре */
private void Details_Button(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
catalog_goods good = button.DataContext as catalog_goods;
Manager.MainFrame.Navigate(new User_Product_Details(good.product_id, ConnectionString));
}
public Admin(string client_id)
{
InitializeComponent();
Admin_Catalog_ListView.ItemsSource = null;
List <catalog_goods> goods_list = new List <catalog_goods>();
tmp = client_id;
try {
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-52L8N5J\SQLEXPRESS02;;Initial Catalog=Pharmacy;" + "Integrated Security=True;Connect Timeout=15;Encrypt=False;" + "TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
string sqlExpression = "SELECT * FROM Goods";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
st.product_id = reader.GetInt32(0);
st.product_name = reader.GetString(1);
st.description = reader.GetValue(2).ToString();
st.price = reader.GetValue(3).ToString();
st.count = reader.GetInt32(4);
st.image = reader[5] as byte[];
goods_list.Add(st);
}
Admin_Catalog_ListView.ItemsSource = goods_list;
//Admin_Caralog_Grid.ItemsSource = goods_list;
reader.Close();
}
else
{
reader.Close();
}
} catch (SqlException error) {
MessageBox.Show(error.Message);
}
}
/* кнопка удаления товара для администратора*/
private void Admin_Goods_Del_Button(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
string sqlExpression;
SqlCommand command;
SqlParameter product_id_param;
if (button != null)
{
catalog_goods good = button.DataContext as catalog_goods;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
/* удаление товара из каталога*/
sqlExpression = "DELETE FROM Pharmacy.dbo.Basket WHERE product_id = @product_id_value DELETE FROM Pharmacy.dbo.Goods WHERE product_id = @product_id_value";
command = new SqlCommand(sqlExpression, connection);
product_id_param = new SqlParameter("@product_id_value", Product_id); command.Parameters.Add(product_id_param);
command.ExecuteNonQuery();
MessageBox.Show("Товар удален");
Manager.MainFrame.GoBack();
}
}
// Кнопка поиска
private void Search_Button(object sender, RoutedEventArgs e)
{
List <catalog_goods> goods_list = new List <catalog_goods>();
Admin_Catalog_ListView.ItemsSource = null;
string client_id = tmp;
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-52L8N5J\SQLEXPRESS02;;Initial Catalog=Pharmacy;" + "Integrated Security=True;Connect Timeout=15;Encrypt=False;" + "TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
String SearchString = SearchTextBox.Text;
string sqlExpression = "SELECT * FROM Goods WHERE product_name Like '%" + SearchString + "%'";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
st.product_id = reader.GetInt32(0);
st.product_name = reader.GetString(1);
st.description = reader.GetValue(2).ToString();
st.price = reader.GetValue(3).ToString();
st.count = reader.GetInt32(4);
st.image = reader[5] as byte[];
goods_list.Add(st);
}
Admin_Catalog_ListView.ItemsSource = goods_list;
reader.Close();
}
else
{
reader.Close();
}
}
public Admin_Product_Details(int product_id)
{
InitializeComponent();
Product_id = product_id;
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-52L8N5J\SQLEXPRESS02;;Initial Catalog=Pharmacy;" + "Integrated Security=True;Connect Timeout=15;Encrypt=False;" + "TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
List <catalog_goods> goods_list = new List <catalog_goods>();
string sqlExpression = "SELECT * FROM Goods WHERE product_id=@product_id_value";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlParameter product_id_param = new SqlParameter("@product_id_value", product_id); command.Parameters.Add(product_id_param);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
TextBlock_Product_Name.Text = reader.GetString(1);
//st.description = reader.GetValue(2).ToString();
TextBlock_Product_Count.Text = reader.GetValue(3).ToString();
TextBlock_Product_price.Text = reader.GetValue(4).ToString();
st.image = reader[5] as byte[];
goods_list.Add(st);
Image_Product.DataContext = goods_list;
}
reader.Close();
}
else
{
reader.Close();
}
}
// Кнопка поиска
private void Search_Button(object sender, RoutedEventArgs e)
{
List <catalog_goods> goods_list = new List <catalog_goods>();
Admin_Catalog_ListView.ItemsSource = null;
string client_id = tmp;
SqlConnection connection = new SqlConnection(@ConnectionString);
connection.Open();
String SearchString = SearchTextBox.Text;
SearchString = SearchString.Replace("'", "['']");
SearchString = SearchString.Replace("%", "[%]");
/* поиск */
string sqlExpression = "SELECT * FROM Goods WHERE product_name Like '%" + SearchString + "%'";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
catalog_goods st = new catalog_goods();
st.product_id = reader.GetInt32(0);
st.product_name = reader.GetString(1);
st.description = reader.GetValue(2).ToString();
st.price = reader.GetValue(3).ToString();
st.count = reader.GetInt32(4);
st.image = reader[5] as byte[];
goods_list.Add(st);
}
Admin_Catalog_ListView.ItemsSource = goods_list;
reader.Close();
}
else
{
reader.Close();
}
}
private void Admin_Goods_Del_Button(object sender, RoutedEventArgs e)
{
Button button = sender as Button; // !!!
string sqlExpression;
SqlCommand command;
SqlParameter product_id_param;
if (button != null)
{
catalog_goods good = button.DataContext as catalog_goods; // !!!
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-52L8N5J\SQLEXPRESS02;;Initial Catalog=Pharmacy;" + "Integrated Security=True;Connect Timeout=15;Encrypt=False;" + "TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
sqlExpression = "DELETE FROM Pharmacy.dbo.Basket WHERE product_id = @product_id_value DELETE FROM Pharmacy.dbo.Goods WHERE product_id = @product_id_value";
command = new SqlCommand(sqlExpression, connection);
product_id_param = new SqlParameter("@product_id_value", Product_id); command.Parameters.Add(product_id_param);
command.ExecuteNonQuery();
MessageBox.Show("Товар удален");
Manager.MainFrame.GoBack();
}
}
// добавление в корзину
private void Basket_Add_Button(object sender, RoutedEventArgs e)
{
string client_id = tmp;
Button button = sender as Button; // !!!
string sqlExpression;
SqlCommand command;
SqlParameter client_id_param;
SqlParameter product_id_param;
SqlParameter count_goods_param;
int count_of_product_depot = 0;
//catalog_goods good = (catalog_goods)Admin_Caralog_Grid.SelectedItem;
//catalog_goods good = (catalog_goods)Admin_Catalog_ListView.SelectedItem;
List <catalog_goods> goods_list = new List <catalog_goods>();
if (button != null)
{
catalog_goods good = button.DataContext as catalog_goods; // !!!
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-52L8N5J\SQLEXPRESS02;;Initial Catalog=Pharmacy;" + "Integrated Security=True;Connect Timeout=15;Encrypt=False;" + "TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
sqlExpression = "SELECT [count] FROM Goods WHERE product_id = @product_id_value";
command = new SqlCommand(sqlExpression, connection);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
count_of_product_depot = reader.GetInt32(0);
}
}
reader.Close();
if (count_of_product_depot > 0)
{
sqlExpression = "SELECT * FROM Basket WHERE client_id=@client_id_value AND product_id=@product_id_value";
command = new SqlCommand(sqlExpression, connection);
client_id_param = new SqlParameter("@client_id_value", client_id); command.Parameters.Add(client_id_param);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
reader = command.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Продукт уже в корзине");
reader.Close();
}
else
{
reader.Close();
sqlExpression = "insert into Basket (client_id, product_id, count_goods) VALUES(@client_id_value, @product_id_value, @count_goods_value)";
command = new SqlCommand(sqlExpression, connection);
client_id_param = new SqlParameter("@client_id_value", client_id); command.Parameters.Add(client_id_param);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
count_goods_param = new SqlParameter("@count_goods_value", 1); command.Parameters.Add(count_goods_param);
command.ExecuteNonQuery();
MessageBox.Show("Продукт в корзине");
}
}
else
{
MessageBox.Show("Товар закончился");
}
}
else
{
MessageBox.Show("Выберите элемент в таблице");
}
Admin_Catalog_ListView.SelectedItem = null;
}
// добавление в корзину
private void Basket_Add_Button(object sender, RoutedEventArgs e)
{
string client_id = tmp;
Button button = sender as Button; // !!!
string sqlExpression;
SqlCommand command;
SqlParameter client_id_param;
SqlParameter product_id_param;
SqlParameter count_goods_param;
int count_of_product_depot = 0;
List <catalog_goods> goods_list = new List <catalog_goods>();
if (button != null)
{
catalog_goods good = button.DataContext as catalog_goods; // !!!
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
/* получаем кол-во товара на складе*/
sqlExpression = "SELECT [count] FROM Goods WHERE product_id = @product_id_value";
command = new SqlCommand(sqlExpression, connection);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
count_of_product_depot = reader.GetInt32(0);
}
}
reader.Close();
if (count_of_product_depot > 0)
{
/* получаем кол-во товара в корзине */
sqlExpression = "SELECT * FROM Basket WHERE client_id=@client_id_value AND product_id=@product_id_value";
command = new SqlCommand(sqlExpression, connection);
client_id_param = new SqlParameter("@client_id_value", client_id); command.Parameters.Add(client_id_param);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
reader = command.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Продукт уже в корзине");
reader.Close();
}
else
{
reader.Close();
/* добавление в корзину */
sqlExpression = "insert into Basket (client_id, product_id, count_goods) VALUES(@client_id_value, @product_id_value, @count_goods_value)";
command = new SqlCommand(sqlExpression, connection);
client_id_param = new SqlParameter("@client_id_value", client_id); command.Parameters.Add(client_id_param);
product_id_param = new SqlParameter("@product_id_value", good.product_id); command.Parameters.Add(product_id_param);
count_goods_param = new SqlParameter("@count_goods_value", 1); command.Parameters.Add(count_goods_param);
command.ExecuteNonQuery();
MessageBox.Show("Продукт в корзине");
}
}
else
{
MessageBox.Show("Товар закончился");
}
}
else
{
MessageBox.Show("Выберите элемент в таблице");
}
Admin_Catalog_ListView.SelectedItem = null;
}
