public string Save(Book aBook )
{
if (bookGateway.HasBookName(aBook.Title))
{
throw new Exception("This system has this book name.Please try again.");
}else if (bookGateway.HasISBNNo(aBook.ISbnNo))
{
throw new Exception("This system already have this ISBN No.Please try again.");
}
else
{
return bookGateway.Save(aBook);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
Book aBook=new Book();
if (booknameTextBox.Text == string.Empty)
{
MessageBox.Show(@"Please entre book title.","Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (authorNameTextBox.Text == string.Empty)
{
MessageBox.Show("Please entre the author name.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else if (iSBNNoTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre ISBN no.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (priceTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre the prie of this book.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else if (noOfInitiatCopyTextBox.Text==string.Empty)
{
MessageBox.Show("Give how many book in your store.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
string message = null;
try
{
aBook.Id = Convert.ToInt32(bookIdTextBox.Text);
aBook.Title = booknameTextBox.Text;
aBook.AuthorName = authorNameTextBox.Text;
aBook.ISbnNo = iSBNNoTextBox.Text;
aBook.Price = Convert.ToInt32(priceTextBox.Text);
aBook.InitialCopy = Convert.ToInt32(noOfInitiatCopyTextBox.Text);
aBook.OutsideCopy = 0;
message = bookManager.Save(aBook);
MessageBox.Show(message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearAll();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public Book SearchBook(int bookId)
{
Book aBook = new Book();
try
{
SqlConnectionObj.Open();
string query = string.Format("select * from tbl_book where Id='{0}'", bookId);
SqlCommandObj.CommandText = query;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
aBook.Id = Convert.ToInt32(reader["Id"]);
aBook.Title = reader["Title"].ToString();
aBook.AuthorName = reader["AuthorName"].ToString();
aBook.ISbnNo = reader["IsbnNo"].ToString();
aBook.InitialCopy = Convert.ToInt32(reader["InitialCopy"]);
aBook.OutsideCopy = Convert.ToInt32(reader["OutsideCopy"]);
aBook.Price = Convert.ToInt32(reader["Price"]);
}
}
catch (Exception exception)
{
throw new Exception("Error occurred during search this book.",exception);
}
finally
{
SqlConnectionObj.Close();
}
return aBook;
}
public string Save(Book aBook)
{
try
{
SqlConnectionObj.Open();
string query = string.Format("INSERT INTO tbl_book VALUES({0},'{1}','{2}','{3}',{4},{5},{6})",aBook.Id, aBook.Title, aBook.AuthorName, aBook.ISbnNo, aBook.Price, aBook.InitialCopy,aBook.OutsideCopy);
SqlCommandObj.CommandText = query;
SqlCommandObj.ExecuteNonQuery();
return "Book have been saved.";
}
catch (Exception ex)
{
throw new Exception("Book couldn't be saved.",ex);
}finally
{
SqlConnectionObj.Close();
}
}
public List<Book> GetAllBooks(string name, string searchType)
{
List<Book> books=new List<Book>();
try
{
SqlConnectionObj.Open();
if (searchType == "name")
{
string quere = string.Format("select * from tbl_book where Title like '%{0}%'", name );
SqlCommandObj.CommandText = quere;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
Book aBook = new Book();
aBook.Id = Convert.ToInt32(reader["Id"]);
aBook.Title = reader["Title"].ToString();
aBook.AuthorName = reader["AuthorName"].ToString();
aBook.InitialCopy = Convert.ToInt32(reader["InitialCopy"]);
aBook.OutsideCopy = Convert.ToInt32(reader["OutsideCopy"]);
aBook.Price = Convert.ToInt32(reader["Price"]);
books.Add(aBook);
}
}
else if (searchType == "author")
{
string quere = string.Format("select * from tbl_book where AuthorName like '%{0}%'", name);
SqlCommandObj.CommandText = quere;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
Book aBook = new Book();
aBook.Id = Convert.ToInt32(reader["Id"]);
aBook.Title = reader["Title"].ToString();
aBook.AuthorName = reader["AuthorName"].ToString();
aBook.InitialCopy = Convert.ToInt32(reader["InitialCopy"]);
aBook.OutsideCopy = Convert.ToInt32(reader["OutsideCopy"]);
aBook.Price = Convert.ToInt32(reader["Price"]);
books.Add(aBook);
}
}
else if (searchType == "bookId")
{
string quere = string.Format("select * from tbl_book where Id={0}", name);
SqlCommandObj.CommandText = quere;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
Book aBook = new Book();
aBook.Id = Convert.ToInt32(reader["Id"]);
aBook.Title = reader["Title"].ToString();
aBook.AuthorName = reader["AuthorName"].ToString();
aBook.InitialCopy = Convert.ToInt32(reader["InitialCopy"]);
aBook.OutsideCopy = Convert.ToInt32(reader["OutsideCopy"]);
aBook.Price = Convert.ToInt32(reader["Price"]);
books.Add(aBook);
}
}
}
catch (Exception exception)
{
throw new Exception("Error occurred during books loading from your system.", exception);
}finally
{
SqlConnectionObj.Close();
}
return books;
}
public Book GetBooks(int toInt32)
{
try
{
SqlConnectionObj.Open();
string query = string.Format("select * from tbl_book where Id={0}", toInt32);
SqlCommandObj.CommandText = query;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
Book aBook=new Book();
while (reader.Read())
{
aBook.Id = Convert.ToInt32(reader[0]);
aBook.Title = reader[1].ToString();
aBook.AuthorName = reader[2].ToString();
aBook.ISbnNo = reader[3].ToString();
aBook.Price = Convert.ToInt32(reader[4]);
}
return aBook;
}
catch (Exception exception)
{
throw new Exception("System can not return those books.",exception);
}
finally
{
SqlConnectionObj.Close();
}
}
private void addButton_Click(object sender, EventArgs e)
{
addIssueBooksDataGridView.DataSource = null;
int i = 0;
Book aBook = new Book();
aBook.Id = Convert.ToInt32(bookSearchtextBox.Text);
aBook.Title = bookNameTextBox.Text;
aBook.AuthorName = bookAuthorTextBox.Text;
aBook.OutsideCopy = Convert.ToInt32(bookLendTextBox.Text);
if (books.Count<1)
{
if (Convert.ToInt32(bookAvailableTextBox.Text) - Convert.ToInt32(bookLendTextBox.Text) >= 0)
{
if(Convert.ToInt32(bookLendTextBox.Text) !=0)
{
books.Add(aBook);
LoadDatagridview(books);
}
else
{
MessageBox.Show("Please insert how many books you want.");
}
}
else
{
MessageBox.Show("");
}
}
else
{
foreach (Book book in books)
{
if (book.Id==aBook.Id)
{
i = 1;
int noOfBook = book.OutsideCopy + aBook.OutsideCopy;
if (Convert.ToInt32(bookAvailableTextBox.Text)-noOfBook>=0)
{
book.OutsideCopy += aBook.OutsideCopy;
goto solution;
}
else
{
MessageBox.Show("No available book to lend");
}
}
}
solution:
if (i == 0)
{
if (Convert.ToInt32(bookAvailableTextBox.Text) - aBook.OutsideCopy >= 0)
{
books.Add(aBook);
LoadDatagridview(books);
}
else
{
MessageBox.Show("No available book to lend");
LoadDatagridview(books);
}
}
else
{
LoadDatagridview(books);
}
}
}
private void bookSerachButton_Click(object sender, EventArgs e)
{
if (bookSearchtextBox.Text!="")
{
try
{
bookId = Convert.ToInt32(bookSearchtextBox.Text);
Book book = new Book();
book = bookManager.SearchBook(bookId);
bookNameTextBox.Text = book.Title;
bookAuthorTextBox.Text = book.AuthorName;
bookAvailableTextBox.Text = book.InitialCopy.ToString();
bookLendTextBox.Text = "0";
if (book.InitialCopy<1)
{
bookLendTextBox.ReadOnly = true;
}
else
{
addButton.Enabled = true;
groupBox2.Enabled = true;
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Please Fill the book ID text box.");
}
}
