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