private bool CheckAndUpdateSajdas(PetaPoco.Database DBContext, IVerseRepository verseRepo) { if (DBContext != null && sajdas.Count > 0) { Debug.WriteLine(string.Format("Inserting sajda data: {0}", sajdas.Count)); foreach (int sajda in sajdas) { Verse vFound = verseRepo.Get(verse => verse.Chapter == this.ID && verse.Ayah == sajda); if (vFound != null) { if (DBContext.Execute("insert into Sajda(AyahId) values (@0)", vFound.Id) <= 0) { Debug.WriteLine("###### Error: chapter sajda data insertion failed ######"); return false; } } else { Debug.WriteLine("###### Error: chapter sajda data insertion failed. Couldn't find the related verse data from DB. ######"); return false; } } } return true; }
private bool CheckAndUpdateRukus(PetaPoco.Database DBContext, IVerseRepository verseRepo) { if (DBContext != null && rukus.Count > 0) { Debug.WriteLine(string.Format("Inserting ruku data: {0}", rukus.Count)); foreach (int ruku in rukus) { Verse vFound = verseRepo.Get(verse => verse.Chapter == this.ID && verse.Ayah == ruku); if (vFound != null) { if (DBContext.Execute("insert into Ruku(ScriptId, AyahId) values (@0, @1)", vFound.ScriptId, vFound.Id) <= 0) { Debug.WriteLine("###### Error: chapter ruku data insertion failed ######"); return false; } } else { Debug.WriteLine("###### Error: chapter ruku data insertion failed. Couldn't find the related verse data from DB. ######"); return false; } } } return true; }