Ejemplo n.º 1
0
        private static List <QuranSura> LoadListFromReader(IDataReader reader, bool iSThereSubInstancesInside)
        {
            List <QuranSura> iSList = new List <QuranSura>();

            try
            {
                while (reader.Read())
                {
                    QuranSura iSur = new QuranSura();

                    iSur.SuraID           = int.Parse(reader["SuraID"].ToString());
                    iSur.SiteID           = int.Parse(reader["SiteID"].ToString());
                    iSur.QuranID          = int.Parse(reader["QuranID"].ToString());
                    iSur.Title            = reader["Title"].ToString().Trim();
                    iSur.Place            = reader["Place"].ToString().Trim();
                    iSur.SoraOrderReverse = 115 - int.Parse(reader["SuraOrder"].ToString());
                    iSur.VersesCount      = int.Parse(reader["VersesCount"].ToString());
                    iSur.SuraOrder        = int.Parse(reader["SuraOrder"].ToString());
                    iSur.pageNumber       = int.Parse(reader["PageNumber"].ToString());
                    string active = reader["IsActive"].ToString();
                    iSur.IsActive          = (active == "True" || active == "1");
                    iSur.CreatedDate       = Convert.ToDateTime(reader["CreatedDate"]);
                    iSur.CreatedByUserName = reader["UserName"].ToString().Trim();
                    iSur.CreatedByUserId   = int.Parse(reader["CreatedBy"].ToString());

                    //Get Sub Data ?
                    if (iSThereSubInstancesInside == true)
                    {
                        using (IDataReader reader1 = DBiQuran.iVerse_GetVerses_Dr(iSur.siteID, iSur.suraID))
                        {
                            while (reader1.Read())
                            {
                                QuranVerse iQuranVerse = new QuranVerse();



                                iSur.iQuranVerses.VerseID = int.Parse(reader1["VerseID"].ToString());
                                iSur.iQuranVerses.SuraID  = int.Parse(reader1["SuraID"].ToString());
                                iSur.iQuranVerses.QuranID = int.Parse(reader1["QuranID"].ToString());
                                iSur.iQuranVerses.SiteID  = int.Parse(reader1["SiteID"].ToString());

                                iSur.iQuranVerses.VerseOrder       = int.Parse(reader1["VerseOrder"].ToString());
                                iSur.iQuranVerses.SortOrderInQuran = int.Parse(reader1["SortOrderInQuran"].ToString());

                                iSur.iQuranVerses.HalfNo    = int.Parse(reader1["HalfNo"].ToString());
                                iSur.iQuranVerses.PartNo    = int.Parse(reader1["PartNo"].ToString());
                                iSur.iQuranVerses.QuraterNo = int.Parse(reader1["QuraterNo"].ToString());

                                iSur.iQuranVerses.StartTime   = float.Parse(reader1["StartTime"].ToString());
                                iSur.iQuranVerses.EndTime     = float.Parse(reader1["EndTime"].ToString());
                                iSur.iQuranVerses.EndTimeText = reader1["EndTimeText"].ToString().Trim();

                                string active1 = reader1["IsActive"].ToString();
                                iSur.iQuranVerses.IsActive          = (active1 == "True" || active1 == "1");
                                iSur.iQuranVerses.CreatedDate       = Convert.ToDateTime(reader1["CreatedDate"]);
                                iSur.iQuranVerses.CreatedByUserName = reader1["UserName"].ToString().Trim();
                                iSur.iQuranVerses.CreatedByUserId   = int.Parse(reader1["CreatedBy"].ToString());
                                iSur.iQuranVerses.QLanguage         = reader1["QLanguage"].ToString().Trim();

                                if (iSur.iQuranVerses.QLanguage == "ar")
                                {
                                    using (IDataReader reader2 = DBiQuran.iVerse_GetVerse_Text(iSur.iQuranVerses.SiteID, iSur.iQuranVerses.QuranID, iSur.iQuranVerses.SuraID, iSur.iQuranVerses.VerseID))
                                    {
                                        if (reader2.Read())
                                        {
                                            iSur.iQuranVerses.VerseText = reader2["VerseText"].ToString();
                                            iSur.iQuranVerses.QuranVerseTxt.VerseTextNM     = reader2["VerseTextNM"].ToString();
                                            iSur.iQuranVerses.QuranVerseTxt.VerseTextNMAlif = reader2["VerseTextNMAlif"].ToString();
                                        }
                                        else
                                        {
                                            if (log.IsErrorEnabled)
                                            {
                                                log.Error("IDataReader didn't read in Quran.GetiQuran");
                                            }
                                        }
                                    }
                                }
                                else
                                {
                                    iSur.iQuranVerses.VerseText = DBiQuran.iVerse_GetVerse_Translation(iSur.iQuranVerses.SiteID, iSur.iQuranVerses.QuranID, iSur.iQuranVerses.SuraID, iSur.iQuranVerses.VerseID);
                                }
                            }
                        }
                    }
                    iSList.Add(iSur);
                }
            }
            finally
            {
                reader.Close();
            }

            return(iSList);
        }
Ejemplo n.º 2
0
        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);
        }