private void dgvDichVu_CellClick(object sender, DataGridViewCellEventArgs e) { try { BLSDDV = new BLSuDungDV(); int r = dgvDichVu.CurrentCell.RowIndex; MaDV = dgvDichVu.Rows[r].Cells[2].Value.ToString().Trim(); Gia = dgvDichVu.Rows[r].Cells[4].Value.ToString().Trim(); object Kiemtra = BLSDDV.CheckForAddata(MaPhong, MaDV); if (dgvDichVu.Columns[e.ColumnIndex].Name.ToString() == "Them") { BLSDDV = new BLSuDungDV(); if (Kiemtra.Equals(0)) { BLSDDV.OrderForThem(MaPhong, MaDV); } else if (Kiemtra.Equals(1)) { BLSDDV.OrderForThemTonTaiDV(MaPhong, MaDV, Gia); } else { BLSDDV.OrderForThemKhongTonTaiDV(MaPhong, MaDV, Gia); } LoadDataDVSD(); } if (dgvDichVu.Columns[e.ColumnIndex].Name.ToString() == "Giam") { BLSDDV = new BLSuDungDV(); if (Kiemtra.Equals(0)) { // BLSDDV.OrderForThem(MaPhong, MaDV); } else if (Kiemtra.Equals(1)) { BLSDDV.OrderForXoaTonTaiDV(MaPhong, MaDV, Gia); } else { //BLSDDV.OrderForThemKhongTonTaiDV(MaPhong, MaDV, Gia); } LoadDataDVSD(); } } catch { } }
public void LoadDataDVSD() { try { BLSDDV = new BLSuDungDV(); Data = new DataTable(); Data.Clear(); DataSet ds = BLSDDV.ThongTinHDDV_TuPTP(MaPTP); Data = ds.Tables[0]; // Đưa dữ liệu lên DataGridView dgvDVSD.DataSource = Data; //dgvDichVu_CellClick(null, null); } catch (SqlException) { } }