private void GetTranslationVerse(int siteId, int quranId, int verseid) { using (IDataReader reader = DBiQuran.iVerse_GetTranslationVerseDetails(siteId, quranId, 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(); } else { if (log.IsErrorEnabled) { log.Error("IDataReader didn't read in Quran.GetVerse"); } } } }