/// <summary>
///
/// </summary>
public static void loadBook()
{
DataTable booksDT = new DataTable();
DBHelper.UpdateBookTable();
booksDT = DBHelper.GetDT();
Itembook book = new Itembook();
BookList.Clear();
foreach (DataRow row in booksDT.Rows)
{
book.Title = row["Book_Title"].ToString();
book.Autor = row["Book_Autor"].ToString();
book.Genre = row["Book_Genre"].ToString();
book.Image = (byte[])row["Book_Image"];
book.EPC = row["Book_RFID_EPC"].ToString();
book.timeStamp = row["Book_RFID_TimeStamp"].ToString();
book.RSSI = row["Book_RFID_RSSI"].ToString();
BookListing.addBookItem(book.EPC, book.timeStamp, book.RSSI, book.Title, book.Autor, book.Genre, book.Image);
}
}
/// <summary>
///
/// </summary>
private void btn_RemoveItem_Click(object sender, RoutedEventArgs e)
{
Console.WriteLine(dg_BookTable.GetType());
try
{
Itembook rows = dg_BookTable.SelectedItem as Itembook;
if (rows != null)
{
Console.WriteLine(rows.EPC);
DBHelper.RemoveBookQuery(rows.EPC.ToString());
loadBook();
}
else
{
MessageBox.Show("Please select an item to remove");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
/// <summary>
///
/// </summary>
public static void RemoveBookItem(Itembook selectedItem)
{
BookList.Remove(BookList.Where(i => i.EPC == selectedItem.EPC).Single());
}
