public BookCategory GetBookCategory(int BookCategoryID)
{
BookCategory bookCategory = null;
SqlParameter[] Params = { new SqlParameter("@CategoryID", BookCategoryID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewSpecificBookCategory",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
bookCategory = new BookCategory();
bookCategory.BookCategoryID = Convert.ToInt32(row["BookCategoryID"]);
bookCategory.CategoryName = row["CategoryName"].ToString();
bookCategory.CategoryDescription = row["CategoryDescription"].ToString();
}
}
return bookCategory;
}
public List<BookCategory> CheckDuplicateBookCategory(string category)
{
List<BookCategory> categoryList = null;
SqlParameter[] Params = { new SqlParameter("@category", category) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_CheckDuplicateBookCategory", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
categoryList = new List<BookCategory>();
foreach (DataRow row in table.Rows)
{
BookCategory bookCategory = new BookCategory();
bookCategory.BookCategoryID = Convert.ToInt32(row["BookCategoryID"]);
bookCategory.CategoryName = row["CategoryName"].ToString();
bookCategory.CategoryDescription = row["CategoryDescription"].ToString();
categoryList.Add(bookCategory);
}
}
}
return categoryList;
}
public List<BookCategory> GetBookCategoryList()
{
List<BookCategory> bookCategoryList = null;
using (DataTable table = DataProvider.ExecuteSelectCommand("sp_ViewAllBookCategories",
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
bookCategoryList = new List<BookCategory>();
foreach (DataRow row in table.Rows)
{
BookCategory bookCategory = new BookCategory();
bookCategory.BookCategoryID = Convert.ToInt32(row["BookCategoryID"]);
bookCategory.CategoryName = row["CategoryName"].ToString();
bookCategory.CategoryDescription = row["CategoryDescription"].ToString();
bookCategoryList.Add(bookCategory);
}
}
}
return bookCategoryList;
}
public bool UpdateBookCategory(BookCategory bookCategory)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@bookCategoryID", bookCategory.BookCategoryID),
new SqlParameter("@CategoryName", bookCategory.CategoryName),
new SqlParameter("@CategoryDescription", bookCategory.CategoryDescription)
};
return DataProvider.ExecuteNonQuery("sp_UpdateBookCategory", CommandType.StoredProcedure,
Params);
}
public BookCategory SearchBookcategory(string Query)
{
BookCategory bookCategory = null;
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@CategoryDescription", Query) ///SEARCH
};
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("uspSearchBookCategory",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
bookCategory = new BookCategory();
bookCategory.BookCategoryID = Convert.ToInt32(row["BookCategory"]);
bookCategory.CategoryDescription = row["CategoryDescription"].ToString();
}
}
return bookCategory;
}
public bool UpdateBookType(BookCategory bookType)
{
BookCategoryHandler myHandler = new BookCategoryHandler(); return myHandler.UpdateBookCategory(bookType);
}
public bool AddBookType(BookCategory bookType)
{
BookCategoryHandler myHander = new BookCategoryHandler();
return myHander.InsertBookCategory(bookType);
}
public List<Book> GetNewBookList()
{
List<Book> BookList = null;
using (DataTable table = DataProvider.ExecuteSelectCommand("sp_ViewAllNewBooks",
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
BookList = new List<Book>();
foreach (DataRow row in table.Rows)
{
Book book = new Book();
BookCategory bc = new BookCategory();
book.BookID = (int)row["BookID"];
book.ProductID = (int)row["ProductID"];
book.BookTitle = row["BookTitle"].ToString();
book.Synopsis = row["Synopsis"].ToString();
book.SupplierID = Convert.ToInt32(row["SupplierID"].ToString());
book.ISBN = row["ISBN"].ToString();
book.CostPrice = Convert.ToDouble(row["CostPrice"]);
book.SellingPrice = Convert.ToDouble(row["SellingPrice"]);
book.BookCategoryID = (int)row["BookCategoryID"];
book.CoverImage = row["CoverImage"].ToString();
book.BookTitle = book.BookTitle.Substring(0, Math.Min(11, book.BookTitle.Length));
book.BookTitle += "...";
BookList.Add(book);
}
}
}
return BookList;
}
