private void Button_Click_2(object sender, RoutedEventArgs e)
{
DataGrid dg = dataGridBorrowedBooks as DataGrid;
if (dg.SelectedItem != null)
{
BorrowedBy row = (BorrowedBy)dg.Items[dg.Items.IndexOf(dg.SelectedItem)];
row.returned = 1;
if (BorrowedBooksDataAccess.Update(row))
{
MessageBox.Show(AppConstants.BookCollectedMessage, AppConstants.BookCollectedTitle, MessageBoxButton.OK
, MessageBoxImage.Information);
}
else
{
MessageBox.Show(AppConstants.ErrorMessage, AppConstants.ErrorTitle, MessageBoxButton.OK
, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show(AppConstants.SelectMessage, AppConstants.SelectTitle, MessageBoxButton.OK
, MessageBoxImage.Information);
}
}
private void dataGridMembers_PreviewMouseDown(object sender, MouseButtonEventArgs e)
{
DataGrid dg = sender as DataGrid;
Member row = (Member)dg.Items[dg.Items.IndexOf(dg.SelectedItem)];
selectedMember = row;
SetMemberDataOnLabels(row);
borrowedBooks = new ObservableCollection <BorrowedBy>(BorrowedBooksDataAccess.SearchBorrowedBooks(row.MemberId));
lblTotalBooks.Content = borrowedBooks.Count() + " books were issued to this member";
this.dataGridBorrowedBooks.ItemsSource = borrowedBooks;
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
if (selectedBook != null)
{
BorrowedBy bb = new BorrowedBy();
bb.MemberId = selectedMember.MemberId;
bb.BookId = selectedBook.BookId;
bb.BorrowedDate = DateTime.Today.ToShortDateString();
bb.ReturnDate = DateTime.Today.AddDays(10).ToShortDateString();
bb.CurrentFine = 0;
bb.returned = 0;
bool flag = false;
if (selectedBook.NoOfCopies > 0)
{
flag = BorrowedBooksDataAccess.Insert(bb);
}
else
{
MessageBox.Show(AppConstants.BookNotAvailableMessage, AppConstants.ErrorTitle, MessageBoxButton.OK
, MessageBoxImage.Error);
}
if (flag)
{
MessageBox.Show(AppConstants.IssueSuccessMessage, AppConstants.IssueSuccessTitle, MessageBoxButton.OK
, MessageBoxImage.Information);
}
else
{
MessageBox.Show(AppConstants.ErrorMessage, AppConstants.ErrorTitle, MessageBoxButton.OK
, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show(AppConstants.SelectBookMessage, AppConstants.SelectTitle, MessageBoxButton.OK
, MessageBoxImage.Error);
}
}
