示例#1
0
        private void GetOthmaniVerse(int siteId, int verseid)
        {
            using (IDataReader reader = DBiQuran.iVerse_GetOthmaniVerseDetails(siteId, verseid))
            {
                if (reader.Read())
                {
                    this.verseID = int.Parse(reader["VerseID"].ToString());
                    this.suraID  = int.Parse(reader["SuraID"].ToString());
                    this.quranID = int.Parse(reader["QuranID"].ToString());
                    this.siteID  = int.Parse(reader["SiteID"].ToString());

                    this.verseOrder       = int.Parse(reader["VerseOrder"].ToString());
                    this.suraOrder        = int.Parse(reader["SuraOrder"].ToString());
                    this.sortOrderInQuran = int.Parse(reader["SortOrderInQuran"].ToString());

                    this.halfNo    = int.Parse(reader["HalfNo"].ToString());
                    this.partNo    = int.Parse(reader["PartNo"].ToString());
                    this.hizbNo    = int.Parse(reader["HizbNo"].ToString());
                    this.quraterNo = int.Parse(reader["QuraterNo"].ToString());

                    this.place       = reader["Place"].ToString().Trim();
                    this.startTime   = float.Parse(reader["StartTime"].ToString());
                    this.endTime     = float.Parse(reader["EndTime"].ToString());
                    this.endTimeText = reader["EndTimeText"].ToString().Trim();

                    string active = reader["IsActive"].ToString();
                    this.isActive          = (active == "True" || active == "1");
                    this.createdDate       = Convert.ToDateTime(reader["CreatedDate"]);
                    this.createdByUserName = reader["UserName"].ToString().Trim();
                    this.createdByUserID   = int.Parse(reader["CreatedBy"].ToString());
                    this.qLanguage         = reader["QLanguage"].ToString().Trim();

                    this.verseText = reader["VerseText"].ToString();
                    this.quranVerseTxt.VerseText       = reader["VerseText"].ToString();
                    this.quranVerseTxt.VerseTextNM     = reader["VerseTextNM"].ToString();
                    this.quranVerseTxt.VerseTextNMAlif = reader["VerseTextNMAlif"].ToString();
                }
                else
                {
                    if (log.IsErrorEnabled)
                    {
                        log.Error("IDataReader didn't read in Quran.GetVerse");
                    }
                }
            }
        }