private void reserve_Click(object sender, EventArgs e)
{
if (userLevel == "Library_Staff")
{
levelUser = connection.getUserState(user_text.Text);
}
else
{
levelUser = userLevel;
}
alowed = connection.usrAdminChk(levelUser);
dr = connection.usrReservChk(user_text.Text);
dr.Read();
userbook = Convert.ToInt32(dr[5].ToString());
resrv = Convert.ToInt32(dr[6].ToString());
dr = connection.BookChk(title_text.Text);
dr.Read();
book = Convert.ToInt32(dr[3].ToString());
issued = Convert.ToInt32(dr[4].ToString());
if (resrv + userbook <= alowed)
{
if (book == issued)
{
connection.setReserv(user_text.Text, title_text.Text);
MessageBox.Show("Book is reserved.");
}
else
{
MessageBox.Show("Book is available in the library");
}
}
else
{
MessageBox.Show("User can't reserve any more books");
}
}
public String usertype(String username)
{
return(connection.getUserState(username));
}