private void Display(HanhKhach c) { txtMaHanhKhach.Text = c.MaHanhKhach; txtTenHanhKhach.Text = c.TenHanhKhach; txtCmnd.Text = c.Cmnd; txtDienThoai.Text = c.DienThoai; setEditMode(true); }
private void gridView_CellClick(object sender, DataGridViewCellEventArgs e) { int row = e.RowIndex; if (row < 0 || row >= list.Count) { return; } HanhKhach c = list[row]; Display(c); }
public bool update(HanhKhach c) { String sql = "update HanhKhach set tenHanhKhach = @tenHanhKhach, cmnd = @cmnd, dienThoai = @dienThoai where maHanhKhach = @maHanhKhach"; SqlParameter p1 = new SqlParameter("@maHanhKhach", c.MaHanhKhach); SqlParameter p2 = new SqlParameter("@tenHanhKhach", c.TenHanhKhach); SqlParameter p3 = new SqlParameter("@cmnd", c.Cmnd); SqlParameter p4 = new SqlParameter("@dienThoai", c.DienThoai); SqlParameter[] param = { p1, p2, p3, p4 }; return(manager.executeUpdate(sql, param)); }
private void btnAdd_Click(object sender, EventArgs e) { string maHanhKhach = txtMaHanhKhach.Text.Trim(); string tenHanhKhach = txtTenHanhKhach.Text.Trim(); string cmnd = txtCmnd.Text.Trim(); string dienThoai = txtDienThoai.Text.Trim(); HanhKhach m = new HanhKhach(maHanhKhach, tenHanhKhach, cmnd, dienThoai); list.Add(m); gridView.DataSource = null; gridView.DataSource = list; addHanhKhach(m); }
public HanhKhach selectHanhKhach(string maHK) { String sql = "select * from HanhKhach where maHanhKhach = @maHanhKhach"; DataTable table = manager.executeQuery(sql); DataRow row = table.Rows[0]; string maHanhKhach = (string)row["maHanhKhach"]; string tenHanhKhach = (string)row["tenHanhKhach"]; string cmnd = (string)row["cmnd"]; string dienThoai = (string)row["dienThoai"]; HanhKhach c = new HanhKhach(maHanhKhach, tenHanhKhach, cmnd, dienThoai); return(c); }
private void addHanhKhach(HanhKhach m) { try { bool kq = hanhKhachDB.add(m); if (kq) { loadData(); ClearInput(); } else { MessageBox.Show("Them ko thanh cong"); } } catch (Exception e) { MessageBox.Show("Khong the thuc hien duoc: " + e.Message); } }
public bool add(HanhKhach c) { try { String sql = "insert into HanhKhach values(@maHanhKhach, @tenHanhKhach, @cmnd, @dienThoai)"; SqlParameter p1 = new SqlParameter("@maHanhKhach", c.MaHanhKhach); SqlParameter p2 = new SqlParameter("@tenHanhKhach", c.TenHanhKhach); SqlParameter p3 = new SqlParameter("@cmnd", c.Cmnd); SqlParameter p4 = new SqlParameter("@dienThoai", c.DienThoai); SqlParameter[] param = { p1, p2, p3, p4 }; return(manager.executeUpdate(sql, param)); } catch (Exception e) { return(false); } }
public List <HanhKhach> getAll() { String sql = "select * from HanhKhach"; DataTable table = manager.executeQuery(sql); List <HanhKhach> list = new List <HanhKhach>(); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; string maHanhKhach = (string)row["maHanhKhach"]; string tenHanhKhach = (string)row["tenHanhKhach"]; string cmnd = (string)row["cmnd"]; string dienThoai = (string)row["dienThoai"]; HanhKhach c = new HanhKhach(maHanhKhach, tenHanhKhach, cmnd, dienThoai); list.Add(c); } return(list); }
private void btnUpdate_Click(object sender, EventArgs e) { if (!isInputValid()) { return; } string maHanhKhach = txtMaHanhKhach.Text.Trim(); string tenHanhKhach = txtTenHanhKhach.Text.Trim(); string cmnd = txtCmnd.Text.Trim(); string dienThoai = txtDienThoai.Text.Trim(); DialogResult result = MessageBox.Show("Ban co muon cap nhat " + maHanhKhach, "Cap nhat thong tin ", MessageBoxButtons.YesNo); if (result != DialogResult.Yes) { return; } HanhKhach m = new HanhKhach(maHanhKhach, tenHanhKhach, cmnd, dienThoai); bool ketQua = hanhKhachDB.update(m); // thong bao if (ketQua) { MessageBox.Show("Cap nhat thanh cong"); } else { MessageBox.Show("Cap nhat ko thanh cong"); } list = hanhKhachDB.getAll(); gridView.DataSource = null; gridView.DataSource = list; }