private void SearchBookByPrice(string v) { _sb._Price = float.Parse(searchtxt.Text); _sb.Execute("SearchBookByPriceCapability"); if (_sb.Success != null) { BookDT = (DataTable)_sb.Success; BookGV.DataSource = BookDT; BookGV.DataBind(); if (_sb._SearchBookByBookPriceCount > 0) { double vc = _sb._SearchBookByBookPriceCount; double vp = _sb._PageSize; double c = vc / vp; double m = Math.Ceiling(c); if (_pageCount != m) { _pageCount = m; indexToplbl.Text = _sb._Top.ToString(); bookPagesTop.Text = _pageCount.ToString(); indexBottomlbl.Text = _sb._Top.ToString(); bookPagesbottom.Text = _pageCount.ToString(); } indexToplbl.Text = _sb._Top.ToString(); indexBottomlbl.Text = _sb._Top.ToString(); } } }
private void Search(string v, string f, int t, int p) { _sb._Title = v; _sb._Flag = f; _sb._Top = t; _sb._PageSize = p; _sb.Execute("SearchBookByTitleCapability"); if (_sb.Success != null) { if (_sb._Flag == "C") { if (_sb._SearchBookByTitleCount > 0) { maxTop = Math.Ceiling((double)_sb._SearchBookByTitleCount / (double)_sb._PageSize); totalRecordslbl.Visible = true; totalRecordslbl.Text = _sb._SearchBookByTitleCount.ToString(); } } searchBookDT = (DataTable)_sb.Success; BookGV.DataSource = searchBookDT; BookGV.DataBind(); } }
private void GetBooks() { _cb.Execute("SelectAllBookCapability"); if (_cb.Success != null) { BookDT = (DataTable)_cb.Success; BookGV.DataSource = BookDT; BookGV.DataBind(); indexToplbl.Text = _cb._Top.ToString(); indexBottomlbl.Text = _cb._Top.ToString(); } }
private void GetBooksByCategory() { try { _cb.Execute("SelectBookByCategoryIdCapability"); if (_cb.Success != null) { DataTable BookDT = (DataTable)_cb.Success; BookGV.DataSource = BookDT; BookGV.DataBind(); } } catch (Exception) { } }
private void DisplayBook(int index) { try { _cb._Top = index; _cb._PageSize = 1000; _cb._Flag = "C"; _cb.Execute("SelectAllBookCapability"); if (_cb.Success != null) { BookDT = (DataTable)_cb.Success; BookGV.DataSource = BookDT; BookGV.DataBind(); } } catch (Exception) { } }