private void filterByTime_CheckedChanged(object sender, EventArgs e)
{
tuDateTime.Enabled = !tuDateTime.Enabled;
denDateTime.Enabled = !denDateTime.Enabled;
currentPageNumber = 1;
pageNumberTextBox.Text = currentPageNumber.ToString();
if (filterByTime.Checked)
{
maxPageNumber = BillBUS.GetMaxPageNumberByTime(int.Parse(billsPerPageComboBox.Text), tuDateTime.Value, denDateTime.Value);
maxPageNumberLabel.Text = "/ " + maxPageNumber;
dgv3.DataSource = BillBUS.LoadAllByTime(currentPageNumber, int.Parse(billsPerPageComboBox.Text), tuDateTime.Value, denDateTime.Value);
}
else
{
maxPageNumber = BillBUS.GetMaxPageNumber(int.Parse(billsPerPageComboBox.Text));
maxPageNumberLabel.Text = "/ " + maxPageNumber;
dgv3.DataSource = BillBUS.LoadAll(currentPageNumber, int.Parse(billsPerPageComboBox.Text));
}
truocTile.Visible = false;
if (maxPageNumber == 1)
{
sauTile.Visible = false;
}
else
{
sauTile.Visible = true;
}
}
private void pageNumberTextBox_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
if (pageNumberTextBox.Text == string.Empty || !pageNumberTextBox.Text.All(char.IsDigit))
{
pageNumberTextBox.Text = currentPageNumber.ToString();
}
else
{
truocTile.Visible = true;
sauTile.Visible = true;
int result;
if (int.TryParse(pageNumberTextBox.Text, out result))
{
if (result < 1)
{
pageNumberTextBox.Text = 1.ToString();
}
if (result > maxPageNumber)
{
pageNumberTextBox.Text = maxPageNumber.ToString();
}
}
else
{
pageNumberTextBox.Text = currentPageNumber.ToString();
}
currentPageNumber = int.Parse(pageNumberTextBox.Text);
if (currentPageNumber == 1)
{
truocTile.Visible = false;
}
if (currentPageNumber == maxPageNumber)
{
sauTile.Visible = false;
}
if (filterByTime.Checked)
{
dgv3.DataSource = BillBUS.LoadAllByTime(currentPageNumber, int.Parse(billsPerPageComboBox.Text), tuDateTime.Value, denDateTime.Value);
}
else
{
dgv3.DataSource = BillBUS.LoadAll(currentPageNumber, int.Parse(billsPerPageComboBox.Text));
}
}
}
}
private void sauTile_Click(object sender, EventArgs e)
{
truocTile.Visible = true;
currentPageNumber++;
pageNumberTextBox.Text = currentPageNumber.ToString();
if (filterByTime.Checked)
{
dgv3.DataSource = BillBUS.LoadAllByTime(currentPageNumber, int.Parse(billsPerPageComboBox.Text), tuDateTime.Value, denDateTime.Value);
}
else
{
dgv3.DataSource = BillBUS.LoadAll(currentPageNumber, int.Parse(billsPerPageComboBox.Text));
}
if (currentPageNumber == maxPageNumber)
{
sauTile.Visible = false;
}
}
private void frmQuanLy_Load(object sender, EventArgs e)
{
tabControl.SelectedTab = tabNhanVien;
maxPageNumber = BillBUS.GetMaxPageNumber(int.Parse(billsPerPageComboBox.Text));
maxPageNumberLabel.Text = "/ " + maxPageNumber.ToString();
if (maxPageNumber == 1)
{
sauTile.Visible = false;
}
minYear = BillBUS.GetMinYear();
maxYear = BillBUS.GetMaxYear();
for (int i = minYear; i <= maxYear; i++)
{
namComboBox.Items.Add(i);
}
if (namComboBox.Items.Count > 0)
{
namComboBox.SelectedItem = namComboBox.Items[namComboBox.Items.Count - 1];
}
else
{
namComboBox.SelectedItem = 1;
}
namRadioButton.Checked = true;
dgv1.DataSource = EmployeeBUS.LoadAll();
dgv2.DataSource = MenuBUS.LoadAll();
dgv3.DataSource = BillBUS.LoadAll(1, int.Parse(billsPerPageComboBox.Text));
dgv5.DataSource = LoginBUS.LoadAll();
// Đặt tên cột cho DataGridView 1
dgv1.Columns[0].HeaderText = "Mã";
dgv1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv1.Columns[1].HeaderText = "Họ tên";
dgv1.Columns[2].HeaderText = "Ngày sinh";
dgv1.Columns[3].HeaderText = "Giới tính";
dgv1.Columns[4].HeaderText = "Địa chỉ";
dgv1.Columns[5].HeaderText = "Số điện thoại";
dgv1.Columns[6].HeaderText = "Ngày vào làm";
dgv1.Columns[7].HeaderText = "Chức vụ";
dgv1.Columns[8].HeaderText = "Lương";
dgv1.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Đặt tên cột cho DataGridView 2
dgv2.Columns[0].HeaderText = "Tên món";
dgv2.Columns[1].HeaderText = "Đơn giá";
dgv2.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv2.Columns[2].HeaderText = "Đơn vị";
// Đặt tên cột cho DataGridView 3
dgv3.Columns[0].HeaderText = "Mã HD";
dgv3.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv3.Columns[1].HeaderText = "Mã bàn";
dgv3.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv3.Columns[2].HeaderText = "Mã NV";
dgv3.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv3.Columns[3].HeaderText = "Thời gian lập";
dgv3.Columns[4].HeaderText = "Tổng tiền";
dgv3.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Đặt tên cột cho DataGridView 5
dgv5.Columns[0].HeaderText = "Tài khoản";
dgv5.Columns[1].HeaderText = "Họ tên";
dgv5.Columns[2].HeaderText = "Quyền";
}