public TuVungCollection SelectAllTuVung_CongDong()
{
//Lấy từ vựng trong từ điển cộng đồng
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TuVungCollection tuvungColl = new TuVungCollection();
IEnumerable<TuVung> TuVungList;
TuVungList = from p in db.TuVungs
where p.TuDien.CongDong == true
&& p.kiemduyet == true
select p;
//Addrange
foreach (TuVung tv in TuVungList)
{
TuVungBO tvBO = new TuVungBO();
tvBO.TuVungID = tv.TuVungID.ToString();
tvBO.TuVung = tv.TuVung1;
tvBO.LoaiTuID = (int)tv.LoaiTuID;
tvBO.NghiaTu = tv.NghiaTu;
tvBO.ViDu = tv.Vidu;
tvBO.TaiKhoan = tv.taikhoan;
tvBO.HinhAnh = tv.Hinhanh;
tvBO.SoLanSai = (int)tv.SoLanSai;
tvBO.SoLanSuDung = (int)tv.SoLanSuDung;
tuvungColl.Add(tvBO);
}
return tuvungColl;
}
public void UpdateTinNhan(string tinnhanID, bool xacnhan)
{
Guid myguid = new Guid(tinnhanID);
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TinNhan tinnhan = db.TinNhans.SingleOrDefault(p =>p.TinNhanID == myguid);
tinnhan.XacNhan = true;
db.SubmitChanges();
}
public void UpdateTuDien(TuDienBO tudienBO)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
TuDien tudien = db.TuDiens.SingleOrDefault(p => p.TudienID.ToString() == tudienBO.TuDienID);
tudien.TenTuDien = tudienBO.TenTuDien;
tudien.taikhoan = tudienBO.TaiKhoan;
tudien.CongDong = tudienBO.CongDong;
db.SubmitChanges();
}
public void DeleteTuDien(string tudienID)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
var tudien = from p in db.TuDiens
where p.TudienID.ToString() == tudienID
select p;
db.TuDiens.DeleteAllOnSubmit(tudien);
db.SubmitChanges();
}
public void InsertBanBe(string taikhoan, string taikhoanban)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Banbe ban = new Banbe();
ban.taikhoan = taikhoan;
ban.taikhoanban = taikhoanban;
db.Banbes.InsertOnSubmit(ban);
db.SubmitChanges();
}
public void DeleteBanBe(string taikhoan, string taikhoanban)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Banbe ban = (from p in db.Banbes
where p.taikhoan == taikhoan && p.taikhoanban == taikhoanban
select p).SingleOrDefault();
db.Banbes.DeleteOnSubmit(ban);
db.SubmitChanges();
}
public bool KTTrung(string taikhoan)
{
bool trung = false;
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDung check= db.NguoiDungs.SingleOrDefault(p=>p.taikhoan==taikhoan);
if(taikhoan==check.taikhoan)
trung=true;
return trung;
}
public void DoiMatKhau(string taikhoan, string matkhau, string matkhaumoi)
{
//Lấy ra ngừơi dùng cần Update
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDung UpNguoiDung = db.NguoiDungs.Single(p => p.taikhoan == taikhoan);
//Cập nhật lại các thuộc tính
UpNguoiDung.matkhau = matkhaumoi;
db.SubmitChanges();
}
public void InsertTuDien(TuDienBO tudienBO)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
TuDien td = new TuDien();
td.TudienID = Guid.NewGuid();
td.taikhoan = tudienBO.TaiKhoan;
td.TenTuDien = tudienBO.TenTuDien;
td.CongDong = false;
db.TuDiens.InsertOnSubmit(td);
db.SubmitChanges();
}
public void InSertCauHoi(string taikhoan, string tieude, string noidung)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
CauHoi_DienDan chdd = new CauHoi_DienDan();
chdd.CauHoiID=Guid.NewGuid();
chdd.taikhoan = taikhoan;
chdd.TieuDe = tieude;
chdd.NoiDung = noidung;
chdd.NgayGoi = DateTime.Now;
db.CauHoi_DienDans.InsertOnSubmit(chdd);
db.SubmitChanges();
}
public NguoiDungBO SelectNguoiDung(string taikhoan)
{
//Lấy thông tin người dùng từ DB
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDungBO nguoidungBO= new NguoiDungBO();
NguoiDung ndtemp = db.NguoiDungs.Single(p => p.taikhoan == taikhoan);
//Gán thông tin vào đối tượng ngừơi dùng
nguoidungBO.TaiKhoan = ndtemp.taikhoan;
nguoidungBO.MatKhau = ndtemp.matkhau;
nguoidungBO.Email = ndtemp.email;
nguoidungBO.DT = ndtemp.dt;
return nguoidungBO;
}
public void InsertTinNhan(TinNhanBO tinnhanBO)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TinNhan tinnhan = new TinNhan();
tinnhan.TinNhanID = Guid.NewGuid();
tinnhan.Nguoigoi = tinnhanBO.NguoiGoi;
tinnhan.Nguoinhan = tinnhanBO.NguoiNhan;
tinnhan.NoiDung = tinnhanBO.NoiDung;
tinnhan.NgayGoi = tinnhanBO.NgayGoi;
tinnhan.XacNhan = false;
db.TinNhans.InsertOnSubmit(tinnhan);
db.SubmitChanges();
}
public void InsertCauTraLoi(string taikhoan, string CauHoiID, string noidung)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TraLoi_DienDan tldd = new TraLoi_DienDan();
tldd.TraLoiID = Guid.NewGuid();
Guid myguid = new Guid(CauHoiID);
tldd.CauHoiID = myguid;
tldd.taikhoan = taikhoan;
tldd.Noidung = noidung;
tldd.NgayGoi = DateTime.Now;
db.TraLoi_DienDans.InsertOnSubmit(tldd);
db.SubmitChanges();
}
public void InsertNguoidung_TuDien(string tudienid, string taikhoan)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
Nhom_TuDien ntd = new Nhom_TuDien();
Guid myguid= new Guid(tudienid);
ntd.TuDienID = myguid;
ntd.taikhoan = taikhoan;
ntd.Xem=false;
ntd.Them=false;
ntd.Xoa=false;
ntd.Sua=false;
db.Nhom_TuDiens.InsertOnSubmit(ntd);
db.SubmitChanges();
}
public bool DangNhap(string taikhoan,string matkhau,ref string quyen)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
bool thanhcong = false;
NguoiDung check = (from p in db.NguoiDungs
where p.matkhau==matkhau &&p.taikhoan==taikhoan
&&p.banned==false
select p).Single();
if (check != null)
{
thanhcong = true;
quyen = check.quyen;
}
return thanhcong;
}
public void DangKy(NguoiDungBO nguoidungBO)
{
//Tạo mới một NguoiDung
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDung InsNguoiDung = new NguoiDung();
//Thêm thụôc tính cần Insert
InsNguoiDung.taikhoan = nguoidungBO.TaiKhoan;
InsNguoiDung.matkhau = nguoidungBO.MatKhau;
InsNguoiDung.email = nguoidungBO.Email;
InsNguoiDung.dt = nguoidungBO.DT;
InsNguoiDung.banned = false;
InsNguoiDung.quyen = "User";
//thực hiện Insert
db.NguoiDungs.InsertOnSubmit(InsNguoiDung);
db.SubmitChanges();
}
public BanBeCollection SelectBanBe(string taikhoan)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
BanBeCollection banbeColl = new BanBeCollection();
IEnumerable<Banbe> banbeList = from p in db.Banbes
where p.taikhoan == taikhoan
select p;
//Add range
foreach (Banbe bb in banbeList)
{
BanBeBO banbeBO = new BanBeBO();
banbeBO.TaiKhoan = bb.taikhoan;
banbeBO.TaiKhoanBan = bb.taikhoanban;
banbeColl.Add(banbeBO);
}
return banbeColl;
}
public TuDienCollection SelectTuDien(string taikhoan)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
TuDienCollection tdColl = new TuDienCollection();
IEnumerable<TuDien> tudien = from p in db.TuDiens
where p.taikhoan == taikhoan
select p;
//Addrange
foreach (TuDien tv in tudien)
{
TuDienBO tdBO = new TuDienBO();
tdBO.TuDienID = tv.TudienID.ToString();
tdBO.TaiKhoan = tv.taikhoan;
tdBO.TenTuDien = tv.TenTuDien;
tdBO.CongDong = (bool)tv.CongDong;
tdColl.Add(tdBO);
}
return tdColl;
}
public TinNhanCollection SelectTinNhan_ChuaDoc(string nguoinhan)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
IEnumerable<TinNhan> tinnhanList = from p in db.TinNhans
where p.Nguoinhan == nguoinhan
&& p.XacNhan==false
orderby p.NgayGoi ascending
select p;
//Addrange
TinNhanCollection tinhanColl = new TinNhanCollection();
foreach (TinNhan tin in tinnhanList)
{
TinNhanBO tn = new TinNhanBO();
tn.TinNhanID = tin.TinNhanID.ToString();
tn.NguoiNhan = tin.Nguoinhan;
tn.NguoiGoi = tin.Nguoigoi;
tn.NoiDung = tin.NoiDung;
tn.NgayGoi = Convert.ToDateTime(tin.NgayGoi);
tinhanColl.Add(tn);
}
return tinhanColl;
}
public void UpDateTuVung(string tuvungID)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Guid myguid = new Guid(tuvungID);
TuVung tv = db.TuVungs.SingleOrDefault(p => p.TuVungID == myguid);
tv.kiemduyet = true;
db.SubmitChanges();
}
public void Bannednick(string taikhoan, bool banned)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDung nguoidung = db.NguoiDungs.SingleOrDefault(p=>p.taikhoan.Trim()==taikhoan);
nguoidung.banned = banned;
db.SubmitChanges();
}
public NguoiDungCollection SelectAllNguoiDung(string tennguoiudung)
{
NguoiDungCollection nguoidungcoll = new NguoiDungCollection();
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
IEnumerable<NguoiDung> nguoidungList;
if (tennguoiudung != "")
{
nguoidungList = from p in db.NguoiDungs
where p.quyen.Trim() != "Admin"
&& p.taikhoan.Contains(tennguoiudung)
select p;
}
else
{
nguoidungList = from p in db.NguoiDungs
where p.quyen.Trim() != "Admin"
select p;
}
foreach(NguoiDung nd in nguoidungList)
{
NguoiDungBO ndBO = new NguoiDungBO();
ndBO.TaiKhoan = nd.taikhoan;
ndBO.Banned = (bool)nd.banned;
nguoidungcoll.Add(ndBO);
}
return nguoidungcoll;
}
public void DeleteNguoiDung_TuDien(string tudienid,string taikhoan)
{
Guid myguid = new Guid(tudienid);
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
var nguoidung_tudien = from p in db.Nhom_TuDiens
where p.TuDienID == myguid && p.taikhoan == taikhoan
select p;
db.Nhom_TuDiens.DeleteAllOnSubmit(nguoidung_tudien);
db.SubmitChanges();
}
public NguoiDungCollection SelectNguoiDung_TuDien(string tudienID)
{
NguoiDungCollection ndColl = new NguoiDungCollection();
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
IEnumerable<Nhom_TuDien> nguoidunglist = from p in db.Nhom_TuDiens
where p.TuDienID.ToString() == tudienID
select p;
//Addrange
foreach (Nhom_TuDien nd in nguoidunglist)
{
NguoiDungBO ndBO= new NguoiDungBO();
ndBO.TaiKhoan=nd.taikhoan;
ndColl.Add(ndBO);
}
return ndColl;
}
public TuDienBO Select_NguoiDung_Quyen(string tudienID, string taikhoan)
{
//Đọc dữ liệu --> lấy ra các quyền của [taikhan] trên [tudienID]
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Nhom_TuDien ntd = new Nhom_TuDien();
Guid myguid = new Guid(tudienID);
Nhom_TuDien temp = (from p in db.Nhom_TuDiens
where p.taikhoan==taikhoan && p.TuDienID==myguid
select p).SingleOrDefault();
//Gán dữ liệu để truyền đi
TuDienBO tudienBO = new TuDienBO();
tudienBO.TuDienID = tudienID;
tudienBO.TaiKhoan = taikhoan;
tudienBO.Xem =(bool) temp.Xem;
tudienBO.Them =(bool) temp.Them;
tudienBO.Xoa = (bool)temp.Xoa;
tudienBO.Sua = (bool)temp.Sua;
return tudienBO;
}
public void Update_NguoiDung_Quyen(TuDienBO tudienBO)
{
//Đọc dữ liệu --> lấy ra các quyền của [taikhan] trên [tudienID]
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Nhom_TuDien ntd = new Nhom_TuDien();
Guid myguid = new Guid(tudienBO.TuDienID );
Nhom_TuDien temp = (from p in db.Nhom_TuDiens
where p.taikhoan ==tudienBO.TaiKhoan && p.TuDienID == myguid
select p).SingleOrDefault();
//Cập nhật lại quyền
temp.Xem = tudienBO.Xem;
temp.Them = tudienBO.Them;
temp.Xoa = tudienBO.Xoa;
temp.Sua = tudienBO.Sua;
db.SubmitChanges();
}
public void UpDateTuVung(TuVungBO tuvungBO,int to,bool hasimage)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
Guid myguid = new Guid(tuvungBO.TuVungID);
TuVung tv = db.TuVungs.SingleOrDefault(p=>p.TuVungID==myguid);
tv.TuVung1 = tuvungBO.TuVung;
if(hasimage==true)
tv.Hinhanh = tuvungBO.HinhAnh;
tv.LoaiTuID = tuvungBO.LoaiTuID;
tv.NghiaTu = tuvungBO.NghiaTu;
tv.SoLanSai = tuvungBO.SoLanSai;
tv.SoLanSuDung = tuvungBO.SoLanSuDung;
tv.Vidu = tuvungBO.ViDu;
Guid myguid1 = new Guid(tuvungBO.TuDienID);
tv.TuDienID = myguid1;
tv.taikhoan = tuvungBO.TaiKhoan;
//Insert vào từ điển cộng đồng
if (to == 3)
{
tv.kiemduyet = tuvungBO.KiemDuyet;
}
db.SubmitChanges();
}
public TuDienCollection SelectTuDien_CongDong(string tentudien)
{
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
TuDienCollection tdColl = new TuDienCollection();
IEnumerable<TuDien> tudien;
if (tentudien != "")
{
tudien = from p in db.TuDiens
where p.CongDong == true
&& p.TenTuDien.Contains(tentudien)
select p;
}
else
{
tudien = from p in db.TuDiens
where p.CongDong == true
select p;
}
//Addrange
foreach (TuDien tv in tudien)
{
TuDienBO tdBO = new TuDienBO();
tdBO.TuDienID = tv.TudienID.ToString();
tdBO.TaiKhoan = tv.taikhoan;
tdBO.TenTuDien = tv.TenTuDien;
tdBO.CongDong = (bool)tv.CongDong;
tdColl.Add(tdBO);
}
return tdColl;
}
public void Change_NguoiDung_Info(NguoiDungBO nguoidungBO)
{
string taikhoan = nguoidungBO.TaiKhoan;
string matkhau = nguoidungBO.MatKhau;
string email = nguoidungBO.Email;
string dt = nguoidungBO.DT;
string quyen = nguoidungBO.Quyen;
//Lấy thông tin ngừoi dùng
hoctuvungLINQDataContext db = new hoctuvungLINQDataContext();
NguoiDung ndtemp = db.NguoiDungs.Single(p => p.taikhoan == taikhoan);
//Cập nhật lại thông tin ngừơi dùng
if (matkhau != "") ndtemp.matkhau = matkhau;
if (email != "") ndtemp.email = email;
if (dt != "") ndtemp.dt = dt;
if (quyen != "") ndtemp.quyen = quyen;
db.SubmitChanges();
}
public void DeleteTuVung(string tuvungID)
{
hoctuvungLINQDataContext db= new hoctuvungLINQDataContext();
Guid mygui = new Guid(tuvungID);
TuVung tv = db.TuVungs.Single(p => p.TuVungID == mygui);
db.TuVungs.DeleteOnSubmit(tv);
db.SubmitChanges();
}
