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 ExtendDateBtn_Click(object sender, RoutedEventArgs e)
{
try
{
if (ReturnDateDP.SelectedDate == null && DeadlineDP.SelectedDate == null)
{
MessageBox.Show(
messageBoxText: "Please enter valid Values.",
caption: "Error",
button: MessageBoxButton.OK,
MessageBoxImage.Error);
ReturnDateDP.Focus();
DeadlineDP.Focus();
}
else
{
con.Open();
cmd = new SqlCommand("Update BorrowedBooks Set ReturnDate=@ReturnDate, DeadlineDate=@DeadLineDate Where UserId ='" + MemberDashboard.SetValueForUserId + "'and BookId ='" + BookIdTxtBx.Text + "'", con);
cmd.Parameters.Add("@ReturnDate", ReturnDateDP.SelectedDate);
cmd.Parameters.Add("@DeadLineDate", DeadlineDP.SelectedDate);
cmd.ExecuteNonQuery();
MessageBox.Show(
messageBoxText: $"the Book Return Date Successfully Extended",
caption: "Successful",
button: MessageBoxButton.OK,
icon: MessageBoxImage.Information);
con.Close();
new MemberborrowedBook().Show();
Close();
}
}
catch (Exception b)
{
MessageBox.Show(
messageBoxText: "Exception occur :" + b.Message + "\t" + b.GetType(),
caption: "Exception",
button: MessageBoxButton.OK,
icon: MessageBoxImage.Error);
}
}
