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;
}
}
