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);
}
