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 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 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 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 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 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 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 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 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 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(); }
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 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 InsertTuVung(TuVungBO tuvungBO) { hoctuvungLINQDataContext db = new hoctuvungLINQDataContext(); TuVung tv = new TuVung(); tv.TuVungID = Guid.NewGuid(); tv.TuVung1 = tuvungBO.TuVung; 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 myguid = new Guid(tuvungBO.TuDienID); tv.TuDienID = myguid; tv.taikhoan = tuvungBO.TaiKhoan; tv.kiemduyet = true; db.TuVungs.InsertOnSubmit(tv); db.SubmitChanges(); }
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 InsertTuVung(TuVungBO tuvungBO, int to) { hoctuvungLINQDataContext db= new hoctuvungLINQDataContext(); TuVung tv = new TuVung(); tv.TuVungID = Guid.NewGuid(); tv.TuVung1 = tuvungBO.TuVung; 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 myguid = new Guid(tuvungBO.TuDienID); tv.TuDienID = myguid; tv.taikhoan = tuvungBO.TaiKhoan; //Insert vào từ điển cá nhân //Insert vào từ điển đựơc sử dụng chung if (to == 1 || to == 2) { db.TuVungs.InsertOnSubmit(tv); } //Insert vào từ điển cộng đồng else if (to == 3) { tv.kiemduyet = false; } db.TuVungs.InsertOnSubmit(tv); db.SubmitChanges(); }