private void ClearBtn_Click(object sender, EventArgs e)
{
ISBNTxtBox.Clear();
CardIDTxtBox.Clear();
BorrTxtBox.Clear();
DateInTxtBox.Clear();
CheckInGBox.Hide();
Load_Loan_View();
}
private void ClrBtn_Click(object sender, EventArgs e)
{
SrchLoanBox.Clear();
Load_Loan_View();
if (CheckInGBox.Visible == true)
{
ISBNTxtBox.Clear();
CardIDTxtBox.Clear();
BorrTxtBox.Clear();
DateInTxtBox.Clear();
CheckInGBox.Hide();
}
if (AllLoanGrpBox.Visible == true)
{
SrchAllTxtBox.Clear();
AllLoanGrpBox.Hide();
}
}
private void CheckInBtn_Click(object sender, EventArgs e)
{
string Loan_ID = dataGridView1.CurrentRow.Cells["Loan_ID"].Value.ToString();
bool Check = Check_Book_Due_Date(Loan_ID);
if (Check == true)
{
CheckInGBox.Show();
ISBNTxtBox.Text = dataGridView1.CurrentRow.Cells["ISBN"].Value.ToString();
CardIDTxtBox.Text = dataGridView1.CurrentRow.Cells["Card_ID"].Value.ToString();
BorrTxtBox.Text = dataGridView1.CurrentRow.Cells["Name"].Value.ToString();
DateInTxtBox.Text = DateTime.Now.ToString("yyyy-MM-dd");
MessageBox.Show("Please verify the information is correct.");
}
else
{
MessageBox.Show("The loan has already been completed.");
}
}
private void ExecuteBtn_Click(object sender, EventArgs e)
{
string Loan_ID = dataGridView1.CurrentRow.Cells["Loan_ID"].Value.ToString();
string Date = DateTime.Now.ToString("yyyy-MM-dd");
string Query = "update book_loans set Date_In = '" + Date + "' where Loan_ID = '" + Loan_ID + "';";
try
{
MySqlCommand Comm = new MySqlCommand(Query, Connection);
MySqlDataReader Reader;
Reader = Comm.ExecuteReader();
MessageBox.Show("Check In Complete.");
Reader.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
Load_Loan_View();
CheckInGBox.Hide();
}
