private void Button2_Click(object sender, EventArgs e) { double dueAmount = 0; int rowIndex = returnRequestGridView.CurrentCell.RowIndex; DataGridViewRow row = returnRequestGridView.Rows[rowIndex]; DateTime returnDate = Convert.ToDateTime(row.Cells[3].Value); int issueID = Convert.ToInt32(row.Cells[0].Value); try { if (DateTime.Compare(DateTime.Today, returnDate) > 0) { if (txtOverdueAmount.Text.Trim() == "") { MessageBox.Show("AMOUNT CANNOT BE EMPTY"); } else { dueAmount = Convert.ToDouble(txtOverdueAmount.Text.Trim()); try { InsertQueries.InsertIntoOverdue(issueID, dueAmount, cmbPaidStatus.SelectedValue.ToString()); UpdateQueries.FinishReturnRequest(Convert.ToInt32(cmbReturnRequestID.SelectedValue.ToString())); UpdateQueries.UpdateIssueReturnRequest(issueID); UpdateQueries.IncreaseBookQuantity(SelectQueries.GetBookidFromIssueId(issueID)); MessageBox.Show("Return request successfully served"); ViewReturnRequests(); } catch (Exception exc) { Console.WriteLine(exc); } } } else { try { InsertQueries.InsertIntoReturn(issueID, DateTime.Now.Date.ToShortDateString()); UpdateQueries.FinishReturnRequest(Convert.ToInt32(cmbReturnRequestID.SelectedValue.ToString())); UpdateQueries.UpdateIssueReturnRequest(issueID); UpdateQueries.IncreaseBookQuantity(SelectQueries.GetBookidFromIssueId(issueID)); MessageBox.Show("Return request successfully served"); ViewReturnRequests(); } catch (Exception exc) { Console.WriteLine(exc); } } } catch (Exception ex) { MessageBox.Show("Due amount can only be in number"); Console.WriteLine(ex); } }
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); } }