Esempio n. 1
0
        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;
        }