public void XoaNguoiDung(string MaNguoiDung) { string sql = "delete NguoiDung where MaNguoiDung='" + MaNguoiDung + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemLoaiTin(LoaiTin lt) { string sql = "insert into LoaiTin values('" + lt.MaLoaiTin + "',N'" + lt.TenLoaiTin + "','" + lt.MaTheLoai + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemNguoiDung(NguoiDung1 nd) { string sql = "insert into NguoiDung values(N'" + nd.HoTen + "','" + nd.TaiKhoan + "','" + nd.MatKhau + "',N'" + nd.DiaChi + "',N'" + nd.Email + "','" + nd.GioiTinh + "','" + nd.NgaySinh + "','" + nd.NgayDangKy + "','" + nd.VaiTro + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaNguoiDung(NguoiDung1 nd) { string sql = "update NguoiDung set HoTen=N'" + nd.HoTen + "','" + nd.TaiKhoan + "','" + nd.MatKhau + "',N'" + nd.DiaChi + "',N'" + nd.Email + "','" + nd.GioiTinh + "','" + nd.NgaySinh + "','" + nd.NgayDangKy + "' where MaNguoiDung='" + nd.MaNguoiDung + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemTin(Tin t) { string sql = "insert into Tin values('" + t.MaTin + "',N'" + t.TieuDe + "',N'" + t.TomTat + "','" + t.NgayDang + "',N'" + t.NoiDung + "','" + t.HinhAnh + "','" + t.SoLanXem + "','" + t.TrangThai + "','" + t.MaLoaiTin + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaTin(Tin t) { string sql = "update Tin set TieuDe=N'" + t.TieuDe + "',TomTat=N'" + t.TomTat + "',NgayDang='" + t.NgayDang + "',NoiDung=N'" + t.NoiDung + "',HinhAnh='" + t.HinhAnh + "',SoLanXem='" + t.SoLanXem + "',TrangThai='" + t.TrangThai + "',MaLoaiTin='" + t.MaLoaiTin + "' where MaTin='" + t.MaTin + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaQuangCao(QuangCao qc) { string sql = "update QuangCao set TenQC=N'" + qc.TenQC + "',HinhAnh='" + qc.HinhAnh + "' where MaQC='" + qc.MaQC + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaTheLoai(TheLoai tl) { string sql = "update TheLoai set TenTheLoai=N'" + tl.TenTheLoai + "' where MaTheLoai='" + tl.MaTheLoai + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void XoaBinhLuan(string MaBinhLuan) { string sql = "delete BinhLuan where MaBinhLuan='" + MaBinhLuan + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemQuangCao(QuangCao qc) { string sql = "insert into QuangCao values('" + qc.MaQC + "',N'" + qc.TenQC + "','" + qc.HinhAnh + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaBinhLuan(BinhLuan bl) { string sql = "update BinhLuan set NoiDung=N'" + bl.NoiDung + "',Ngay='" + bl.Ngay + "',MaTin='" + bl.MaTin + "',MaNguoiDung='" + bl.MaNguoiDung + "' where MaBinhLuan='" + bl.MaBinhLuan + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemBinhLuan(BinhLuan bl) { string sql = "insert into BinhLuan values('" + bl.MaBinhLuan + "',N'" + bl.NoiDung + "','" + bl.Ngay + "','" + bl.MaTin + "','" + bl.MaNguoiDung + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void XoaTheLoai(string MaTheLoai) { string sql = "delete TheLoai where MaTheLoai='" + MaTheLoai + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void SuaLoaiTin(LoaiTin lt) { string sql = "update LoaiTin set TenLoaiTin=N'" + lt.TenLoaiTin + "',MaTheLoai='" + lt.MaTheLoai + "' where MaLoaiTin='" + lt.MaLoaiTin + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void XoaQuangCao(string MaQC) { string sql = "delete QuangCao where MaQuangCao='" + MaQC + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void XoaLoaiTin(string MaLoaiTin) { string sql = "delete LoaiTin where MaLoaiTin='" + MaLoaiTin + "'"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }
public void ThemTheLoai(TheLoai tl) { string sql = "insert into TheLoai values('" + tl.MaTheLoai + "',N'" + tl.TenTheLoai + "')"; db = new DBACCESS(); db.open(); db.ExcuteQuery(sql); db.close(); }