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; }