static void UpdateBookById()
{
try
{
Book book = new Book();
Console.Write("Enter the book ID for update : ");
book.BookID = int.Parse(Console.ReadLine());
Console.Write("Enter the book name for update : ");
book.BookName = Console.ReadLine();
Console.Write("Enter the author name for update : ");
book.AuthorName = Console.ReadLine();
Console.Write("Enter the publisher name for update : ");
book.Publisher = Console.ReadLine();
Console.Write("Enter the number of this book for update : ");
book.NoOfCopies = int.Parse(Console.ReadLine());
Console.Write("Enter the book price for update : ");
book.Price = int.Parse(Console.ReadLine());
BusinessLayer bll = new BusinessLayer();
bll.UpdateBook(book);
Console.WriteLine("Updated record successfully");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
static void DisplayAllBooks()
{
BusinessLayer bll = new BusinessLayer();
List <Book> lstBooks = bll.GetAllBooks();
foreach (Book book in lstBooks)
{
Console.WriteLine(book.BookID + "\t\t" + book.BookName + "\t\t" + book.AuthorName + "\t\t"
+ book.Publisher + "\t\t" + book.NoOfCopies + "\t\t" + book.Price);
}
}
static void DeleteBookById()
{
try
{
BusinessLayer bll = new BusinessLayer();
Console.Write("Enter the bookID to delete the book detail : ");
int bookID = int.Parse(Console.ReadLine());
bll.DeleteBook(bookID);
Console.WriteLine("Record deleted successfully....");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
static void SearchBookById()
{
try
{
int bookID;
Book book = null;
Console.Write("Enter bookID for search : ");
bookID = int.Parse(Console.ReadLine());
//search book using business layer
BusinessLayer bll = new BusinessLayer();
book = bll.SelectBookById(bookID);
Console.WriteLine(book.BookID + "\t\t" + book.BookName + "\t\t" + book.AuthorName + "\t\t"
+ book.Publisher + "\t\t" + book.NoOfCopies + "\t\t" + book.Price);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
static void SearchBookByBookName()
{
try
{
List <Book> lstBooks = new List <Book>();
Console.Write("Enter the book name to search : ");
string bookName = Console.ReadLine();
//search book using business layer
BusinessLayer bll = new BusinessLayer();
lstBooks = bll.SelectBookByBookName(bookName);
foreach (Book book in lstBooks)
{
Console.WriteLine(book.BookID + "\t\t" + book.BookName + "\t\t" + book.AuthorName + "\t\t"
+ book.Publisher + "\t\t" + book.NoOfCopies + "\t\t" + book.Price);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
static void AddBook()
{
Book book = new Book();
Console.Write("Enter the book ID : ");
book.BookID = int.Parse(Console.ReadLine());
Console.Write("Enter the book name : ");
book.BookName = Console.ReadLine();
Console.Write("Enter the author name : ");
book.AuthorName = Console.ReadLine();
Console.Write("Enter the publisher name : ");
book.Publisher = Console.ReadLine();
Console.Write("Enter the number of this book : ");
book.NoOfCopies = int.Parse(Console.ReadLine());
Console.Write("Enter the book price : ");
book.Price = int.Parse(Console.ReadLine());
//insert using Business Layer
BusinessLayer bll = new BusinessLayer();
bll.AddBook(book);
Console.WriteLine("Record inserted successfully");
}