//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.."); } }