public List<Contract_AniDB_Character> GetCharactersForSeiyuu(int aniDB_SeiyuuID)
{
List<Contract_AniDB_Character> chars = new List<Contract_AniDB_Character>();
try
{
AniDB_SeiyuuRepository repSeiyuu = new AniDB_SeiyuuRepository();
AniDB_Seiyuu seiyuu = repSeiyuu.GetByID(aniDB_SeiyuuID);
if (seiyuu == null) return chars;
AniDB_Character_SeiyuuRepository repCharSei = new AniDB_Character_SeiyuuRepository();
List<AniDB_Character_Seiyuu> links = repCharSei.GetBySeiyuuID(seiyuu.SeiyuuID);
AniDB_Anime_CharacterRepository repAnimeChar = new AniDB_Anime_CharacterRepository();
AniDB_CharacterRepository repChar = new AniDB_CharacterRepository();
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
foreach (AniDB_Character_Seiyuu chrSei in links)
{
AniDB_Character chr = repChar.GetByCharID(chrSei.CharID);
if (chr != null)
{
List<AniDB_Anime_Character> aniChars = repAnimeChar.GetByCharID(chr.CharID);
if (aniChars.Count > 0)
{
AniDB_Anime anime = repAnime.GetByAnimeID(aniChars[0].AnimeID);
if (anime != null)
{
Contract_AniDB_Character contract = chr.ToContract(aniChars[0]);
contract.Anime = anime.ToContract(true, null);
chars.Add(contract);
}
}
}
}
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return chars;
}
public AniDB_Seiyuu GetSeiyuu(ISession session)
{
AniDB_Character_SeiyuuRepository repCharSeiyuu = new AniDB_Character_SeiyuuRepository();
List<AniDB_Character_Seiyuu> charSeiyuus = repCharSeiyuu.GetByCharID(session, CharID);
if (charSeiyuus.Count > 0)
{
// just use the first creator
AniDB_SeiyuuRepository repCreators = new AniDB_SeiyuuRepository();
return repCreators.GetBySeiyuuID(session, charSeiyuus[0].SeiyuuID);
}
return null;
}
private void CreateCharacters(ISession session, List<Raw_AniDB_Character> chars)
{
if (chars == null) return;
AniDB_CharacterRepository repChars = new AniDB_CharacterRepository();
AniDB_Anime_CharacterRepository repAnimeChars = new AniDB_Anime_CharacterRepository();
AniDB_Character_SeiyuuRepository repCharSeiyuu = new AniDB_Character_SeiyuuRepository();
AniDB_SeiyuuRepository repSeiyuu = new AniDB_SeiyuuRepository();
// delete all the existing cross references just in case one has been removed
List<AniDB_Anime_Character> animeChars = repAnimeChars.GetByAnimeID(session, AnimeID);
using (var transaction = session.BeginTransaction())
{
foreach (AniDB_Anime_Character xref in animeChars)
session.Delete(xref);
transaction.Commit();
}
List<AniDB_Character> chrsToSave = new List<AniDB_Character>();
List<AniDB_Anime_Character> xrefsToSave = new List<AniDB_Anime_Character>();
Dictionary<int, AniDB_Seiyuu> seiyuuToSave = new Dictionary<int, AniDB_Seiyuu>();
List<AniDB_Character_Seiyuu> seiyuuXrefToSave = new List<AniDB_Character_Seiyuu>();
// delete existing relationships to seiyuu's
List<AniDB_Character_Seiyuu> charSeiyuusToDelete = new List<AniDB_Character_Seiyuu>();
foreach (Raw_AniDB_Character rawchar in chars)
{
// delete existing relationships to seiyuu's
List<AniDB_Character_Seiyuu> allCharSei = repCharSeiyuu.GetByCharID(session, rawchar.CharID);
foreach (AniDB_Character_Seiyuu xref in allCharSei)
charSeiyuusToDelete.Add(xref);
}
using (var transaction = session.BeginTransaction())
{
foreach (AniDB_Character_Seiyuu xref in charSeiyuusToDelete)
session.Delete(xref);
transaction.Commit();
}
foreach (Raw_AniDB_Character rawchar in chars)
{
AniDB_Character chr = repChars.GetByCharID(session, rawchar.CharID);
if (chr == null)
chr = new AniDB_Character();
chr.PopulateFromHTTP(rawchar);
chrsToSave.Add(chr);
// create cross ref's between anime and character, but don't actually download anything
AniDB_Anime_Character anime_char = new AniDB_Anime_Character();
anime_char.Populate(rawchar);
xrefsToSave.Add(anime_char);
foreach (Raw_AniDB_Seiyuu rawSeiyuu in rawchar.Seiyuus)
{
// save the link between character and seiyuu
AniDB_Character_Seiyuu acc = repCharSeiyuu.GetByCharIDAndSeiyuuID(session, rawchar.CharID, rawSeiyuu.SeiyuuID);
if (acc == null)
{
acc = new AniDB_Character_Seiyuu();
acc.CharID = chr.CharID;
acc.SeiyuuID = rawSeiyuu.SeiyuuID;
seiyuuXrefToSave.Add(acc);
}
// save the seiyuu
AniDB_Seiyuu seiyuu = repSeiyuu.GetBySeiyuuID(session, rawSeiyuu.SeiyuuID);
if (seiyuu == null) seiyuu = new AniDB_Seiyuu();
seiyuu.PicName = rawSeiyuu.PicName;
seiyuu.SeiyuuID = rawSeiyuu.SeiyuuID;
seiyuu.SeiyuuName = rawSeiyuu.SeiyuuName;
seiyuuToSave[seiyuu.SeiyuuID] = seiyuu;
}
}
using (var transaction = session.BeginTransaction())
{
foreach (AniDB_Character chr in chrsToSave)
session.SaveOrUpdate(chr);
foreach (AniDB_Anime_Character xref in xrefsToSave)
session.SaveOrUpdate(xref);
foreach (AniDB_Seiyuu seiyuu in seiyuuToSave.Values)
session.SaveOrUpdate(seiyuu);
foreach (AniDB_Character_Seiyuu xrefSeiyuu in seiyuuXrefToSave)
session.SaveOrUpdate(xrefSeiyuu);
transaction.Commit();
}
}