//Sửa dữ liệu public bool UpdateData(DangNhapObj dnObj) { cmd.CommandText = string.Format("UPDATE tbleDangNhap SET MADN = '{0}', MANV = '{1}', TENDN = '{2}', MATKHAU = '{3}', QUYENTC = '{4}' WHERE (MADN = '{0}')", dnObj.MaDN, dnObj.MaNV, dnObj.TenDN, dnObj.MatKhau, dnObj.QuyenTC); cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.openCon(); cmd.ExecuteNonQuery(); con.closeCon(); return(true); } catch (Exception ex) { string mes = ex.Message; cmd.Dispose(); con.closeCon(); } return(false); }
//Thêm dữ liệu public bool AddData(DangNhapObj dnObj) { cmd.CommandText = string.Format("INSERT INTO tbleDangNhap (MADN, MANV, TENDN, MATKHAU, QUYENTC) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", dnObj.MaDN, dnObj.MaNV, dnObj.TenDN, dnObj.MatKhau, dnObj.QuyenTC); cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.openCon(); cmd.ExecuteNonQuery(); con.closeCon(); return(true); } catch (Exception ex) { string mes = ex.Message; cmd.Dispose(); con.closeCon(); } return(false); }
public bool updateData(DangNhapObj dnObj) { return(dnMod.UpdateData(dnObj)); }
public bool addData(DangNhapObj dnObj) { return(dnMod.AddData(dnObj)); }