private void Button6_Click(object sender, EventArgs e)
{
int issueID = Convert.ToInt32(cmbIssueID_return.SelectedValue.ToString());
string newDate = newReturnDate.Value.ToShortDateString();
int bookID = SelectQueries.GetBookidFromIssueId(issueID);
int crntIssueReq = SelectQueries.GetBookCountInIssueRequests(bookID);
//Book issue can be extended as no issue requests are there for that book
if (crntIssueReq == 0)
{
UpdateQueries.UpdateReturnDate(issueID, newDate);
string message = "Return Date successfully changed";
MessageBox.Show(message, "DONE", MessageBoxButtons.OK, MessageBoxIcon.Information);
ViewToUpdateReturns();
}
else
{
string message = "Cannot change return date as there is a issue request for same book";
MessageBox.Show(message, "PROBIHATED", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}