public void Save(CrossRef_Subtitles_AniDB_File obj) { using (var session = JMMService.SessionFactory.OpenSession()) { // populate the database using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(obj); transaction.Commit(); } } }
public void CreateLanguages() { char apostrophe = ("'").ToCharArray()[0]; LanguageRepository repLanguages = new LanguageRepository(); if (languagesRAW != null) //Only create relations if the origin of the data if from Raw (WebService/AniDB) { if (languagesRAW.Trim().Length == 0) return; // Delete old if changed CrossRef_Languages_AniDB_FileRepository repFileLanguages = new CrossRef_Languages_AniDB_FileRepository(); List<CrossRef_Languages_AniDB_File> fileLanguages = repFileLanguages.GetByFileID(this.FileID); foreach (CrossRef_Languages_AniDB_File fLan in fileLanguages) { repFileLanguages.Delete(fLan.CrossRef_Languages_AniDB_FileID); } string[] langs = languagesRAW.Split(apostrophe); foreach (string language in langs) { string rlan = language.Trim().ToLower(); if (rlan.Length > 0) { Language lan = repLanguages.GetByLanguageName(rlan); if (lan == null) { lan = new Language(); lan.LanguageName = rlan; repLanguages.Save(lan); } CrossRef_Languages_AniDB_File cross = new CrossRef_Languages_AniDB_File(); cross.LanguageID = lan.LanguageID; cross.FileID = FileID; repFileLanguages.Save(cross); } } } if (subtitlesRAW != null) { if (subtitlesRAW.Trim().Length == 0) return; // Delete old if changed CrossRef_Subtitles_AniDB_FileRepository repFileSubtitles = new CrossRef_Subtitles_AniDB_FileRepository(); List<CrossRef_Subtitles_AniDB_File> fileSubtitles = repFileSubtitles.GetByFileID(this.FileID); foreach (CrossRef_Subtitles_AniDB_File fSub in fileSubtitles) { repFileSubtitles.Delete(fSub.CrossRef_Subtitles_AniDB_FileID); } string[] subs = subtitlesRAW.Split(apostrophe); foreach (string language in subs) { string rlan = language.Trim().ToLower(); if (rlan.Length > 0) { Language lan = repLanguages.GetByLanguageName(rlan); if (lan == null) { lan = new Language(); lan.LanguageName = rlan; repLanguages.Save(lan); } CrossRef_Subtitles_AniDB_File cross = new CrossRef_Subtitles_AniDB_File(); cross.LanguageID = lan.LanguageID; cross.FileID = FileID; repFileSubtitles.Save(cross); } } } }
public void CreateLanguages() { char apostrophe = "'".ToCharArray()[0]; LanguageRepository repLanguages = new LanguageRepository(); if (languagesRAW != null) //Only create relations if the origin of the data if from Raw (WebService/AniDB) { if (languagesRAW.Trim().Length == 0) { return; } // Delete old if changed CrossRef_Languages_AniDB_FileRepository repFileLanguages = new CrossRef_Languages_AniDB_FileRepository(); List <CrossRef_Languages_AniDB_File> fileLanguages = repFileLanguages.GetByFileID(this.FileID); foreach (CrossRef_Languages_AniDB_File fLan in fileLanguages) { repFileLanguages.Delete(fLan.CrossRef_Languages_AniDB_FileID); } string[] langs = languagesRAW.Split(apostrophe); foreach (string language in langs) { string rlan = language.Trim().ToLower(); if (rlan.Length > 0) { Language lan = repLanguages.GetByLanguageName(rlan); if (lan == null) { lan = new Language(); lan.LanguageName = rlan; repLanguages.Save(lan); } CrossRef_Languages_AniDB_File cross = new CrossRef_Languages_AniDB_File(); cross.LanguageID = lan.LanguageID; cross.FileID = FileID; repFileLanguages.Save(cross); } } } if (subtitlesRAW != null) { if (subtitlesRAW.Trim().Length == 0) { return; } // Delete old if changed CrossRef_Subtitles_AniDB_FileRepository repFileSubtitles = new CrossRef_Subtitles_AniDB_FileRepository(); List <CrossRef_Subtitles_AniDB_File> fileSubtitles = repFileSubtitles.GetByFileID(this.FileID); foreach (CrossRef_Subtitles_AniDB_File fSub in fileSubtitles) { repFileSubtitles.Delete(fSub.CrossRef_Subtitles_AniDB_FileID); } string[] subs = subtitlesRAW.Split(apostrophe); foreach (string language in subs) { string rlan = language.Trim().ToLower(); if (rlan.Length > 0) { Language lan = repLanguages.GetByLanguageName(rlan); if (lan == null) { lan = new Language(); lan.LanguageName = rlan; repLanguages.Save(lan); } CrossRef_Subtitles_AniDB_File cross = new CrossRef_Subtitles_AniDB_File(); cross.LanguageID = lan.LanguageID; cross.FileID = FileID; repFileSubtitles.Save(cross); } } } }