//Lấy danh sách accounts
/* public List<Account> GetAllAccounts()
* {
* return accounts;
* }*/
public String getRoleAccount(int id)
{
db = new LinQDataContext();
var result = db.getAccountById(id).FirstOrDefault();
return(result.Role);
}
public List<TAPTINTHONGBAO> SelectTAPTINTHONGBAOsAll()
{
List<TAPTINTHONGBAO> list = new List<TAPTINTHONGBAO>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<TAPTINTHONGBAO_getallResult> lp = db.TAPTINTHONGBAO_getall();
foreach (TAPTINTHONGBAO_getallResult TAPTINTHONGBAO in lp)
{
TAPTINTHONGBAO var1 = new TAPTINTHONGBAO();
var1.MaTapTin = TAPTINTHONGBAO.MaTapTin ;
var1.TenTapTin = TAPTINTHONGBAO.TenTapTin ;
var1.DuongDan = TAPTINTHONGBAO.DuongDan;
var1.MaThongBao = TAPTINTHONGBAO.MaThongBao;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<LOAIBAIVIET_getall_chitietResult> SelectLOAIBAIVIETsAll_chitiet()
{
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
return db.LOAIBAIVIET_getall_chitiet().ToList<LOAIBAIVIET_getall_chitietResult>();
}
}
public List<GOPY> SelectGopYsAll()
{
List<GOPY> list = new List<GOPY>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<GOPY_getallResult> lp = db.GOPY_getall();
foreach (GOPY_getallResult GOPY in lp)
{
GOPY var1 = new GOPY();
var1.MaGopY = GOPY.MaGopY;
var1.TieuDe = GOPY.TieuDe;
var1.NoiDungGopY = GOPY.NoiDungGopY;
var1.MSSV = GOPY.MSSV;
var1.Email = GOPY.Email;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<GIOITHIEU> SelectGIOITHIEUsAll()
{
List<GIOITHIEU> list = new List<GIOITHIEU>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<GIOITHIEU_getallResult> lp = db.GIOITHIEU_getall();
foreach (GIOITHIEU_getallResult GIOITHIEU in lp)
{
GIOITHIEU var1 = new GIOITHIEU();
var1.MaBai = GIOITHIEU.MaBai ;
var1.TieuDe = GIOITHIEU.TieuDe ;
var1.NoiDung = GIOITHIEU.NoiDung ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<KHAOSAT> SelectKHAOSATsAll()
{
List<KHAOSAT> list = new List<KHAOSAT>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<KHAOSAT_getallResult> lp = db.KHAOSAT_getall();
foreach (KHAOSAT_getallResult KHAOSAT in lp)
{
KHAOSAT var1 = new KHAOSAT();
var1.MaDapAn = KHAOSAT.MaDapAn ;
var1.MaYKKS = KHAOSAT.MaYKKS ;
var1.YKienKhac = KHAOSAT.YKienKhac ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<DANGKYHOATDONG_getallResult> SelectDANGKYHOATDONGsAll()
{
List<DANGKYHOATDONG_getallResult> list = new List<DANGKYHOATDONG_getallResult>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<DANGKYHOATDONG_getallResult> lp = db.DANGKYHOATDONG_getall();
foreach (DANGKYHOATDONG_getallResult DANGKYHOATDONG in lp)
{
DANGKYHOATDONG_getallResult var1 = new DANGKYHOATDONG_getallResult();
var1.MaHoatDong = DANGKYHOATDONG.MaHoatDong ;
var1.MaNguoiDung = DANGKYHOATDONG.MaNguoiDung ;
var1.Username = DANGKYHOATDONG.Username;
var1.TenHoatDong = DANGKYHOATDONG.TenHoatDong;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<BAIHAT> SelectBAIHATsAll()
{
List<BAIHAT> list = new List<BAIHAT>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<BAIHAT_getallResult> lp = db.BAIHAT_getall();
foreach (BAIHAT_getallResult BAIHAT in lp)
{
BAIHAT var1 = new BAIHAT();
var1.MaBaiHat = BAIHAT.MaBaiHat ;
var1.TenBaiHat = BAIHAT.TenBaiHat ;
var1.LinkBaiHat = BAIHAT.LinkBaiHat ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<ALBUM> SelectALBUMsAll()
{
List<ALBUM> list = new List<ALBUM>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<ALBUM_getallResult> lp = db.ALBUM_getall();
foreach (ALBUM_getallResult ALBUM in lp)
{
ALBUM var1 = new ALBUM();
var1.MaAlbum = ALBUM.MaAlbum ;
var1.TenAlbum = ALBUM.TenAlbum ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<NGUOIDUNG_getallResult> SelectNGUOIDUNGsAll()
{
List<NGUOIDUNG_getallResult> list = new List<NGUOIDUNG_getallResult>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<NGUOIDUNG_getallResult> lp = db.NGUOIDUNG_getall();
foreach (NGUOIDUNG_getallResult NGUOIDUNG in lp)
{
NGUOIDUNG_getallResult var1 = new NGUOIDUNG_getallResult();
var1.MaNguoiDung = NGUOIDUNG.MaNguoiDung;
var1.Username = NGUOIDUNG.Username;
var1.Password = NGUOIDUNG.Password;
var1.HoTen = NGUOIDUNG.HoTen;
var1.Email = NGUOIDUNG.Email;
var1.MaVaiTro = NGUOIDUNG.MaVaiTro;
var1.TenLoaiVaiTro = NGUOIDUNG.TenLoaiVaiTro;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<DANGKYHOATDONG> SelectDANGKYHOATDONGbyMASV(int MaNguoiDung)
{
List<DANGKYHOATDONG> dsDKHoatDong = new List<DANGKYHOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<DANGKYHOATDONG_selectbySinhVienResult> lp = db.DANGKYHOATDONG_selectbySinhVien(MaNguoiDung);
foreach (DANGKYHOATDONG_selectbySinhVienResult aDKHoatDong in lp)
{
DANGKYHOATDONG var1 = new DANGKYHOATDONG();
var1.MaHoatDong = aDKHoatDong.MaHoatDong;
var1.MaNguoiDung = aDKHoatDong.MaNguoiDung;
dsDKHoatDong.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return dsDKHoatDong;
}
public List<HOATDONG> SelectHOATDONGByLoai(int iMaLoaiHoatDong)
{
List<HOATDONG> KetQua = new List<HOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HOATDONG_GetByLoaiResult> dsHoatDong = db.HOATDONG_GetByLoai(iMaLoaiHoatDong);
foreach (HOATDONG_GetByLoaiResult HOATDONG in dsHoatDong)
{
HOATDONG aHoatDong = new HOATDONG();
aHoatDong.MaHoatDong = HOATDONG.MaHoatDong;
aHoatDong.TenHoatDong = HOATDONG.TenHoatDong;
aHoatDong.NgayDienRa = HOATDONG.NgayDienRa;
aHoatDong.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong;
aHoatDong.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy;
aHoatDong.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy;
aHoatDong.HinhAnh = HOATDONG.HinhAnh;
KetQua.Add(aHoatDong);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return KetQua;
}
public int getMaBaiVietLichLamViec()
{
int ma = -1;
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<TAPTINBAIVIET_getmabaivietlichlamviecResult> lp = db.TAPTINBAIVIET_getmabaivietlichlamviec();
foreach (TAPTINBAIVIET_getmabaivietlichlamviecResult lichlamviec in lp)
{
ma = lichlamviec.MaBaiViet;
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return ma;
}
public List<HINHANH> SelectHINHANHsAll()
{
List<HINHANH> list = new List<HINHANH>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HINHANH_getallResult> lp = db.HINHANH_getall();
foreach (HINHANH_getallResult HINHANH in lp)
{
HINHANH var1 = new HINHANH();
var1.MaHinhAnh = HINHANH.MaHinhAnh ;
var1.DuongDan = HINHANH.DuongDan ;
var1.MaAlbum = HINHANH.MaAlbum ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<TAPTINBAIVIET> getLichLamViec()
{
List<TAPTINBAIVIET> list = new List<TAPTINBAIVIET>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<TAPTINBAIVIET_getLichLamViecResult> lp = db.TAPTINBAIVIET_getLichLamViec();
foreach (TAPTINBAIVIET_getLichLamViecResult TAPTINBAIVIET in lp)
{
TAPTINBAIVIET var1 = new TAPTINBAIVIET();
var1.MaTapTin = TAPTINBAIVIET.MaTapTin;
var1.TenTapTin = TAPTINBAIVIET.TenTapTin;
var1.DuongDan = TAPTINBAIVIET.DuongDan;
var1.MaBaiViet = TAPTINBAIVIET.MaBaiViet;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public List<CAUHOIKHAOSAT> SelectCAUHOIKHAOSATsAll()
{
List<CAUHOIKHAOSAT> list = new List<CAUHOIKHAOSAT>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<CAUHOIKHAOSAT_getallResult> lp = db.CAUHOIKHAOSAT_getall();
foreach (CAUHOIKHAOSAT_getallResult CAUHOIKHAOSAT in lp)
{
CAUHOIKHAOSAT var1 = new CAUHOIKHAOSAT();
var1.MaCauHoiKhaoSat = CAUHOIKHAOSAT.MaCauHoiKhaoSat ;
var1.NoiDung = CAUHOIKHAOSAT.NoiDung ;
var1.BiKhoa = CAUHOIKHAOSAT.BiKhoa ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
// lấy danh sách các câu hỏi:
public List<CAUHOITHUONGGAP> LayDanhSachTatCaCauHoi()
{
List<CAUHOITHUONGGAP> lstCauHoi = new List<CAUHOITHUONGGAP>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<FAQ_getallCauHoiResult> lp = db.FAQ_getallCauHoi();
foreach (FAQ_getallCauHoiResult CAUHOITHUONGGAP in lp)
{
CAUHOITHUONGGAP var1 = new CAUHOITHUONGGAP();
var1.MaCauHoi = CAUHOITHUONGGAP.MaCauHoi;
var1.NoiDungCauHoi = CAUHOITHUONGGAP.NoiDungCauHoi;
lstCauHoi.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return lstCauHoi;
}
public List<HETHONGTOCHUC> SelectHETHONGTOCHUCsAll()
{
List<HETHONGTOCHUC> list = new List<HETHONGTOCHUC>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HETHONGTOCHUC_getallResult> lp = db.HETHONGTOCHUC_getall ();
foreach (HETHONGTOCHUC_getallResult HETHONGTOCHUC in lp)
{
HETHONGTOCHUC var1 = new HETHONGTOCHUC();
var1.MaBai = HETHONGTOCHUC.MaBai;
var1.TieuDe = HETHONGTOCHUC.TieuDe ;
var1.NoiDung = HETHONGTOCHUC.NoiDung ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public int CapNhat(DANGKYMUONPHONG lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.DANGKYMUONPHONG_update(
lpDTO.MaDangKy,
lpDTO.MaNguoiDung,
lpDTO.NgayDangKy,
lpDTO.NgaySuDung,
lpDTO.SoLuong,
lpDTO.MucDich,
lpDTO.DonViMuon,
lpDTO.KQPhong,
lpDTO.TGBatDau,
lpDTO.TGKetThuc,
lpDTO.KetQua
);
db.SubmitChanges();
return 0;
}
catch (Exception ex)
{
throw (ex);
}
}
public List<LOAIHOATDONG> SelectLOAIHOATDONGsAll()
{
List<LOAIHOATDONG> list = new List<LOAIHOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<LOAIHOATDONG_getallResult> lp = db.LOAIHOATDONG_getall();
foreach (LOAIHOATDONG_getallResult LOAIHOATDONG in lp)
{
LOAIHOATDONG var1 = new LOAIHOATDONG();
var1.MaLoaiHoatDong = LOAIHOATDONG.MaLoaiHoatDong ;
var1.TenLoaiHoatDong = LOAIHOATDONG.TenLoaiHoatDong ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public Account userLogin(string username, string password)
{
/*
* Account account = new Account();
* accounts.ForEach(ac =>
* {
* if (ac.UserName.Trim() == username.Trim() && ac.Password.Trim() == password.Trim())
* {
* account = ac;
* }
* });
* return account;*/
db = new LinQDataContext();
var result = db.userLogin(username, password).FirstOrDefault();
if (result != null)
{
Account account = new Account();
account.AccountId = result.AccountId;
account.Password = result.Password;
account.Role = result.Role;
account.UserName = result.UserName;
return(account);
}
return(null);
}
public List<HOATDONG> SelectHOATDONGsAll()
{
List<HOATDONG> list = new List<HOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<HOATDONG_getallResult> lp = db.HOATDONG_getall();
foreach (HOATDONG_getallResult HOATDONG in lp)
{
HOATDONG var1 = new HOATDONG();
var1.MaHoatDong = HOATDONG.MaHoatDong ;
var1.TenHoatDong = HOATDONG.TenHoatDong ;
var1.NgayDienRa = HOATDONG.NgayDienRa ;
var1.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong ;
var1.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy ;
var1.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy ;
var1.HinhAnh = HOATDONG.HinhAnh;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public Schedule getLastSchedule()
{
Schedule schedule = new Schedule();
db = new LinQDataContext();
var list = db.getLastSchedule().ToList();
list.ForEach(x =>
{
schedule.UniqueID = x.UniqueID;
schedule.Type = x.Type;
schedule.StartDate = x.StartDate;
schedule.EndDate = x.EndDate;
schedule.AllDay = x.AllDay;
schedule.Subject = x.Subject;
schedule.Location = x.Location;
schedule.Description = x.Description;
schedule.Status = x.Status;
schedule.Label = x.Label;
schedule.ApprovalStatus = x.ApprovalStatus;
schedule.AccountId = x.AccountId;
schedule.DepartmentsList = x.DepartmentsList;
schedule.PositionList = x.PositionList;
});
return(schedule);
}
public Schedule getLastSchedule(Account account)
{
Schedule schedule = new Schedule();
db = new LinQDataContext();
var x = db.getLastedScheduleByAccountID(account.AccountId).FirstOrDefault();
if (x != null)
{
schedule.UniqueID = x.UniqueID;
schedule.Type = x.Type;
schedule.StartDate = x.StartDate;
schedule.EndDate = x.EndDate;
schedule.AllDay = x.AllDay;
schedule.Subject = x.Subject;
schedule.Location = x.Location;
schedule.Description = x.Description;
schedule.Status = x.Status;
schedule.Label = x.Label;
schedule.ApprovalStatus = x.ApprovalStatus;
schedule.AccountId = x.AccountId;
schedule.DepartmentsList = x.DepartmentsList;
schedule.PositionList = x.PositionList;
return(schedule);
}
return(null);
}
public List<LOAIBAIVIET> SelectLOAIBAIVIETsAll()
{
List<LOAIBAIVIET> list = new List<LOAIBAIVIET>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<LOAIBAIVIET_getallResult> lp = db.LOAIBAIVIET_getall();
foreach (LOAIBAIVIET_getallResult LOAIBAIVIET in lp)
{
LOAIBAIVIET var1 = new LOAIBAIVIET();
var1.MaLoaiBaiViet = LOAIBAIVIET.MaLoaiBaiViet;
var1.TenLoaiBaiViet = LOAIBAIVIET.TenLoaiBaiViet;
var1.MaChuyenMuc = LOAIBAIVIET.MaChuyenMuc;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
//Xóa tài khoản
public void DeleteAccount(int accountId)
{
db = new LinQDataContext();
Account ac = new Account();
ac = db.Accounts.Single(x => x.AccountId == accountId);
db.Accounts.DeleteOnSubmit(ac);
db.SubmitChanges();
}
//Tạo tài khoản
public void CreateAccount(Account account)
{
db = new LinQDataContext();
Account ac = new Account();
ac = account;
db.Accounts.InsertOnSubmit(ac);
db.SubmitChanges();
}
//Lấy database từ cơ sở dữ liệu
public AccountDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var account = from x in db.Accounts select x;
accounts = account.ToList();
}
}
//Cập nhật tài khoản
public void UpdateAccount(Account account)
{
db = new LinQDataContext();
Account ac = new Account();
ac = db.Accounts.Single(x => x.AccountId == account.AccountId);
setAccountUpdate(ac, account);
db.SubmitChanges();
}
public DrugInPrescriptionDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var drugInPrescription = from x in db.DrugInPrescriptions select x;
drugInPrescriptions = drugInPrescription.ToList();
}
}
//Cập nhật nhân viên
public void UpdateEmployee(Employee employee)
{
db = new LinQDataContext();
Employee emp = new Employee();
emp = db.Employees.Single(x => x.EmployeeId == employee.EmployeeId);
setEmployeeUpdate(emp, employee);
db.SubmitChanges();
}
public void AddScheduleForDepartment(ScheduleDepartment scheduleDepartment)
{
db = new LinQDataContext();
ScheduleDepartment schedule = new ScheduleDepartment();
schedule = scheduleDepartment;
db.ScheduleDepartments.InsertOnSubmit(schedule);
db.SubmitChanges();
}
public PrescriptionDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var prescription = from x in db.Prescriptions select x;
prescriptions = prescription.ToList();
}
}
//Cập nhật phòng ban
public void UpdateDepartment(Department department)
{
db = new LinQDataContext();
Department dep = new Department();
dep = db.Departments.Single(x => x.DepartmentId == department.DepartmentId);
setDepartmentUpdate(dep, department);
db.SubmitChanges();
}
//Lấy databse từ cơ sở dữ liệu
public EmployeeDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var employee = from x in db.Employees select x;
employees = employee.ToList();
}
}
public DepartmentDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var department = from x in db.Departments select x;
departments = department.ToList();
}
}
public void AddScheduleForPostion(SchedulePosition schedulePosition)
{
db = new LinQDataContext();
SchedulePosition schedule = new SchedulePosition();
schedule = schedulePosition;
db.SchedulePositions.InsertOnSubmit(schedule);
db.SubmitChanges();
}
//Xóa phòng ban
public void DeleteDepartment(int departmentId)
{
db = new LinQDataContext();
Department dep = new Department();
dep = db.Departments.Single(x => x.DepartmentId == departmentId);
db.Departments.DeleteOnSubmit(dep);
db.SubmitChanges();
}
public UserDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var user = from x in db.Users select x;
users = user.ToList();
}
}
//Cập nhật chức vụ
public void UpdatePosition(Position position)
{
db = new LinQDataContext();
Position po = new Position();
po = db.Positions.Single(x => x.PositionId == position.PositionId);
setPositionUpdate(po, position);
db.SubmitChanges();
}
public PositionDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var position = from x in db.Positions select x;
positions = position.ToList();
}
}
//Tạo nhân viên mới
public void CreateEmployee(Employee employee)
{
db = new LinQDataContext();
Employee emp = new Employee();
emp = employee;
db.Employees.InsertOnSubmit(emp);
db.SubmitChanges();
}
//Xóa nhân viên
public void DeleteEmployee(int employeeId)
{
db = new LinQDataContext();
Employee emp = new Employee();
emp = db.Employees.Single(x => x.EmployeeId == employeeId);
db.Employees.DeleteOnSubmit(emp);
db.SubmitChanges();
}
//Xóa chức vụ
public void DeletePosition(int positionId)
{
db = new LinQDataContext();
Position po = new Position();
po = db.Positions.Single(x => x.PositionId == positionId);
db.Positions.DeleteOnSubmit(po);
db.SubmitChanges();
}
public User createUser(User user)
{
db = new LinQDataContext();
User us = new User();
us = user;
db.Users.InsertOnSubmit(us);
db.SubmitChanges();
return(us);
}
public Prescription createPrescription(Prescription prescription)
{
db = new LinQDataContext();
Prescription pre = new Prescription();
pre = prescription;
db.Prescriptions.InsertOnSubmit(pre);
db.SubmitChanges();
return(pre);
}
//Lấy databse từ cơ sở dữ liệu
public EmployeeDaoImpl()
{
db = new LinQDataContext();
using (db)
{
var employee = from x in db.Employees select x;
db.DeferredLoadingEnabled = false;
employees = employee.ToList();
}
}
//Thêm chức vụ
public Position CreatePosition(Position position)
{
db = new LinQDataContext();
Position po = new Position();
po = position;
db.Positions.InsertOnSubmit(po);
db.SubmitChanges();
return(po);
}
//Thêm phòng ban
public Department CreateDepartment(Department department)
{
db = new LinQDataContext();
Department dep = new Department();
dep = department;
db.Departments.InsertOnSubmit(dep);
db.SubmitChanges();
return(dep);
}
public DrugInPrescription createDrugInPrescription(DrugInPrescription drugInPrescription)
{
db = new LinQDataContext();
DrugInPrescription drug = new DrugInPrescription();
drug = drugInPrescription;
db.DrugInPrescriptions.InsertOnSubmit(drug);
db.SubmitChanges();
return(drug);
}
public void deleteSchdeduleDepartment(ScheduleDepartment scheduleDepartment)
{
db = new LinQDataContext();
ScheduleDepartment sch = new ScheduleDepartment();
sch = db.ScheduleDepartments.FirstOrDefault(x => x.idSchedule == scheduleDepartment.idSchedule && x.idDepartment == scheduleDepartment.idDepartment);
if (sch != null)
{
db.ScheduleDepartments.DeleteOnSubmit(sch);
db.SubmitChanges();
}
}
// Sửa câu hỏi thường gặp
public int SuaFAQ(int macauhoi,string noidungcauhoi, string cautraloi)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.FAQ_modify(macauhoi, noidungcauhoi, cautraloi);
return 1;
}
catch
{
return 0;
}
}
public int CapNhat(LOAIHOATDONG lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.LOAIHOATDONG_update(
lpDTO.MaLoaiHoatDong ,
lpDTO.TenLoaiHoatDong
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int Them(LOAIVAITRO lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.LOAIVAITRO_add(
lpDTO.TenLoaiVaiTro
);
return 1;
}
catch
{
return 0;
}
}
public int CapNhat(ALBUM lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.ALBUM_update(
lpDTO.MaAlbum,
lpDTO.TenAlbum
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int CapNhat(HETHONGTOCHUC lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.HETHONGTOCHUC_update(
lpDTO.MaBai,
lpDTO.TieuDe ,
lpDTO.NoiDung
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int Them(HETHONGTOCHUC lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.HETHONGTOCHUC_add(
lpDTO.TieuDe ,
lpDTO.NoiDung
);
return 1;
}
catch
{
return 0;
}
}
public int Them(BAIHAT lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.BAIHAT_add(
lpDTO.TenBaiHat ,
lpDTO.LinkBaiHat
);
return 1;
}
catch
{
return 0;
}
}
public int CapNhat(BAIHAT lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.BAIHAT_update(
lpDTO.MaBaiHat,
lpDTO.TenBaiHat,
lpDTO.LinkBaiHat
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int Them(ALBUM lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.ALBUM_add(
lpDTO.TenAlbum
);
return 1;
}
catch (Exception ex)
{
throw (ex);
//return 0;
}
}
