public static IDataReader GetSuras(int siteId, int quranid) { return(DBiQuran.iSura_GetSuras_Dr(siteId, quranid)); }
private static List <Quran> LoadListFromReader(IDataReader reader, bool iSThereSubInstancesInside) { List <Quran> iQList = new List <Quran>(); try { while (reader.Read()) { Quran iQur = new Quran(); iQur.quranID = int.Parse(reader["QuranID"].ToString()); iQur.siteID = int.Parse(reader["SiteID"].ToString()); iQur.title = reader["Title"].ToString().Trim(); iQur.description = reader["Description"].ToString(); iQur.tRanslatorDetUrl = reader["TRanslatorDetUrl"].ToString(); iQur.translationSrc = reader["TranslationSrc"].ToString(); iQur.suraCount = int.Parse(reader["SuraCount"].ToString()); string isdefault = reader["IsDefault"].ToString(); iQur.isDefault = (isdefault == "True" || isdefault == "1"); iQur.qLanguage = reader["QLanguage"].ToString().Trim(); string active = reader["IsActive"].ToString(); iQur.isActive = (active == "True" || active == "1"); iQur.createdDate = Convert.ToDateTime(reader["CreatedDate"]); iQur.createdByUserName = reader["UserName"].ToString().Trim(); iQur.createdByUserID = int.Parse(reader["CreatedBy"].ToString()); //Get Sub Data ? if (iSThereSubInstancesInside == true) { using (IDataReader reader1 = DBiQuran.iSura_GetSuras_Dr(iQur.siteID, iQur.quranID)) { while (reader1.Read()) { QuranSura iQuranSura = new QuranSura(); iQur.iQuranSura.SuraID = int.Parse(reader1["SuraID"].ToString()); iQur.iQuranSura.SiteID = int.Parse(reader1["SiteID"].ToString()); iQur.iQuranSura.QuranID = int.Parse(reader1["QuranID"].ToString()); iQur.iQuranSura.Title = reader1["Title"].ToString().Trim(); iQur.iQuranSura.Place = reader1["Place"].ToString().Trim(); iQur.iQuranSura.SoraOrderReverse = int.Parse(reader1["SoraOrderReverse"].ToString()); iQur.iQuranSura.VersesCount = int.Parse(reader1["VersesCount"].ToString()); iQur.iQuranSura.SuraOrder = int.Parse(reader1["SuraOrder"].ToString()); string active1 = reader1["IsActive"].ToString(); iQur.iQuranSura.IsActive = (active1 == "True" || active1 == "1"); iQur.iQuranSura.CreatedDate = Convert.ToDateTime(reader1["CreatedDate"]); iQur.iQuranSura.CreatedByUserName = reader1["UserName"].ToString().Trim(); iQur.iQuranSura.CreatedByUserId = int.Parse(reader1["CreatedBy"].ToString()); } } } iQList.Add(iQur); } } finally { reader.Close(); } return(iQList); }