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