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