}//ReturnBook
void IssueBook()
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO tbl_book_issue(member_id,member_name,book_id,book_name,issue_date,due_date) values(@member_id,@member_name,@book_id,@book_name,@issue_date,@due_date)", con);
cmd.Parameters.AddWithValue("@member_id", MemberID.Text.Trim());
cmd.Parameters.AddWithValue("@member_name", MemberName.Text.Trim());
cmd.Parameters.AddWithValue("@book_id", BookID.Text.Trim());
cmd.Parameters.AddWithValue("@book_name", BookName.Text.Trim());
cmd.Parameters.AddWithValue("@issue_date", BookIssueDate.Text.Trim());
cmd.Parameters.AddWithValue("@due_date", BookReturnDate.Text.Trim());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("UPDATE tbl_book SET current_stock = current_stock-1 WHERE book_id='" + BookID.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Book Issued Successfully');</script>");
GridBookIssue.DataBind();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}//IssueBook
}//Go
//Defined Methods
void ReturnBook()
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Delete from tbl_book_issue WHERE book_id='" + BookID.Text.Trim() + "' AND member_id='" + MemberID.Text.Trim() + "'", con);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
cmd = new SqlCommand("UPDATE tbl_book SET current_stock = current_stock+1 WHERE book_id='" + BookID.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Book Returned Successfully');</script>");
GridBookIssue.DataBind();
con.Close();
}
else
{
Response.Write("<script>alert('Error - Invalid details');</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}//ReturnBook
protected void Page_Load(object sender, EventArgs e)
{
GridBookIssue.DataBind();
}//pageload