/* public DANGKYHOATDONG TimKiem(int manguoidung, int mahoatdong) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); var query = from ng in db.DANGKYHOATDONGs where (ng.MaNguoiDung == manguoidung && ng.MaHoatDong == mahoatdong) select ng; if (query.Count() > 0) return query.First(); else return null; } catch (Exception ex) { throw (ex); } }*/ public List<DANGKYHOATDONG_get_MaHoatDongResult> SelectDANGKYHOATDONGs_HoatDong(int mahoatdong) { List<DANGKYHOATDONG_get_MaHoatDongResult> list = new List<DANGKYHOATDONG_get_MaHoatDongResult>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<DANGKYHOATDONG_get_MaHoatDongResult> lp = db.DANGKYHOATDONG_get_MaHoatDong(mahoatdong); foreach (DANGKYHOATDONG_get_MaHoatDongResult DANGKYHOATDONG in lp) { DANGKYHOATDONG_get_MaHoatDongResult var1 = new DANGKYHOATDONG_get_MaHoatDongResult(); var1.TenHoatDong = DANGKYHOATDONG.TenHoatDong; var1.Username = DANGKYHOATDONG.Username; var1.HoTen = DANGKYHOATDONG.HoTen; var1.MaNguoiDung = DANGKYHOATDONG.MaNguoiDung; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }