//ACCEPT THE REQUESTED BOOK =>PL
private void BtnAccept_Click(object sender, RoutedEventArgs e)
{
try
{
RequestedBook request = dgRequests.SelectedItem as RequestedBook;
if (request != null)
{
UserRecieveBL userRecieveBL = new UserRecieveBL();
bool isDone1 = userRecieveBL.AddRecieveBL(request.BookId, request.BookName, request.UserId, request.UserName);
UserRequestBL userRequest = new UserRequestBL();
bool isDone2 = userRequest.DeleteRequestBL(request.BookId, request.UserId);
if (isDone1 == true && isDone2 == true)
{
MessageBox.Show("Accepted request successfully...");
InitializeRequests();
}
else
{
MessageBox.Show("Try again latter...");
}
}
else
{
MessageBox.Show("Select book properly...");
}
}
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..");
}
}
//REFRESH THE RECIEVED BOOK GRID VIEW =>PL
private void btnRefresh_Click(object sender, EventArgs e)
{
UserRecieveBL userRecieve = new UserRecieveBL();
DataSet ds = userRecieve.GetAllRecieveDAL();
dgvRecieveDetails.DataSource = ds.Tables[0];
}
//REFRESH RECIEVED BOOK GRID VIEW
private void btnRecRefresh_Click(object sender, EventArgs e)
{
UserId = UserForm.UserId;
UserRecieveBL userRecieveBL = new UserRecieveBL();
DataSet ds2 = userRecieveBL.GetAllRecieveUserBL(UserId);
dgvUserRecieve.DataSource = ds2.Tables[0];
}
public AdminBookRecieve()
{
InitializeComponent();
UserRecieveBL userRecieve = new UserRecieveBL();
DataSet ds = userRecieve.GetAllRecieveDAL();
dgvRecieveDetails.DataSource = ds.Tables[0];
}
public UserTransaction()
{
InitializeComponent();
UserId = UserForm.UserId;
UserRequestBL userRequestBL = new UserRequestBL();
DataSet ds1 = userRequestBL.GetAllRequestUserBL(UserId);
dgvUserRequest.DataSource = ds1.Tables[0];
UserRecieveBL userRecieveBL = new UserRecieveBL();
DataSet ds2 = userRecieveBL.GetAllRecieveUserBL(UserId);
dgvUserRecieve.DataSource = ds2.Tables[0];
}
//DELETE RECIEVED BOOK FROM RECIEVED BOOK TABLE
private void btnDelete_Click(object sender, EventArgs e)
{
if (BookId > 0)
{
UserRecieveBL userRecieveBL = new UserRecieveBL();
bool isDone1 = userRecieveBL.DeleteRecieveBL(BookId, UserId);
BookBL bookBL = new BookBL();
bool isDone2 = bookBL.IncBookCopyBL(BookId);
if (isDone1 == true && isDone2 == true)
{
MessageBox.Show("Book deleted successfully...");
}
else
{
MessageBox.Show("Try again...");
}
}
else
{
MessageBox.Show("Select a book properly...");
}
}
//ACCEPT THE REQUESTED BOOK =>PL
private void btnAccept_Click(object sender, EventArgs e)
{
if (BookId > 0)
{
UserRecieveBL userRecieveBL = new UserRecieveBL();
bool isDone1 = userRecieveBL.AddRecieveBL(BookId, BookName, UserId, UserName);
UserRequestBL userRequest = new UserRequestBL();
bool isDone2 = userRequest.DeleteRequestBL(BookId, UserId);
if (isDone1 == true && isDone2 == true)
{
MessageBox.Show("Accepted request successfully...");
}
else
{
MessageBox.Show("Try again latter...");
}
}
else
{
MessageBox.Show("Select book properly...");
}
}
public void InitializeUserTransaction()
{
try
{
userId = UserLogin.userId;
UserRequestBL userRequestBL = new UserRequestBL();
DataSet ds1 = userRequestBL.GetAllRequestUserBL(userId);
ObservableCollection <RequestedBook> lstRequest = new ObservableCollection <RequestedBook>();
foreach (DataRow dr in ds1.Tables[0].Rows)
{
lstRequest.Add(new RequestedBook
{
BookName = Convert.ToString(dr["BookName"]),
BookId = Convert.ToInt32(dr["BookId"]),
DateRequested = Convert.ToString(Convert.ToDateTime(dr["DateRequested"]).ToShortDateString()),
});;
}
dgRequest.ItemsSource = lstRequest;
UserRecieveBL userRecieveBL = new UserRecieveBL();
DataSet ds2 = userRecieveBL.GetAllRecieveUserBL(userId);
ObservableCollection <AcceptedBook> lstReceived = new ObservableCollection <AcceptedBook>();
foreach (DataRow dr2 in ds2.Tables[0].Rows)
{
lstReceived.Add(new AcceptedBook
{
BookName = Convert.ToString(dr2["BookName"]),
BookId = Convert.ToInt32(dr2["BookId"]),
DateRecieved = Convert.ToString(Convert.ToDateTime(dr2["DateRecieved"]).ToShortDateString()),
});;
}
dgReturn.ItemsSource = lstReceived;
}
catch (Exception)
{
MessageBox.Show("Some unknown exception is occured!!!, Try again..");
}
}
