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