/* 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;
        }