public int ThemLyLich(Ly_Lich lylich)
{
try
{
conn.Open();
OleDbCommand cmd = new OleDbCommand("insert into lylichcanhan values(@ma,@ten,@quequan,@diachithuongtru,@diachitamtru,@sdt,@cmnd,@tinhhinhsuckhoe,@tentk,@madn)", conn);
cmd.Parameters.Add("@ma", OleDbType.BSTR).Value = lylich.Ma;
cmd.Parameters.Add("@ten", OleDbType.BSTR).Value = lylich.Ten;
cmd.Parameters.Add("@quequan", OleDbType.BSTR).Value = lylich.QueQuan;
cmd.Parameters.Add("@diachithuongtru", OleDbType.BSTR).Value = lylich.DiaChiThuongTru;
cmd.Parameters.Add("@diachitamtru", OleDbType.BSTR).Value = lylich.DiaChiTamTru;
cmd.Parameters.Add("@sdt", OleDbType.BSTR).Value = lylich.SDT;
cmd.Parameters.Add("@cmnd", OleDbType.BSTR).Value = lylich.CMND;
cmd.Parameters.Add("@tinhhinhsuckhoe", OleDbType.BSTR).Value = lylich.Tinhhinhsuckhoe;
cmd.Parameters.Add("@tentk", OleDbType.BSTR).Value = lylich.TenTK;
cmd.Parameters.Add("@madn", OleDbType.BSTR).Value = lylich.MaDN;
cmd.ExecuteNonQuery();
conn.Close();
return(0);
}
catch (Exception ex)
{
return(1);
}
}
private void btnCapnhat_Click(object sender, EventArgs e)
{
if (KiemTra_txt())
{
string maDN = "";
tbMaDN = objDN.getMa_TheoEmail(cmbGuiDN.Text);
DataRow dr = tbMaDN.Rows[0];
maDN = dr["ma"].ToString();
Ly_Lich obj = new Ly_Lich(txtmalylich.Text, txttenll.Text, txtquequan.Text, txtdcthtru.Text, txtdctamtru.Text, txtsdt.Text, txtcmnd.Text, txtsuckhoe.Text, DangNhap.tendangnhap, maDN);
int loi = ObjLL.CapNhatLyLich(obj);
if (loi == 0)
{
MessageBox.Show("Cập nhật lý lịch thành công");
Napdulieuvao_ListBox();
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
}
public int CapNhatLyLich(Ly_Lich lylich)
{
if (TimKiem(lylich.Ma) == false)
{
return(2);
}
conn.Open();
OleDbCommand cmd = new OleDbCommand("update lylichcanhan set ma=@ma,ten=@ten,quequan=@quequan,diachithuongtru=@diachithuongtru,diachitamtru=@diachitamtru,sdt=@sdt,cmnd=@cmnd,tinhhinhsuckhoe=@tinhhhinhsuckhoe,tentk=@tentk,madn=@madn where ma=@ma", conn);
cmd.Parameters.Add("@ma", OleDbType.BSTR).Value = lylich.Ma;
cmd.Parameters.Add("@ten", OleDbType.BSTR).Value = lylich.Ten;
cmd.Parameters.Add("@quequan", OleDbType.BSTR).Value = lylich.QueQuan;
cmd.Parameters.Add("@diachithuongtru", OleDbType.BSTR).Value = lylich.DiaChiThuongTru;
cmd.Parameters.Add("@diachitamtru", OleDbType.BSTR).Value = lylich.DiaChiTamTru;
cmd.Parameters.Add("@sdt", OleDbType.BSTR).Value = lylich.SDT;
cmd.Parameters.Add("@cmnd", OleDbType.BSTR).Value = lylich.CMND;
cmd.Parameters.Add("@tinhhinhsuckhoe", OleDbType.BSTR).Value = lylich.Tinhhinhsuckhoe;
cmd.Parameters.Add("@tentk", OleDbType.BSTR).Value = lylich.TenTK;
cmd.Parameters.Add("@madn", OleDbType.BSTR).Value = lylich.MaDN;
cmd.ExecuteNonQuery();
conn.Close();
return(0);
}
public int CapNhatLyLich(Ly_Lich ll)
{
return(LL.CapNhatLyLich(ll));
}
public int Them_LyLich(Ly_Lich ll)
{
return(LL.ThemLyLich(ll));
}
