/// <summary> /// Update the queueItem status. /// </summary> /// <param name="queueItem"></param> public static void UpdateQueueItemStatus(QueueItem queueItem) { ConnectionHelper.Connect(AutoCreateOption.None); Session session = new Session(XpoDefault.DataLayer); { Queue r = new XPQuery <Queue>(session).SingleOrDefault(q => q.Id.CompareTo(queueItem.IdQueue) == 0); r.Status = (int)queueItem.Etat; r.Save(); session.DataLayer.Dispose(); } }
public static void UpdateWithPriority(GTPInterface gTPInterface, GTPPriority gTPPriority) { ConnectionHelper.Connect(AutoCreateOption.None); Session session = new Session(XpoDefault.DataLayer); { Priority p = new XPQuery <Priority>(session).SingleOrDefault(q => q.Id.CompareTo(gTPPriority.Id) == 0); Interface r = new XPQuery <Interface>(session).SingleOrDefault(q => q.Id.CompareTo(gTPInterface.Id) == 0); r.Priority = p; r.Save(); session.DataLayer.Dispose(); } }
/// <summary> /// Update object out. /// </summary> /// <param name="queueItem"></param> public static void UpdateQueueItemObjectOutAndStatus(QueueItem queueItem) { queueItem.Message = "Ok from UpdateQueueItemObjectOutAndStatus"; ConnectionHelper.Connect(AutoCreateOption.None); Session session = new Session(XpoDefault.DataLayer); { Queue r = new XPQuery <Queue>(session).SingleOrDefault(q => q.Id.CompareTo(queueItem.IdQueue) == 0); r.ObjectOut = queueItem.FichierObjetOut; r.Status = (int)queueItem.Etat; r.Save(); session.DataLayer.Dispose(); } }
/// <summary> /// Update object out. /// </summary> /// <param name="queueItem"></param> /// Called from Loader public static void UpdateQueueItemStatusAndPriority(GTPQueue gTPQueue) { //queueItem.Message = "Ok from UpdateQueueItemObjectOutAndStatus"; ConnectionHelper.Connect(AutoCreateOption.None); Session session = new Session(XpoDefault.DataLayer); { Queue r = new XPQuery <Queue>(session).SingleOrDefault(q => q.Id.CompareTo(gTPQueue.Id) == 0); r.Status = gTPQueue.Status; r.Priority = gTPQueue.PriorityValue; r.Save(); session.DataLayer.Dispose(); } }
public void Save() { this.Text = $"Translation editor :: {Object.Name}"; Object.Save(); var uow = Object.Session as UnitOfWork; uow.CommitChanges(); foreach (var item in TreeItems.Where(x => x.Type == IbeTreeItemType.Book)) { var bookItem = item as IbeBookTreeItem; if (item.IsNew) { var book = new Book(uow) { AuthorName = bookItem.AuthorName, BaseBook = new XPQuery <BookBase>(uow).Where(x => x.Oid == bookItem.BaseBook.Id).FirstOrDefault(), BookName = bookItem.BookName, BookShortcut = bookItem.BookShortcut, Color = bookItem.Color, IsTranslated = bookItem.IsTranslated, NumberOfBook = bookItem.Number, ParentTranslation = Object, PlaceWhereBookWasWritten = bookItem.PlaceWhereBookWasWritten, Preface = bookItem.Preface, Purpose = bookItem.Purpose, Subject = bookItem.Subject, TimeOfWriting = bookItem.TimeOfWriting, NumberOfChapters = bookItem.NumberOfChapters }; book.Save(); uow.CommitChanges(); uow.ReloadChangedObjects(); bookItem.IsNew = false; bookItem.Changed = false; bookItem.Tag = book.Oid; // bookItem.ID = $"Book_{book.Oid}"; } else if (item.Changed) { var book = new XPQuery <Book>(uow).Where(x => x.Oid == bookItem.Tag).FirstOrDefault(); book.AuthorName = bookItem.AuthorName; book.BaseBook = new XPQuery <BookBase>(uow).Where(x => x.Oid == bookItem.BaseBook.Id).FirstOrDefault(); book.BookName = bookItem.BookName; book.BookShortcut = bookItem.BookShortcut; book.Color = bookItem.Color; book.IsTranslated = bookItem.IsTranslated; book.NumberOfBook = bookItem.Number; book.PlaceWhereBookWasWritten = bookItem.PlaceWhereBookWasWritten; book.Preface = bookItem.Preface; book.Purpose = bookItem.Purpose; book.Subject = bookItem.Subject; book.TimeOfWriting = bookItem.TimeOfWriting; book.NumberOfChapters = bookItem.NumberOfChapters; book.Save(); uow.CommitChanges(); bookItem.Changed = false; } } foreach (var item in TreeItems.Where(x => x.Type == IbeTreeItemType.Chapter)) { var chapterItem = item as IbeChapterTreeItem; if (item.IsNew) { var parentBookItem = TreeItems.Where(x => x.ID == chapterItem.ParentID).FirstOrDefault() as IbeBookTreeItem; var chapter = new Chapter(uow) { IsTranslated = chapterItem.IsTranslated, NumberOfChapter = chapterItem.Number, NumberOfVerses = chapterItem.NumberOfVerses, ParentBook = new XPQuery <Book>(uow).Where(x => x.Oid == parentBookItem.Tag).FirstOrDefault() }; chapter.Save(); uow.CommitChanges(); uow.ReloadChangedObjects(); chapterItem.IsNew = false; chapterItem.Changed = false; chapterItem.Tag = chapter.Oid; // chapterItem.ID = $"Chapter_{chapter.Oid}"; } else if (item.Changed) { var chapter = new XPQuery <Chapter>(uow).Where(x => x.Oid == chapterItem.Tag).FirstOrDefault(); chapter.IsTranslated = chapterItem.IsTranslated; chapter.NumberOfChapter = chapterItem.Number; chapter.NumberOfVerses = chapterItem.NumberOfVerses; chapter.Save(); uow.CommitChanges(); chapterItem.Changed = false; } } foreach (var item in TreeItems.Where(x => x.Type == IbeTreeItemType.Verse)) { var verseItem = item as IbeVerseTreeItem; if (item.IsNew) { var parentChapterItem = TreeItems.Where(x => x.ID == verseItem.ParentID).FirstOrDefault() as IbeChapterTreeItem; var verse = new Verse(uow) { NumberOfVerse = verseItem.Number, StartFromNewLine = verseItem.StartFromNewLine, Text = verseItem.Value, ParentChapter = new XPQuery <Chapter>(uow).Where(x => x.Oid == parentChapterItem.Tag).FirstOrDefault() }; SetSubtitle(verse, verseItem, uow, 1); SetSubtitle(verse, verseItem, uow, 2); //if (verseItem.SubtitleLevel1.IsNotNullOrEmpty()) { // var subtitle1 = verse.ParentChapter.Subtitles.Where(x => x.BeforeVerseNumber == verse.NumberOfVerse && x.Level == 1).FirstOrDefault(); // if (subtitle1.IsNotNull()) { // subtitle1.BeforeVerseNumber = verse.NumberOfVerse; // subtitle1.ParentChapter = verse.ParentChapter; // subtitle1.Level = 1; // subtitle1.Text = verseItem.SubtitleLevel1; // } // else { // subtitle1 = new Subtitle(uow) { // BeforeVerseNumber = verse.NumberOfVerse, // ParentChapter = verse.ParentChapter, // Level = 1, // Text = verseItem.SubtitleLevel1 // }; // } // subtitle1.Save(); //} //if (verseItem.SubtitleLevel2.IsNotNullOrEmpty()) { // var subtitle2 = verse.ParentChapter.Subtitles.Where(x => x.BeforeVerseNumber == verse.NumberOfVerse && x.Level == 2).FirstOrDefault(); // if (subtitle2.IsNotNull()) { // subtitle2.BeforeVerseNumber = verse.NumberOfVerse; // subtitle2.ParentChapter = verse.ParentChapter; // subtitle2.Level = 1; // subtitle2.Text = verseItem.SubtitleLevel2; // } // else { // subtitle2 = new Subtitle(uow) { // BeforeVerseNumber = verse.NumberOfVerse, // ParentChapter = verse.ParentChapter, // Level = 2, // Text = verseItem.SubtitleLevel2 // }; // } // subtitle2.Save(); //} verse.Save(); uow.CommitChanges(); uow.ReloadChangedObjects(); verseItem.IsNew = false; verseItem.Changed = false; verseItem.Tag = verse.Oid; } else if (item.Changed) { var verse = new XPQuery <Verse>(uow).Where(x => x.Oid == verseItem.Tag).FirstOrDefault(); verse.StartFromNewLine = verseItem.StartFromNewLine; verse.NumberOfVerse = verseItem.Number; verse.Text = verseItem.Value; SetSubtitle(verse, verseItem, uow, 1); SetSubtitle(verse, verseItem, uow, 2); verse.Save(); uow.CommitChanges(); verseItem.Changed = false; } } // refresh translations window try { if (ObjectSaved.IsNotNull()) { ObjectSaved(Object, EventArgs.Empty); } } catch { } }