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);
}
}
