private void Delete_Click(object sender, RoutedEventArgs e) { if (DB.Command($"delete from Authors where [full_name]='{Name.Text}'")) { SetAuthors(); } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (DB.Command($"delete from BookCategories where [name]='{Name.Text}'")) { SetCategories(); } }
private void Add_Click(object sender, RoutedEventArgs e) { if (DB.Command($"insert into Authors values('{Name.Text}')")) { SetAuthors(); } }
private void Add_Click(object sender, RoutedEventArgs e) { if (DB.Command($"insert into BookCategories values('{Name.Text}')")) { SetCategories(); } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (DB.Command($"delete from Products where [name]='{Name.Text}'")) { SetProducts(); } }
private void Add_Click(object sender, RoutedEventArgs e) { int category_id = DB.GetId($"select id from Categories where [name] = '{Categories.SelectedItem}'"); if (DB.Command($"insert into Products values({category_id}, '{Name.Text}', '{Description.Text}', {Price.Text}, {Amount.Text})")) { SetProducts(); } }
private void Add_Click(object sender, RoutedEventArgs e) { int category_id = DB.GetId($"select id from BookCategories where [name] = '{Categories.SelectedItem}'"); int author_id = DB.GetId($"select id from Authors where [full_name]='{Author.SelectedItem}'"); if (DB.Command($"insert into Books values({category_id}, {author_id}, '{Name.Text}', '{Description.Text}', {Price.Text}, {Amount.Text})")) { SetBooks(); } }
private void Exit_Click(object sender, RoutedEventArgs e) { foreach (OrderProduct product in cart_items) { DB.Command($"Update Books set amount=amount+1 where id = {product.BookId}"); } LoginWindow login = new LoginWindow(); login.Show(); Close(); }
private void Confirm_Click(object sender, RoutedEventArgs e) { if (ID.Text.Length > 0 && NewPrice.Text.Length > 0) { if (DB.Command($"Update Books set price={NewPrice.Text} where id={ID.Text}")) { MessageBox.Show("Успешно обновалено"); SetBooks(); } } }
private void Delete_Click(object sender, RoutedEventArgs e) { string id = IDDelete.Text; List <string> dt = DB.GetDataOneAttribute($"select id_book from OrdersBooks where number={id}", "id_book"); List <string> book = DB.GetDataOneAttribute($"select price from Books where id = {dt[0]}", "price"); if (DB.Command($"delete from OrdersBooks where number = {id}")) { SetAllInOrder(); DB.Command($"update Orders set result-={ChangeComa(book[0])} where id = {id_order}"); } }
private void Button_Click(object sender, RoutedEventArgs e) { DataTable find = DB.Select($"select * from [Users] where login='******' and password='******'"); if (find.Rows.Count > 0) { MessageBox.Show("Пользователь с таким именем уже существует"); } else { if (RegexLogin(LoginBox.Text)) { if (RegexPassword(Password.Password)) { if (RepeatPassword.Password.Equals(Password.Password)) { try { DB.Command($"insert into [Users] values('{LoginBox.Text}', '{Password.Password}')"); MessageBox.Show("Успешно создан"); UserWindow uw = new UserWindow(); uw.Show(); Close(); } catch (Exception error) { MessageBox.Show(error.Message); } } else { MessageBox.Show("Пароли не совпадают"); } } else { MessageBox.Show("Пароль обязан быть 8-20 символовв"); } } else { MessageBox.Show("Логин обязан быть 4-15 символов"); } } }
private void AddBook_Click(object sender, RoutedEventArgs e) { Book selected = (Book)AllBooks.SelectedItem; DataTable dt = DB.Select($"select amount from Books where id={selected.ID}"); int amount = Convert.ToInt32(dt.Rows[0]["amount"]); if (amount - 1 > 0) { if (first) { if (DB.Command($"insert into Orders values({DB.UserID}, (select convert(varchar(10),(select getdate()), 120)), 0)")) { first = false; id_order = DB.GetId($"select top 1 * from Orders where id_user = {DB.UserID} order by id desc"); } else { MessageBox.Show("У нас неполадки в системе попробуйте позже"); return; } } if (DB.Command($"insert into OrdersBooks values({id_bk_or + 1}, {id_order}, {selected.ID})")) { DB.Command($"Update Books set amount=amount-1 where id={selected.ID}"); SetAllInOrder(); UpdateIDs(); DB.Command($"update Orders set result+={ChangeComa(selected.Price)} where id = {id_order}"); } else { MessageBox.Show("Что-то пошло не так попробуйте позже"); } } else { MessageBox.Show("Этой книги на складе больше не осталось \n Извините за неудобства"); } }