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"; }
public void xemdulieu() { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); BUL_SanBay bUL_SanBay = new BUL_SanBay(); BUL_ChiTietCB bUL_ChiTietCB = new BUL_ChiTietCB(); dGVthemChiTietCB.DataSource = bUL_ChiTietCB.getChiTietCB(); dGVthemChiTietCB.Refresh(); dGVthemChiTietCB.Columns[0].HeaderText = "Mã chi tiết"; dGVthemChiTietCB.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemChiTietCB.Columns[1].HeaderText = "Mã chuyến bay"; dGVthemChiTietCB.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemChiTietCB.Columns[2].HeaderText = "Mã sân bay trung gian"; dGVthemChiTietCB.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemChiTietCB.Columns[3].HeaderText = "Thời gian dừng"; dGVthemChiTietCB.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemChiTietCB.Columns[4].HeaderText = "Ghi chú"; dGVthemChiTietCB.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; cBmaCB.DataSource = bUL_LichChuyenBay.getLichChuyenBay(); cBmaCB.DisplayMember = "MaCB"; cBmaCB.ValueMember = "MaCB"; cBsanBayTrungGian.DataSource = bUL_SanBay.getSanBay(); cBsanBayTrungGian.DisplayMember = "TenSB"; cBsanBayTrungGian.ValueMember = "MaSB"; }
private void btnXacNhan_Click(object sender, EventArgs e) { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); if (txtMaCB.Text != "" && txtThoiGianBay.Text != "" && cBsanBayDen.Text != "" && cBsanBayDi.Text != "" && txtGiaVe.Text != "" && txtSLGheHang1.Text != "" && txtSLGheHang2.Text != "") { LichChuyenBay lcb = new LichChuyenBay(txtMaCB.Text, cBsanBayDi.SelectedValue.ToString(), cBsanBayDen.SelectedValue.ToString(), Convert.ToInt32(txtGiaVe.Text), Convert.ToString(dTPngayGio.Value), txtThoiGianBay.Text, Convert.ToInt32(txtSLGheHang1.Text), Convert.ToInt32(txtSLGheHang2.Text)); if (bUL_LichChuyenBay.themLichChuyenBay(lcb)) { MessageBox.Show("Thêm thành công"); txtGiaVe.Text = ""; txtSLGheHang1.Text = ""; txtSLGheHang2.Text = ""; txtThoiGianBay.Text = "00:00:00"; txtMaCB.Text = "CB"; dGVthemLichCB.DataSource = bUL_LichChuyenBay.getLichChuyenBay(); // refresh datagridview } else { MessageBox.Show("Đã có lỗi xảy ra", "Lỗi"); } } else { MessageBox.Show("Xin hãy nhập đầy đủ"); } }
public void xemdulieu() { BUL_SanBay bUL_SanBay = new BUL_SanBay(); BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); dGVthemLichCB.DataSource = bUL_LichChuyenBay.getLichChuyenBay(); dGVthemLichCB.Refresh(); dGVthemLichCB.Columns[0].HeaderText = "Mã chuyến bay"; dGVthemLichCB.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[1].HeaderText = "Sân bay đi"; dGVthemLichCB.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[2].HeaderText = "Sân bay đến"; dGVthemLichCB.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[3].HeaderText = "Giá tiền"; dGVthemLichCB.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[4].HeaderText = "Ngày giờ"; dGVthemLichCB.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[4].DefaultCellStyle.Format = "MM/dd/yyyy HH:mm:ss"; dGVthemLichCB.Columns[5].HeaderText = "Thời gian bay"; dGVthemLichCB.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[6].HeaderText = "Số lượng ghế hạng 1"; dGVthemLichCB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVthemLichCB.Columns[7].HeaderText = "Số lượng ghế hạng 2"; dGVthemLichCB.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; cBsanBayDi.DataSource = bUL_SanBay.getSanBay(); cBsanBayDi.DisplayMember = "TenSB"; cBsanBayDi.ValueMember = "MaSB"; cBsanBayDen.DataSource = bUL_SanBay.getSanBay(); cBsanBayDen.DisplayMember = "TenSB"; cBsanBayDen.ValueMember = "MaSB"; }
private void btnTimKiem_Click(object sender, EventArgs e) { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); if (txtTraCuu.Text != "") { LichChuyenBay lcb = new LichChuyenBay(txtTraCuu.Text); dGVtraCuuCB.DataSource = bUL_LichChuyenBay.getTimKiemCB(lcb); } else { xemdulieu(); } }
public void addbinding() { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); BUL_SanBay bUL_SanBay = new BUL_SanBay(); txtMaCT.DataBindings.Clear(); txtMaCT.DataBindings.Add("Text", dGVchiTietCB.DataSource, "MaCT"); cBmaCB.DataBindings.Clear(); cBmaCB.DataSource = bUL_LichChuyenBay.getLichChuyenBay(); cBmaCB.DisplayMember = "MaCB"; cBmaCB.ValueMember = "MaCB"; cBsanBayTrungGian.DataBindings.Clear(); cBsanBayTrungGian.DataSource = bUL_SanBay.getSanBay(); cBsanBayTrungGian.DisplayMember = "TenSB"; cBsanBayTrungGian.ValueMember = "MaSB"; txtThoiGianDung.DataBindings.Clear(); txtThoiGianDung.DataBindings.Add("Text", dGVchiTietCB.DataSource, "ThoiGianDung"); txtGhiChu.DataBindings.Clear(); txtGhiChu.DataBindings.Add("Text", dGVchiTietCB.DataSource, "GhiChu"); }
public void xemdulieu() { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); dGVLichChuyenBay.DataSource = bUL_LichChuyenBay.getLichChuyenBay(); dGVLichChuyenBay.Columns[0].HeaderText = "Mã chuyến bay"; dGVLichChuyenBay.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[1].HeaderText = "Mã sân bay đi"; dGVLichChuyenBay.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[2].HeaderText = "Mã sân bay đến"; dGVLichChuyenBay.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[3].HeaderText = "Giá tiền"; dGVLichChuyenBay.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[4].HeaderText = "Ngày giờ"; dGVLichChuyenBay.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[5].HeaderText = "Thời gian bay"; dGVLichChuyenBay.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[6].HeaderText = "Số lượng ghế hạng 1"; dGVLichChuyenBay.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dGVLichChuyenBay.Columns[7].HeaderText = "Số lượng ghế hạng 2"; dGVLichChuyenBay.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; }
private void btnXoa_Click(object sender, EventArgs e) { BUL_LichChuyenBay bUL_LichChuyenBay = new BUL_LichChuyenBay(); if (txtMaCB.Text != "") { LichChuyenBay lcb = new LichChuyenBay(txtMaCB.Text, cBsanBayDi.SelectedValue.ToString(), cBsanBayDen.SelectedValue.ToString(), Convert.ToInt32(txtGiaVe.Text), Convert.ToString(dTPngayGio.Value), txtThoiGianBay.Text, Convert.ToInt32(txtSLGheHang1.Text), Convert.ToInt32(txtSLGheHang2.Text)); if (bUL_LichChuyenBay.xoaLichChuyenBay(lcb)) { MessageBox.Show("Xó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"); } }