public List <Tin> LayMaLoaiTin2benphai(string MaLoaiTin)
        {
            string sql = "select top 2 * from Tin where MaLoaiTin='" + MaLoaiTin + "'";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();
            List <Tin> ds = new List <Tin>();

            foreach (DataRow dr in dt.Rows)
            {
                Tin t = new Tin();
                t.MaTin     = dr[0].ToString();
                t.TieuDe    = dr[1].ToString();
                t.TomTat    = dr[2].ToString();
                t.NgayDang  = dr[3].ToString();
                t.NoiDung   = dr[4].ToString();
                t.HinhAnh   = dr[5].ToString();
                t.SoLanXem  = dr[6].ToString();
                t.TrangThai = dr[7].ToString();
                t.MaLoaiTin = dr[8].ToString();
                ds.Add(t);
            }
            this.DanhSachTin = ds;
            return(ds);
        }
        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 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 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();
        }
Exemple #5
0
        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();
        }
Exemple #6
0
        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 XoaLoaiTin(string MaLoaiTin)
        {
            string sql = "delete LoaiTin where MaLoaiTin='" + MaLoaiTin + "'";

            db = new DBACCESS();
            db.open();
            db.ExcuteQuery(sql);
            db.close();
        }
Exemple #8
0
        public void XoaBinhLuan(string MaBinhLuan)
        {
            string sql = "delete BinhLuan where MaBinhLuan='" + MaBinhLuan + "'";

            db = new DBACCESS();
            db.open();
            db.ExcuteQuery(sql);
            db.close();
        }
Exemple #9
0
        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();
        }
Exemple #10
0
        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 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();
        }
Exemple #13
0
        public void XoaQuangCao(string MaQC)
        {
            string sql = "delete QuangCao where MaQuangCao='" + MaQC + "'";

            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 ThemTheLoai(TheLoai tl)
        {
            string sql = "insert into TheLoai values('" + tl.MaTheLoai + "',N'" + tl.TenTheLoai + "')";

            db = new DBACCESS();
            db.open();
            db.ExcuteQuery(sql);
            db.close();
        }
        public void XoaNguoiDung(string MaNguoiDung)
        {
            string sql = "delete NguoiDung where MaNguoiDung='" + MaNguoiDung + "'";

            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 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 int DangNhap(string taiKhoan, string matKhau)
        {
            string sql = "select * from NguoiDung Where TaiKhoan='" + taiKhoan + "' And MatKhau='" + matKhau + "'";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();

            if (dt.Rows.Count > 0)
            {
                return(int.Parse(dt.Rows[0][9].ToString()));
            }
            return(-1);
        }
        public List <TheLoai> AllTheLoai()
        {
            string sql = "select * from TheLoai";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();
            List <TheLoai> ds = new List <TheLoai>();

            foreach (DataRow dr in dt.Rows)
            {
                TheLoai tl = new TheLoai();
                tl.MaTheLoai  = dr[0].ToString();
                tl.TenTheLoai = dr[1].ToString();
                ds.Add(tl);
            }
            this.DanhSachTheLoai = ds;
            return(ds);
        }
        public List <LoaiTin> AllLoaiTin()
        {
            string sql = "select * from LoaiTin";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();
            List <LoaiTin> ds = new List <LoaiTin>();

            foreach (DataRow dr in dt.Rows)
            {
                LoaiTin lt = new LoaiTin();
                lt.MaLoaiTin  = dr[0].ToString();
                lt.MaTheLoai  = dr[1].ToString();
                lt.TenLoaiTin = dr[2].ToString();
                ds.Add(lt);
            }
            this.DanhSachLoaiTin = ds;
            return(ds);
        }
Exemple #22
0
        public List <QuangCao> AllQuangCao()
        {
            string sql = "select * from QuangCao";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();
            List <QuangCao> ds = new List <QuangCao>();

            foreach (DataRow dr in dt.Rows)
            {
                QuangCao qc = new QuangCao();
                qc.MaQC    = dr[0].ToString();
                qc.MaQC    = dr[1].ToString();
                qc.HinhAnh = dr[2].ToString();
                ds.Add(qc);
            }
            this.DanhSachLoaiTin = ds;
            return(ds);
        }
Exemple #23
0
        public List <BinhLuan> LaySoBinhLuanTheoTin(string MaTin)
        {
            string sql = "select * from BinhLuan where MaTin=" + MaTin + "";

            db = new DBACCESS();
            db.open();
            DataTable dt = db.getTable(sql);

            db.close();
            List <BinhLuan> ds = new List <BinhLuan>();

            foreach (DataRow dr in dt.Rows)
            {
                BinhLuan bl = new BinhLuan();
                bl.MaBinhLuan  = dr[0].ToString();
                bl.NoiDung     = dr[1].ToString();
                bl.Ngay        = dr[2].ToString();
                bl.MaTin       = dr[3].ToString();
                bl.MaNguoiDung = dr[4].ToString();
                ds.Add(bl);
            }
            this.DanhSachBinhLuan = ds;
            return(ds);
        }