public List<BookBorrow> ShowBorrowedBooks(int memberNo)
{
List<BookBorrow> aBookList = new List<BookBorrow>();
string query = "SELECT * FROM tbl_borrow WHERE MemberNo='" + memberNo + "'";
SqlConnection aConnection = new SqlConnection(connectionString);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
SqlDataReader aReader = aCommand.ExecuteReader();
while (aReader.Read())
{
// Setup DataReader
// Set DR values to Text fields
BookBorrow aBook = new BookBorrow();
aBook.Title = aReader["selectabook"].ToString();
aBookList.Add(aBook);
}
aReader.Close();
aConnection.Close();
return aBookList;
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
//List<BookBorrow> aBook=new List<BookBorrow>();
BookBorrow aBook = new BookBorrow();
string bookName = Convert.ToString(bookDropDownList.SelectedItem);
//
aBook = aManager.ShowInTextBox(bookName);
authorTextBox.Text = aBook.Author;
publisherTextBox.Text = aBook.Publisher;
aBook.MemberNo = Convert.ToInt32(memberNoTextBox.Text);
}
public string ReturnBorrowedBook(BookBorrow aEntry)
{
string massege = " ";
string query = "DELETE FROM tbl_borrow WHERE Title='" + aEntry.Title + "'";
SqlConnection aConnection = new SqlConnection(connectionString);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
int rowAffected = aCommand.ExecuteNonQuery();
aConnection.Close();
return massege = "A Book Has Been Returned By " + aEntry.MemberNo;
}
public string BorrowBookEntry(BookBorrow aEntry)
{
string massege = " ";
string query = "INSERT INTO tbl_borrow VALUES ('" + aEntry.Title + "','" + aEntry.Author + "', '" + aEntry.Publisher + "','"+aEntry.MemberNo+"');";
SqlConnection aConnection = new SqlConnection(connectionString);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
int rowAffected = aCommand.ExecuteNonQuery();
aConnection.Close();
return massege = "A Book Has Been Borrowed By " +aEntry.MemberNo ;
}
protected void borrowButton_Click(object sender, EventArgs e)
{
BookBorrow aBook = new BookBorrow();
aBook.Author = authorTextBox.Text;
aBook.Publisher = publisherTextBox.Text;
aBook.MemberNo = Convert.ToInt32(memberNoTextBox.Text);
aBook.Title = Convert.ToString(bookDropDownList.SelectedItem);
if (memberNoTextBox.Text==string.Empty)
{
msgLabel.Text = "Please Enter a Member ID";
}
else
{
msgLabel.Text = aManager.BorrowBookEntry(aBook);
}
}
public BookBorrow ShowInTextBox(string bookName)
{
List<BookBorrow> aBookList = new List<BookBorrow>();
string query = "SELECT * FROM tbl_book WHERE Title='"+bookName+"'";
SqlConnection aConnection = new SqlConnection(connectionString);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
SqlDataReader aReader = aCommand.ExecuteReader();
BookBorrow aBook = new BookBorrow();
if (aReader.HasRows)
{
aReader.Read();
// Setup DataReader
// Set DR values to Text fields
aBook.Author = aReader["author"].ToString();
aBook.Publisher = aReader["publisher"].ToString();
}
aReader.Close();
aConnection.Close();
return aBook;
}