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