public static ObservableCollection <AddedBook> GetAllListAddedBook(int id) { ObservableCollection <AddedBook> result = null; try { var reader = DataConnector.ExecuteQuery("select MaPhieuNhap,MaSach,SoLuong from ChiTietPhieuNhap where MaPhieuNhap = " + id); if (reader != null) { result = new ObservableCollection <AddedBook>(); while (reader.Read()) { var ID = reader.GetInt32(0); var item = new AddedBook(ID); item.BeginInit(); item.Book = BookAdapter.GetBook(reader.GetInt32(1)); item.Number = reader.GetInt32(2); item.EndInit(); result.Add(item); } } } catch (Exception ex) { ErrorManager.Current.DataCantBeRead.Call(ex.Message); } return(result); }
public static void DeleteAddedBook(AddedBook ab) { try { DataConnector.ExecuteNonQuery(string.Format("delete from ChiTietPhieuNhap where MaPhieuNhap={0} and MaSach={1}", ab.ID, ab.Book.ID)); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } }
public static void UpdateAddedBook(AddedBook ab) { try { DataConnector.ExecuteNonQuery(string.Format("update ChiTietPhieuNhap set SoLuong={0} where MaPhieuNhap={1} and MaSach={2} ", ab.Number, ab.ID, ab.Book.ID)); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } }
public static int InsertAddedBookItem(int ID, int IDBook, AddedBook ab) { try { DataConnector.ExecuteNonQuery(string.Format("insert into ChiTietPhieuNhap(MaPhieuNhap,MaSach,SoLuong) values({0},{1},{2})", ID, IDBook, ab.Number)); } catch (Exception ex) { ErrorManager.Current.DataCantBeInsert.Call(ex.Message); } return(-1); }
private void btn_Add_Click(object sender, RoutedEventArgs e) { if (tb_BookName.Text == "") { ErrorManager.Current.InfoIsNull.Call("Tên sách không được để trống!"); return; } var selectedbook = tb_BookName.SelectedItem as Book; if (selectedbook != null) { AddedBook ab = new AddedBook() { Book = selectedbook, Number = (int)num_UpDown.Value }; var item = ListAddedBook.FirstOrDefault(x => x.Book.ID == ab.Book.ID); if (item != null) { item.Number += (int)num_UpDown.Value; } else { ListAddedBook.Add(ab); } } else { var item = ListBook.FirstOrDefault(x => x.Name == tb_BookName.Text); AddedBook ab = new AddedBook(); if (item != null) { ab.Book = item; ab.Number = (int)num_UpDown.Value; } else { ab.Book = new Book(); ab.Book.Name = tb_BookName.Text; ab.Book.AuthorsFormat = tb_Authors.Text; ab.Book.GenresFormat = tb_Genres.Text; ab.Number = (int)num_UpDown.Value; } ListAddedBook.Add(ab); } }