public void InitializeAdminReturn()
{
try
{
UserReturnBL userReturn = new UserReturnBL();
DataSet ds = userReturn.GetAllReturnBL();
ObservableCollection <ReturnedBook> lst = new ObservableCollection <ReturnedBook>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
lst.Add(new ReturnedBook
{
BookName = Convert.ToString(dr["BookName"]),
BookId = Convert.ToInt32(dr["BookId"]),
UserId = Convert.ToInt32(dr["UserId"]),
UserName = Convert.ToString(dr["UserName"]),
DateReturned = Convert.ToString(Convert.ToDateTime(dr["DateReturned"]).ToShortDateString()),
});
}
dgReturn.ItemsSource = lst;
}
catch (Exception)
{
MessageBox.Show("Some unknown exception is occured!!!, Try again..");
}
}
//DELETE THE RETURN BOOK =>PL
private void BtnAccept_Click(object sender, RoutedEventArgs e)
{
try
{
ReturnedBook returned = dgReturn.SelectedItem as ReturnedBook;
if (returned != null)
{
UserReturnBL userReturnBL = new UserReturnBL();
bool isDone1 = userReturnBL.DeleteReturnBL(returned.BookId, returned.UserId);
BookBL bookBL = new BookBL();
bool isDone2 = bookBL.IncBookCopyBL(returned.BookId);
if (isDone1 == true && isDone2 == true)
{
MessageBox.Show("Book taken back successfully...");
InitializeAdminReturn();
}
else
{
MessageBox.Show("Try again...");
}
}
}
catch (Exception)
{
MessageBox.Show("Some unknown exception is occured!!!, Try again..");
}
}
//RETURN RECIEVED BOOK FROM RECIEVED BOOK TABLE
private void BtnReturn_Click(object sender, RoutedEventArgs e)
{
try
{
AcceptedBook accepted = dgReturn.SelectedItem as AcceptedBook;
if (accepted != null)
{
UserReturnBL userReturnBL = new UserReturnBL();
bool isDone3 = userReturnBL.AddReturnBL(accepted.BookId, accepted.BookName, userId);
UserRecieveBL userRecieveBL = new UserRecieveBL();
bool isDone1 = userRecieveBL.DeleteRecieveBL(accepted.BookId, userId);
/*BookBL bookBL = new BookBL();
* bool isDone2 = bookBL.IncBookCopyBL(accepted.BookId);*/
if (isDone1 == true && isDone3 == true)
{
MessageBox.Show("Book returned successfully...");
InitializeUserTransaction();
}
else
{
MessageBox.Show("Try again...");
}
}
else
{
MessageBox.Show("Select a book properly...");
}
}
catch (Exception)
{
MessageBox.Show("Some unknown exception is occured!!!, Try again..");
}
}
