/// <summary> /// </summary> /// <param name="relationId">Mood</param> /// <param name="relationId2">User Id</param> /// <param name="relationId3"></param> /// <param name="relationId4"></param> /// <returns></returns> public List <ReligiousQuote> Get(int relationId = 0, int relationId2 = 0, int relationId3 = 0, int relationId4 = 0) { var mood = new Mood(); var religiousQuotes = new List <ReligiousQuote>(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetReligiousQuote", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@moods", mood.GetValue(relationId)); cmd.Parameters.AddWithValue("@userID", relationId2); var reader = cmd.ExecuteReader(); while (reader.Read()) { var religiousQuote = _religiousQuoteTransformer.Transform(reader); religiousQuote.IsFavorite = Convert.ToBoolean(reader["isFavorite"]); religiousQuotes.Add(religiousQuote); } } catch (Exception) { // ignored } finally { dbconn.Close(); dbconn.Dispose(); } } } return(religiousQuotes); }
/// <summary> /// </summary> /// <param name="relationId">Mood</param> /// <param name="relationId2">User Id</param> /// <param name="relationId3"></param> /// <param name="relationId4"></param> /// <returns></returns> public List <BibleVerse> Get(int relationId = 0, int relationId2 = 0, int relationId3 = 0, int relationId4 = 0) { var bibleVerses = new List <BibleVerse>(); var mood = new Mood(); using (var sp = new StoredProcedure("spGetBibleVerse")) { sp.SqlCommand.Parameters.AddWithValue("@moods", mood.GetValue(relationId)); sp.SqlCommand.Parameters.AddWithValue("@userID", relationId2); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { var verse = _bibleVerseTransformer.Transform(reader); verse.IsFavorite = Convert.ToBoolean(reader["isFavorite"]); bibleVerses.Add(verse); } } return(bibleVerses); }