private void SearchBtn_Click(object sender, RoutedEventArgs e) { string UserId = UserIdTxtBx.Text; try { if (string.IsNullOrEmpty(UserId)) { MessageBox.Show( messageBoxText: "Please enter valid Values.", caption: "Error", button: MessageBoxButton.OK, MessageBoxImage.Error); UserIdTxtBx.Focus(); } else { con.Open(); SqlCommand checkUser = new SqlCommand("SELECT COUNT(*) FROM Users WHERE Id= @Id", con); checkUser.Parameters.AddWithValue("@Id", UserIdTxtBx.Text); int BookExist = (int)checkUser.ExecuteScalar(); if (BookExist > 0) { SetValueForUserId = int.Parse(UserIdTxtBx.Text); new EditMemberInformation().Show(); Close(); } else { MessageBox.Show( messageBoxText: "User Not Found!", caption: "Error", button: MessageBoxButton.OK, MessageBoxImage.Error); } } } catch (Exception b) { MessageBox.Show( messageBoxText: "Exception occur :" + b.Message + "\t" + b.GetType(), caption: "Exception", button: MessageBoxButton.OK, icon: MessageBoxImage.Error); } }
private void BorrowBtn_Click(object sender, RoutedEventArgs e) { try { string BookId = BookIdTxtBx.Text; string UserId = UserIdTxtBx.Text; if (string.IsNullOrEmpty(BookId) && string.IsNullOrEmpty(UserId) && ReturnDateDP.SelectedDate == null && DeadlineDateDp.SelectedDate == null) { MessageBox.Show( messageBoxText: "Please enter valid Values.", caption: "Error", button: MessageBoxButton.OK, MessageBoxImage.Error); BookIdTxtBx.Focus(); UserIdTxtBx.Focus(); ReturnDateDP.Focus(); DeadlineDateDp.Focus(); } else { con.Open(); cmd = new SqlCommand("INSERT INTO BorrowedBooks (BookId,UserId,ReturnDate,DeadLineDate,IssueDate) VALUES (@BookId,@UserId,@ReturnDate,@DeadLineDate,@IssueDate)", con); cmd.Parameters.Add("@BookId", BookIdTxtBx.Text); cmd.Parameters.Add("@UserId", UserIdTxtBx.Text); cmd.Parameters.Add("@ReturnDate", ReturnDateDP.SelectedDate); cmd.Parameters.Add("@DeadLineDate", DeadlineDateDp.SelectedDate); cmd.Parameters.Add("@IssueDate", DateTime.Now); cmd.ExecuteNonQuery(); MessageBox.Show( messageBoxText: $"Book with Book Id : «{BookIdTxtBx.Text}» successfully Borrowed.", caption: "Successful Adding", button: MessageBoxButton.OK, icon: MessageBoxImage.Information); con.Close(); } } catch (Exception b) { MessageBox.Show( messageBoxText: "Exception occur :" + b.Message + "\t" + b.GetType(), caption: "Exception", button: MessageBoxButton.OK, icon: MessageBoxImage.Error); } }
private void BorrowBtn_Click(object sender, RoutedEventArgs e) { try { string BookId = BookIdTxtBx.Text; string UserId = UserIdTxtBx.Text; if (string.IsNullOrEmpty(BookId) && string.IsNullOrEmpty(UserId)) { MessageBox.Show( messageBoxText: "Please enter valid Values.", caption: "Error", button: MessageBoxButton.OK, MessageBoxImage.Error); BookIdTxtBx.Focus(); UserIdTxtBx.Focus(); } else { con.Open(); SqlCommand checkdata = new SqlCommand("SELECT COUNT(*) From BorrowedBooks WHERE BookId= @BookId and UserId=@UserId", con); checkdata.Parameters.AddWithValue("@BookId", BookIdTxtBx.Text); checkdata.Parameters.AddWithValue("@UserId", UserIdTxtBx.Text); int BookExist = (int)checkdata.ExecuteScalar(); con.Close(); if (BookExist > 0) { con.Open(); cmd = new SqlCommand("Delete From BorrowedBooks Where BookId=@BookId and UserId=@UserId", con); cmd.Parameters.AddWithValue("@BookId", BookIdTxtBx.Text); cmd.Parameters.AddWithValue("@UserId", UserIdTxtBx.Text); int deleted = cmd.ExecuteNonQuery(); MessageBox.Show( messageBoxText: $"The Book successfully Borrowed Back", caption: "Successful", button: MessageBoxButton.OK, icon: MessageBoxImage.Information); } else { MessageBox.Show( messageBoxText: "the enterd record not Found.", caption: "Error", button: MessageBoxButton.OK, MessageBoxImage.Error); } } } catch (Exception b) { MessageBox.Show( messageBoxText: "Exception occur :" + b.Message + "\t" + b.GetType(), caption: "Exception", button: MessageBoxButton.OK, icon: MessageBoxImage.Error); } }