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