public OtherCatholicPrayer Find(int id) { var otherCatholicPrayer = new OtherCatholicPrayer(); using (var sp = new StoredProcedure("spFindOtherCatholicPrayer")) { sp.SqlCommand.Parameters.AddWithValue("@othercatholicprayerID", id); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { otherCatholicPrayer = _otherCatholicPrayerTransformer.Transform(reader); } } return(otherCatholicPrayer); }
public Models.OtherCatholicPrayer Find(int id) { var otherCatholicPrayer = new Models.OtherCatholicPrayer(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spFindOtherCatholicPrayer", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@othercatholicprayerID", id); var reader = cmd.ExecuteReader(); while (reader.Read()) { otherCatholicPrayer = _otherCatholicPrayerTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(otherCatholicPrayer); }
public List <OtherCatholicPrayer> GetFavoriteOtherCatholicPrayer(int userId) { var otherCatholicPrayers = new List <OtherCatholicPrayer>(); var otherCatholicPrayerTransformer = new OtherCatholicPrayerTransformer(); using (var sp = new StoredProcedure("spGetFavoriteOtherCatholicPrayer")) { sp.SqlCommand.Parameters.AddWithValue("@userID", userId); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { otherCatholicPrayers.Add(otherCatholicPrayerTransformer.Transform(reader)); } } return(otherCatholicPrayers); }