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