private void btnCapNhat_Click(object sender, EventArgs e)
{
NguoiThanDTO nguoiThan = new NguoiThanDTO();
nguoiThan.TenNguoiThan = txtTenNguoiThan.Text;
nguoiThan.NhanVienID = int.Parse(cmbNhanVien.SelectedValue.ToString());
nguoiThan.MoiQuanHeID = int.Parse(cmbMQH.SelectedValue.ToString());
nguoiThan.NgheNghiep = txtNgheNghiep.Text;
nguoiThan.SDT = txtSDT.Text;
nguoiThan.DiaChi = txtDiaChi.Text;
if (kt == 1)
{
if (NguoiThanBUS.Instance.Add_NguoiThan(nguoiThan) == -1)
{
MessageBox.Show("Lỗi khi thêm mới");
}
else
{
Load_DL();
}
}
else
{
NguoiThanBUS.Instance.Update_NguoiThan(nguoiThan, NguoiThanID);
Load_DL();
}
Reset();
}
public string Update_NguoiThan(NguoiThanDTO nguoiThanDTO, int NguoiThanID)
{
string sql = "Update NguoiThan set NhanVienID ='" + nguoiThanDTO.NhanVienID + "', MoiQuanHeID = '" + nguoiThanDTO.MoiQuanHeID + "', TenNguoiThan = N'" + nguoiThanDTO.TenNguoiThan + "', NgheNghiep = N'" + nguoiThanDTO.NgheNghiep + "', SDT = '" + nguoiThanDTO.SDT + "', DiaChi = '" + nguoiThanDTO.DiaChi + "' where NguoiThanID = '" + NguoiThanID + "'";
return(sql);
}
public void Update_NguoiThan(NguoiThanDTO nguoiThanDTO, int NguoiThanID)
{
Core.RunSql(NguoiThanDAO.Instance.Update_NguoiThan(nguoiThanDTO, NguoiThanID));
}
public string ADD_NguoiThan(NguoiThanDTO nguoiThanDTO)
{
string sql = "Insert into NguoiThan(NhanVienID, MoiQuanHeID, TenNguoiThan, NgheNghiep, SDT, DiaChi) values ('" + nguoiThanDTO.NhanVienID + "', '" + nguoiThanDTO.MoiQuanHeID + "', N'" + nguoiThanDTO.TenNguoiThan + "', N'" + nguoiThanDTO.NgheNghiep + "', '" + "" + nguoiThanDTO.SDT + "', N'" + nguoiThanDTO.DiaChi + "')";
return(sql);
}
public int Add_NguoiThan(NguoiThanDTO nguoiThanDTO)
{
return(Core.RunSql(NguoiThanDAO.Instance.ADD_NguoiThan(nguoiThanDTO)));
}
