//private void RefreshPagination2()
//{
// ToolStripButton[] items = new ToolStripButton[] { toolStripButton8, toolStripButton9, toolStripButton10, toolStripButton11, toolStripButton12 };
// //pageStartIndex contains the first button number of pagination.
// int pageStartIndex = 1;
// if (pageTotal > 5 && currentPage > 2)
// pageStartIndex = currentPage - 2;
// if (pageTotal > 5 && currentPage > pageTotal - 2)
// pageStartIndex = pageTotal - 4;
// for (int i = pageStartIndex; i < pageStartIndex + 5; i++)
// {
// if (i > pageTotal)
// {
// items[i - pageStartIndex].Visible = false;
// }
// else
// {
// //Changing the page numbers
// items[i - pageStartIndex].Text = i.ToString(CultureInfo.InvariantCulture);
// items[i - pageStartIndex].Visible = true;
// //Setting the Appearance of the page number buttons
// if (i == currentPage)
// {
// items[i - pageStartIndex].BackColor = Color.Black;
// items[i - pageStartIndex].ForeColor = Color.White;
// }
// else
// {
// items[i - pageStartIndex].BackColor = Color.White;
// items[i - pageStartIndex].ForeColor = Color.Black;
// }
// }
// }
// //Enabling or Disalbing pagination first, last, previous , next buttons
// if (currentPage == 1)
// btnBackward.Enabled = btnFirst.Enabled = false;
// else
// btnBackward.Enabled = btnFirst.Enabled = true;
// if (currentPage == pageTotal)
// btnForward.Enabled = btnLast.Enabled = false;
// else
// btnForward.Enabled = btnLast.Enabled = true;
//}
private void RebindGridForPageChange(string keyword)
{
total = 0;
try
{
switch (tabControl1.SelectedIndex)
{
case TAB_AVERAGE:
dgvAvgAccessHis.DataSource = m_avrMgr.SelectAccessHistoryInfo(dtpAvgDate.Value);
dgvAvgAccessHis.Refresh();
break;
case TAB_ACCESS:
//dt = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
//dgvAccessUser.DataSource = dt;
//dgvAccessUser.Refresh();
//total = Int32.Parse(dgvAccessUser.Rows[0].Cells["count"].Value.ToString());
dgvAccessInfo.DataSource = m_accessDB.GetAccessInfoDBTable(m_user.Id, currentPage, GetPageCount());
dgvAccessInfo.Refresh();
total = Int32.Parse(dgvAccessInfo.Rows[0].Cells["count"].Value.ToString());
break;
case TAB_USER:
dgvUser.DataSource = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
dgvUser.Refresh();
total = Int32.Parse(dgvUser.Rows[0].Cells["count"].Value.ToString());
break;
case TAB_CAR:
dgvCar.DataSource = m_carDB.GetCarInfoDBTable(keyword, currentPage, GetPageCount());
dgvCar.Refresh();
total = Int32.Parse(dgvCar.Rows[0].Cells["count"].Value.ToString());
break;
case TAB_ACCESS_HIS:
dgvHistory.DataSource = m_historyDB.GetAccessHisDBTable(keyword, currentPage, GetPageCount());
dgvHistory.Refresh();
total = Int32.Parse(dgvHistory.Rows[0].Cells["count"].Value.ToString());
break;
}
pageTotal = Convert.ToInt32(Math.Ceiling(total * 1.0 / ((GetPageCount()) < 1 ? 1 : GetPageCount())));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
private void RebindGridForPageChange(string keyword)
{
total = 0;
try
{
DataTable tmp;
if (tabAvg.IsSelected)
{
tmp = m_avrMgr.SelectAccessHistoryInfo(dtpAvgDate.SelectedDate.Value);
dgvAvgInfo.ItemsSource = tmp.DefaultView;
}
else if (tabAccess.IsSelected)
{
//dt = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
//dgvAccessUser.DataSource = dt;
//dgvAccessUser.Refresh();
//total = Int32.Parse(dgvAccessUser.Rows[0].Cells["count"].Value.ToString());
tmp = m_accessDB.GetAccessInfoDBTable(m_user.Id, currentPage, GetPageCount());
dgvAccessInfo.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[6].ToString());
}
else if (tabUser.IsSelected)
{
tmp = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
dgvUser.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[6].ToString());
}
else if (tabCar.IsSelected)
{
tmp = m_carDB.GetCarInfoDBTable(keyword, currentPage, GetPageCount());
dgvCar.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[3].ToString());
}
else if (tabHistory.IsSelected)
{
tmp = m_historyDB.GetAccessHisDBTable(keyword, currentPage, GetPageCount());
dgvHistory.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[5].ToString());
}
pageTotal = Convert.ToInt32(Math.Ceiling(Total * 1.0 / ((GetPageCount()) < 1 ? 1 : GetPageCount())));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
