public List <NguoiDung1> AllNguoiDung() { string sql = "select * from NguoiDung"; db = new DBACCESS(); db.open(); DataTable dt = db.getTable(sql); db.close(); List <NguoiDung1> ds = new List <NguoiDung1>(); foreach (DataRow dr in dt.Rows) { NguoiDung1 nd = new NguoiDung1(); nd.MaNguoiDung = dr[0].ToString(); nd.HoTen = dr[1].ToString(); nd.TaiKhoan = dr[2].ToString(); nd.MatKhau = dr[3].ToString(); nd.DiaChi = dr[4].ToString(); nd.Email = dr[5].ToString(); nd.GioiTinh = dr[6].ToString(); nd.NgaySinh = dr[7].ToString(); nd.NgayDangKy = dr[8].ToString(); nd.VaiTro = int.Parse(dr[9].ToString()); ds.Add(nd); } this.DanhSachNguoiDung = ds; return(ds); }
public List <Tin> LayMaTin(string MaTin) { string sql = "select * from Tin where MaTin='" + MaTin + "'"; 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 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); }
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); }
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); }