public void xemdulieu()
{
BUL_BanVe bUL_BanVe = new BUL_BanVe();
BUL_HangVe bUL_HangVe = new BUL_HangVe();
BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay();
dGVbanVe.DataSource = bUL_BanVe.getVe();
dGVbanVe.Refresh();
dGVbanVe.Columns[0].HeaderText = "Mã vé chuyến bay";
dGVbanVe.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVbanVe.Columns[1].HeaderText = "Mã chuyến bay";
dGVbanVe.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVbanVe.Columns[2].HeaderText = "Mã hành khách";
dGVbanVe.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVbanVe.Columns[3].HeaderText = "Mã hạng vé";
dGVbanVe.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVbanVe.Columns[4].HeaderText = "Giá tiền";
dGVbanVe.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
cBmaCB.DataSource = bUL_LichChuyenBay.getLichChuyenBay();
cBmaCB.DisplayMember = "MaCB";
cBmaCB.ValueMember = "MaCB";
cBhangVe.DataSource = bUL_HangVe.getHV();
cBhangVe.DisplayMember = "TenHV";
cBhangVe.ValueMember = "MaHV";
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
BUL_BanVe bUL_BanVe = new BUL_BanVe();
if (txtTraCuu.Text != "")
{
BanVe bv = new BanVe(txtTraCuu.Text);
dGVtraCuuVe.DataSource = bUL_BanVe.getTimKiemVe(bv);
}
else
{
xemdulieu();
}
}
public void xemdulieu()
{
BUL_BanVe bUL_BanVe = new BUL_BanVe();
dGVtraCuuVe.DataSource = bUL_BanVe.getVe();
dGVtraCuuVe.Refresh();
dGVtraCuuVe.Columns[0].HeaderText = "Mã vé chuyến bay";
dGVtraCuuVe.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVtraCuuVe.Columns[1].HeaderText = "Mã chuyến bay";
dGVtraCuuVe.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVtraCuuVe.Columns[2].HeaderText = "Mã hành khách";
dGVtraCuuVe.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVtraCuuVe.Columns[3].HeaderText = "Mã hạng vé";
dGVtraCuuVe.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dGVtraCuuVe.Columns[4].HeaderText = "Giá tiền";
dGVtraCuuVe.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
BUL_BanVe bUL_BanVe = new BUL_BanVe();
if (txtMaVe.Text != "" && txtMaHK.Text != "" && cBhangVe.Text != "" && cBmaCB.Text != "" && txtGiaTien.Text != "")
{
BanVe bv = new BanVe(txtMaVe.Text, cBmaCB.SelectedValue.ToString(), cBhangVe.SelectedValue.ToString(), txtGiaTien.Text, txtMaHK.Text);
if (bUL_BanVe.themVeCB(bv))
{
MessageBox.Show("Thêm thành công");
dGVbanVe.DataSource = bUL_BanVe.getVe(); // refresh datagridview
}
else
{
MessageBox.Show("Đã có lỗi xảy ra", "Lỗi");
}
}
else
{
MessageBox.Show("Xin hãy nhập đầy đủ");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
BUL_BanVe bUL_BanVe = new BUL_BanVe();
if (txtMaVe.Text != "")
{
BanVe bv = new BanVe(txtMaVe.Text, cBmaCB.SelectedValue.ToString(), cBhangVe.SelectedValue.ToString(), txtGiaTien.Text, txtMaHK.Text);
if (bUL_BanVe.SuaVeCB(bv))
{
MessageBox.Show("Sửa thành công");
xemdulieu();
AddBinding();
}
else
{
MessageBox.Show("Đã có lỗi xảy ra", "Lỗi");
}
}
else
{
MessageBox.Show("Kiểm tra lại");
}
}