private void Btn_edit_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(tb_BookID.Text)) //ถ้าในกล่องข้อความว่างเปล่า
{
MessageBox.Show("Please input 'book ID' ");
}
else if (String.IsNullOrEmpty(tb_BookTitle.Text))
{
MessageBox.Show("Please input 'Title' ");
}
else if (String.IsNullOrEmpty(tb_BookDescription.Text))
{
MessageBox.Show("Please input 'Description' ");
}
else if (String.IsNullOrEmpty(tb_BookPrice.Text))
{
MessageBox.Show("Please input 'Price' ");
}
else
{
if (MessageBox.Show("Do you want to save changing ?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
DataAccessBook.UpdateData(tb_BookID.Text, tb_BookTitle.Text, tb_BookDescription.Text, tb_BookPrice.Text);
MessageBox.Show("Update completed !!");
tb_BookDescription.Clear();
tb_BookID.Clear();
tb_BookTitle.Clear();
tb_BookPrice.Clear();
}
}
}
private void Btn_search_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(tb_BookID.Text))
{
MessageBox.Show("Please input 'BookID' ");
}
else
{
ArrayList arrayList = DataAccessBook.GetDataBook(tb_BookID.Text);
string data = "";
int counter = 0;
foreach (string list in arrayList)
{
counter = counter + 1;
data = data + list + "\n";
}
if (counter == 0)
{
MessageBox.Show("No member data found", "Member detail");
}
else
{
MessageBox.Show(data, "Member detail");
}
tb_BookID.Clear();
}
}
private void Btn_find_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(tb_find.Text))
{
MessageBox.Show("Please input 'Book ID' ");
}
else
{
ArrayList bookID = DataAccessBook.GetBookID(tb_find.Text);
ArrayList bookTitle = DataAccessBook.GetBookTitle(tb_find.Text);
ArrayList bookDescription = DataAccessBook.GetBookDescription(tb_find.Text);
ArrayList bookPrice = DataAccessBook.GetBookPrice(tb_find.Text);
string dataID = "";
int counter = 0;
foreach (string listID in bookID)
{
counter = counter + 1;
dataID = listID;
}
string dataTitle = "";
foreach (string listTitle in bookTitle)
{
dataTitle = listTitle;
}
string dataDescription = "";
foreach (string listDescription in bookDescription)
{
dataDescription = listDescription;
}
string dataPrice = "";
foreach (string listPrice in bookPrice)
{
dataPrice = listPrice;
}
if (counter == 0)
{
MessageBox.Show("No member data found", "Member detail");
}
else
{
tb_BookID.Text = dataID;
tb_BookTitle.Text = dataTitle;
tb_BookDescription.Text = dataDescription;
tb_BookPrice.Text = dataPrice;
}
}
}
private void Btn_delete_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(tb_BookID.Text))
{
MessageBox.Show("Please input CustomerID");
}
else
{
if (MessageBox.Show("Do you want to delete BookID : " + tb_BookID.Text + " ?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
DataAccessBook.DeleteBookData(tb_BookID.Text);
MessageBox.Show("Delete BookID : " + tb_BookID.Text + " complete", "Delete complete");
tb_BookID.Clear();
}
}
}
private void Btn_add_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(tb_BookID.Text)) //ถ้าในกล่องข้อความว่างเปล่า
{
MessageBox.Show("Please input 'ISBN' ");
}
else if (String.IsNullOrEmpty(tb_BookTitle.Text))
{
MessageBox.Show("Please input 'Title' ");
}
else if (String.IsNullOrEmpty(tb_BookDescription.Text))
{
MessageBox.Show("Please input 'Description' ");
}
else if (String.IsNullOrEmpty(tb_BookPrice.Text))
{
MessageBox.Show("Please input 'Price' ");
}
else
{
int keyCheck = 1;
foreach (string list in DataAccessBook.CheckBookID())
{
if (list == tb_BookID.Text)
{
keyCheck = 2;
MessageBox.Show("ID : " + list + " already exist");
break;
}
}
if (keyCheck == 1)
{
DataAccessBook.AddData(tb_BookID.Text, tb_BookTitle.Text, tb_BookDescription.Text, tb_BookPrice.Text);
MessageBox.Show("added ID " + tb_BookID.Text + " done");
tb_BookID.Clear();
tb_BookTitle.Clear();
tb_BookDescription.Clear();
tb_BookPrice.Clear();
}
}
}
private void Btn_show_Click(object sender, RoutedEventArgs e)
{
string data = "";
int counter = 0;
foreach (string list in DataAccessBook.GetData())
{
counter = counter + 1;
data = data + list + "\n";
}
if (counter == 0)
{
MessageBox.Show("No member data found", "Member detail");
}
else
{
MessageBox.Show(data, "Member detail");
}
}
private void Tb_BookID_TextChanged(object sender, TextChangedEventArgs e)
{
if (String.IsNullOrEmpty(tb_BookPrice.Text))
{
tb_TotalPrice.Clear();
}
ArrayList bookTitle = DataAccessBook.GetBookTitle(tb_BookID.Text);
ArrayList bookDescription = DataAccessBook.GetBookDescription(tb_BookID.Text);
ArrayList bookPrice = DataAccessBook.GetBookPrice(tb_BookID.Text);
string dataTitle = "";
foreach (string listTitle in bookTitle)
{
dataTitle = listTitle;
}
string dataDescription = "";
foreach (string listDescription in bookDescription)
{
dataDescription = listDescription;
}
string dataPrice = "";
foreach (string listPrice in bookPrice)
{
dataPrice = listPrice;
}
tb_BookTitle.Text = dataTitle;
tb_BookDescription.Text = dataDescription;
tb_BookPrice.Text = dataPrice;
}
public WindowBookMenu()
{
InitializeComponent();
DataAccessBook.InitializeBookDatabase();
}
