public List <BasicCatholicPrayer> GetFavoriteBasicCatholicPrayer(int userId) { var basicCatholicPrayer = new List <BasicCatholicPrayer>(); var basicCatholicPrayerTransformer = new BasicCatholicPrayerTransformer(); using (var sp = new StoredProcedure("spGetFavoriteBasicCatholicPrayer")) { sp.SqlCommand.Parameters.AddWithValue("@userID", userId); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { basicCatholicPrayer.Add(basicCatholicPrayerTransformer.Transform(reader)); } } return(basicCatholicPrayer); }
public List <Models.BasicCatholicPrayer> GetFavoriteBasicCatholicPrayer(int userId) { var basicCatholicPrayer = new List <Models.BasicCatholicPrayer>(); var basicCatholicPrayerTransformer = new BasicCatholicPrayerTransformer(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetFavoriteBasicCatholicPrayer", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", userId); var reader = cmd.ExecuteReader(); while (reader.Read()) { basicCatholicPrayer.Add(basicCatholicPrayerTransformer.Transform(reader)); } } catch (Exception) { // ignored } } } return(basicCatholicPrayer); }
public BasicCatholicPrayerService() { _basicCatholicPrayerTransformer = new BasicCatholicPrayerTransformer(); }