CREATE TABLE [Journal](
	[JournalID] [int] NOT NULL,
	[ActionID] [int] NOT NULL,
	[ClientID] [int] NOT NULL,
	[JDateTime] [datetime] NOT NULL,
	[IPAddress] [nvarchar](20) NOT NULL,
	[Description] [xml] NULL)

            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required))
                    {
                        var newData = from a in _dataManager.Journals
                                      where a.JDateTime < DateTime.Now.AddDays(-1 * 5)
                                      select a;
                        foreach (var y in newData)
                        {
                            ArchiveJournal aj = new ArchiveJournal();
                            aj.JournalID = y.JournalID;
                            aj.ActionID = y.ActionID;
                            aj.ClientID = y.ClientID;
                            aj.JDateTime = y.JDateTime;
                            aj.IPAddress = y.IPAddress;
                            aj.Description = y.Description;

                            _dataManagerArchive.ArchiveJournals.InsertOnSubmit(aj);
                        }
                        _dataManagerArchive.SubmitChanges();
                        scope1.Complete();
                    }
                    _dataManager.Journals.DeleteAllOnSubmit(_dataManager.Journals.Where(w => w.JDateTime < DateTime.Now.AddDays(-1 * 5)));

                    Archive arh = new Archive();
                    arh.ArchiveDate = DateTime.Now;
                    arh.UserID = userID;
                    arh.Description = Resources.Strings.Archive_Success;
                    _dataManager.Archives.InsertOnSubmit(arh);
                    _dataManager.SubmitChanges(ConflictMode.ContinueOnConflict);

                    scope.Complete();
                }
            }
            catch (Exception cce)
            {
                string err = string.Format("exception: {0} stacktrace: {1}", cce.Message, cce.StackTrace);
                Logger.Instance.WriteLine(err);
            }