private void t5btnReturn_Click(object sender, EventArgs e)
{
int tkd = 6, tkm = -1;
//code for tkd
Student s = new Student();
s.StudentID = t5txtReturntStudentID.Text;
DataTable dts = s.search();
if (dts.Rows.Count == 0)
{
MessageBox.Show("چنین دانشجویی نداریم");
}
else
{
tkd = Convert.ToInt32(dts.Rows[0]["borrowedBookQty"].ToString());
}
//code for tkm
Book b = new Book();
b.BookCategorizationNo = t5txtReturnCategorizationNo.Text;
DataTable dtb = b.search();
if (dtb.Rows.Count == 0)
{
MessageBox.Show("چنین کتابی نداریم");
}
else
{
tkm = Convert.ToInt32(dtb.Rows[0]["bookQty"].ToString());
}
if (tkd == 0)
{
MessageBox.Show("این دانشجو کتابی در دست امانت ندارد");
}
if ((dts.Rows.Count != 0) && (dtb.Rows.Count != 0) && (tkd != 0))
{
Borrow borrow = new Borrow();
borrow.StudentID = t5txtReturntStudentID.Text;
borrow.BookCategorizationNo = t5txtReturnCategorizationNo.Text;
borrow.ReturnDate = t5txtReturnYear.Text + "/" + t5txtReturnMonth.Text + "/" + t5txtReturnDay.Text;
borrow.updateBorrow();
tkm++;
tkd--;
s.BorrowedBookQty = Convert.ToString(tkd);
s.edit_std_amanat();
b.BookQty = Convert.ToString(tkm);
b.edit_book_amanat();
}
t5txtReturntStudentID.Text = "";
t5txtReturnCategorizationNo.Text = "";
t5txtReturnYear.Text = "";
t5txtReturnMonth.Text = "";
t5txtReturnDay.Text = "";
}
