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)
{
}
}
