private void FillActivityLog(Guid MemberId, string ActivityValue) { string sql = " SELECT [Key] AS ContentId, Value AS ActivityValue, ActivityType, DateModified " + " FROM MemberActivity " + " WHERE (MemberId = @MemberId) AND " + " (Value = @ActivityValue) AND " + " (Deleted=0) "; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@MemberId", MemberId); cmd.Parameters.AddWithValue("@ActivityValue", ActivityValue); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { //fill activity log with activity items ActivityItem item = new ActivityItem(); item.ContentId = reader.GetGuid(0); //ContentId; if (!reader.IsDBNull(1)) //(1)=ActivityValue { item.ActivityValue = reader.GetString(1); //ActivityValue } else { item.ActivityValue = string.Empty; } item.ActivityType = reader.GetInt32(2); //ActivityType item.DateModified = reader.GetDateTime(3); //DateModified this.Activities.Add(item); } } } } } catch (Exception ex) { throw ex; } }
private void FillActivityLog (Guid MemberId, string ActivityValue) { string sql = " SELECT [Key] AS ContentId, Value AS ActivityValue, ActivityType, DateModified " + " FROM MemberActivity " + " WHERE (MemberId = @MemberId) AND " + " (Value = @ActivityValue) AND " + " (Deleted=0) "; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@MemberId", MemberId); cmd.Parameters.AddWithValue("@ActivityValue", ActivityValue); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { //fill activity log with activity items ActivityItem item = new ActivityItem(); item.ContentId = reader.GetGuid(0);//ContentId; if (!reader.IsDBNull(1))//(1)=ActivityValue { item.ActivityValue = reader.GetString(1);//ActivityValue } else { item.ActivityValue = string.Empty; } item.ActivityType = reader.GetInt32(2);//ActivityType item.DateModified = reader.GetDateTime(3);//DateModified this.Activities.Add(item); } } } } } catch (Exception ex) { throw ex; } }