public DailyReflectionReflection GetUserReflection(int userId, int reflectionId) { var reflectionReflectionTransformer = new ReflectionReflectionTransformer(); var reflection = new DailyReflectionReflection(); using (var sp = new StoredProcedure("spGetUserDailyReflectionReflection")) { sp.SqlCommand.Parameters.AddWithValue("@userID", userId); sp.SqlCommand.Parameters.AddWithValue("@reflectionID", reflectionId); var dr = sp.SqlCommand.ExecuteReader(); while (dr.Read()) { reflection = reflectionReflectionTransformer.Transform(dr); reflection.ReflectionDate = Convert.ToDateTime(dr["DateOfReflection"]); } } return(reflection); }
public DailyReflectionReflection GetUserReflection(int userId, int reflectionId) { var reflectionReflectionTransformer = new ReflectionReflectionTransformer(); var reflection = new DailyReflectionReflection(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetUserDailyReflectionReflection", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", userId); cmd.Parameters.AddWithValue("@reflectionID", reflectionId); var dr = cmd.ExecuteReader(); while (dr.Read()) { reflection = reflectionReflectionTransformer.Transform(dr); reflection.ReflectionDate = Convert.ToDateTime(dr["DateOfReflection"]); } } catch (Exception) { // ignored } } } return(reflection); }
public DailyReflectionReflectionService() { _reflectionReflectionTransformer = new ReflectionReflectionTransformer(); _dailyReflectionTransformer = new DailyReflectionTransformer(); _userTransformer = new UserTransformer(); }