private void btnLuu_Click(object sender, EventArgs e) { try { DSSV.EndCurrentEdit(); db.SubmitChanges(); enableNutLenh(false); }catch (Exception ex) { MessageBox.Show(ex.Message); } }
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 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<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 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<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> 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<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; }
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 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<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<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<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<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 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<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<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; }
//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(); }
//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(); }
//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(); }
//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(); }
//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(); }
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 void AddScheduleForDepartment(ScheduleDepartment scheduleDepartment) { db = new LinQDataContext(); ScheduleDepartment schedule = new ScheduleDepartment(); schedule = scheduleDepartment; db.ScheduleDepartments.InsertOnSubmit(schedule); db.SubmitChanges(); }
//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(); }
//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(); }
//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(); }
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); }
public DrugInPrescription createDrugInPrescription(DrugInPrescription drugInPrescription) { db = new LinQDataContext(); DrugInPrescription drug = new DrugInPrescription(); drug = drugInPrescription; db.DrugInPrescriptions.InsertOnSubmit(drug); db.SubmitChanges(); return(drug); }
//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); }
//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); }
public void DeleteSchedulePostion(SchedulePosition schedule) { db = new LinQDataContext(); SchedulePosition sch = new SchedulePosition(); sch = db.SchedulePositions.FirstOrDefault(x => x.idSchedule == schedule.idSchedule && x.idPosition == schedule.idPosition); if (sch != null) { db.SchedulePositions.DeleteOnSubmit(sch); db.SubmitChanges(); } }
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(); } }
protected void Button1_Click(object sender, EventArgs e) { string reserid = TextBox1.Text; using (LinQDataContext dbcontext = new LinQDataContext()) { Reservation reserv = dbcontext.Reservations.FirstOrDefault(reserve => reserve.ReservationId == reserid); reserv.Status = "Cancel"; dbcontext.SubmitChanges(); } Response.Write("<script>alert('Record cancel successfully')</script>"); }
public int CapNhat(LOAIBAIVIET lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.LOAIBAIVIET_update( lpDTO.MaLoaiBaiViet, lpDTO.TenLoaiBaiViet, lpDTO.MaChuyenMuc ); db.SubmitChanges(); return 1; } catch (Exception ex) { throw (ex); } }
public int CapNhat(CAUHOIKHAOSAT lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.CAUHOIKHAOSAT_update( lpDTO.MaCauHoiKhaoSat, lpDTO.NoiDung, lpDTO.BiKhoa ); db.SubmitChanges(); return 0; } catch (Exception ex) { throw (ex); } }
public List<BAIVIET> LayBaiVietMoiNhat(int SoLuong) { List<BAIVIET> list = new List<BAIVIET>(); using (LinQDataContext db = new LinQDataContext()) { ISingleResult<BAIVIET_LayBaiVietMoiNhatResult> lp = db.BAIVIET_LayBaiVietMoiNhat(); int i = 0; foreach(BAIVIET_LayBaiVietMoiNhatResult bv in lp) { if (i == SoLuong) { break; } //BAIVIET_LayBaiVietMoiNhatResult bv = temp[i]; BAIVIET var1 = new BAIVIET(); var1.MaBaiViet = bv.MaBaiViet; var1.TieuDe = bv.TieuDe; var1.NoiDung = bv.NoiDung; var1.MaLoaiBaiViet = bv.MaLoaiBaiViet; var1.NgayDang = bv.NgayDang; var1.HinhAnh = bv.HinhAnh; var1.TomTat = bv.TomTat; if (bv.CapNhat!=null) var1.CapNhat = (DateTime)bv.CapNhat; list.Add(var1); i++; } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }
public int CapNhat(BAIVIET lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.BAIVIET_update( lpDTO.MaBaiViet, lpDTO.TieuDe, lpDTO.NoiDung, lpDTO.MaLoaiBaiViet, lpDTO.NgayDang, lpDTO.CapNhat, lpDTO.HinhAnh, lpDTO.TomTat, lpDTO.TinNoiBat ); db.SubmitChanges(); return 0; } catch (Exception ex) { throw (ex); } }
public List<DANGKYMUONPHONG> SelectDANGKYMUONPHONGBYDATE(DateTime NgayXoa) { List<DANGKYMUONPHONG> list = new List<DANGKYMUONPHONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<DANGKYMUONPHONG> lp = db.DANGKYMUONPHONG_getbydate(NgayXoa); foreach (DANGKYMUONPHONG DANGKYMUONPHONG in lp) { DANGKYMUONPHONG var1 = new DANGKYMUONPHONG(); var1.MaDangKy = DANGKYMUONPHONG.MaDangKy; var1.MaNguoiDung = DANGKYMUONPHONG.MaNguoiDung; var1.NgaySuDung = DANGKYMUONPHONG.NgaySuDung; var1.SoLuong = DANGKYMUONPHONG.SoLuong; var1.MucDich = DANGKYMUONPHONG.MucDich; var1.DonViMuon = DANGKYMUONPHONG.DonViMuon; var1.KQPhong = DANGKYMUONPHONG.KQPhong; var1.NgayDangKy = DANGKYMUONPHONG.NgayDangKy; var1.KetQua = DANGKYMUONPHONG.KetQua; 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 Xoa(int macauhoikhaosat) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.CAUHOIKHAOSAT_delete(macauhoikhaosat); db.SubmitChanges(); return 0; } catch (Exception ex) { throw (ex); } }
public int Xoa(int maalbum) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.ALBUM_delete(maalbum); db.SubmitChanges(); return 0; } catch (Exception ex) { throw (ex); } }
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 List<BAIVIET> SelectBAIVIETsAll() { List<BAIVIET> list = new List<BAIVIET>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<BAIVIET_getallResult> lp = db.BAIVIET_getall(); foreach (BAIVIET_getallResult BAIVIET in lp) { BAIVIET var1 = new BAIVIET(); var1.MaBaiViet = BAIVIET.MaBaiViet; var1.TieuDe = BAIVIET.TieuDe; var1.NoiDung = BAIVIET.NoiDung; var1.MaLoaiBaiViet = BAIVIET.MaLoaiBaiViet; var1.NgayDang = BAIVIET.NgayDang; var1.HinhAnh = BAIVIET.HinhAnh; var1.TomTat = BAIVIET.TieuDe; if (BAIVIET.CapNhat != null) var1.CapNhat = (DateTime)BAIVIET.CapNhat; 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<BAIVIET> TimKiemTheoLoaiBaiViet(int MaLoaiBaiViet) { List<BAIVIET> list = new List<BAIVIET>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { // ISingleResult<BAIVIET_TimKiemTheoLoaiBaiVietResult> lp = db.BAIVIET_TimKiemTheoLoaiBaiViet(MaLoaiBaiViet); // foreach (BAIVIET_TimKiemTheoLoaiBaiVietResult BAIVIET in lp) // { // BAIVIET var1 = new BAIVIET(); // var1.MaBaiViet = BAIVIET.MaBaiViet; // var1.TieuDe = BAIVIET.TieuDe; // var1.NoiDung = BAIVIET.NoiDung; // var1.MaLoaiBaiViet = BAIVIET.MaLoaiBaiViet; // var1.NgayDang = BAIVIET.NgayDang; // var1.HinhAnh = BAIVIET.HinhAnh; // var1.TomTat = BAIVIET.TomTat; // if (BAIVIET.CapNhat != null) // var1.CapNhat = (DateTime)BAIVIET.CapNhat; // list.Add(var1); // } var rs = from n in db.BAIVIETs where n.MaLoaiBaiViet == MaLoaiBaiViet orderby n.MaBaiViet descending select n; list = rs.ToList(); try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }
public List<DANGKYMUONPHONG> SelectDANGKYMUONPHONGbySinhVien(int MaSV) { List<DANGKYMUONPHONG> dsDKMuonPhong = new List<DANGKYMUONPHONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<DANGKYMUONPHONG_selectBySinhVienResult> lp = db.DANGKYMUONPHONG_selectBySinhVien(MaSV); foreach (DANGKYMUONPHONG_selectBySinhVienResult DANGKYMUONPHONG in lp) { DANGKYMUONPHONG var1 = new DANGKYMUONPHONG(); var1.MaDangKy = DANGKYMUONPHONG.MaDangKy; var1.MaNguoiDung = DANGKYMUONPHONG.MaNguoiDung; var1.TGBatDau = DANGKYMUONPHONG.TGBatDau; var1.TGKetThuc = DANGKYMUONPHONG.TGKetThuc; var1.NgaySuDung = DANGKYMUONPHONG.NgaySuDung; var1.SoLuong = DANGKYMUONPHONG.SoLuong; var1.MucDich = DANGKYMUONPHONG.MucDich; var1.DonViMuon = DANGKYMUONPHONG.DonViMuon; var1.KQPhong = DANGKYMUONPHONG.KQPhong; var1.NgayDangKy = DANGKYMUONPHONG.NgayDangKy; var1.KetQua = DANGKYMUONPHONG.KetQua; dsDKMuonPhong.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return dsDKMuonPhong; }
public List<BAIVIET> LayBaiVietMoiNhatTheoChuyenMuc(int MaChuyenMuc) { List<BAIVIET> list = new List<BAIVIET>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMucResult> lp = db.BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMuc(MaChuyenMuc); foreach (BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMucResult bv in lp) { //BAIVIET_LayBaiVietMoiNhatResult bv = temp[i]; BAIVIET var1 = new BAIVIET(); var1.MaBaiViet = bv.MaBaiViet; var1.TieuDe = bv.TieuDe; var1.NoiDung = bv.NoiDung; var1.MaLoaiBaiViet = bv.MaLoaiBaiViet; var1.NgayDang = bv.NgayDang; var1.HinhAnh = bv.HinhAnh; var1.TomTat = bv.TomTat; if (bv.CapNhat != null) var1.CapNhat = (DateTime)bv.CapNhat; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } if (list.Count > 0) return list; else return null; }