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"); } }