public ActivityManager(DBConnectionManager dbConnectionManager) : base(dbConnectionManager) { }
public static void EnqueueActivity(Guid siteId, Guid webId, Guid listId, int userId, DateTime activityTime, DateTime relatedActivityTime, SPWeb contextWeb) { const string GET_QUEUED_ACTIVITY_SQL = @" SELECT TOP (1) ActivityQueueId, ItemCount FROM dbo.ActivityQueue WHERE (ListId = @ListId) AND (WebId = @WebId) AND (UserId = @UserId) AND (PostTime >= @RelatedActivityTime) ORDER BY PostTime DESC"; Guid queuedActivityId = Guid.Empty; int itemCount = 0; using (SqlConnection sqlConnection = new DBConnectionManager(contextWeb, false).EPMLiveSqlConnection) { using (var sqlCommand = new SqlCommand(GET_QUEUED_ACTIVITY_SQL, sqlConnection)) { sqlCommand.Parameters.AddWithValue("@WebId", webId); sqlCommand.Parameters.AddWithValue("@ListId", listId); sqlCommand.Parameters.AddWithValue("@UserId", userId); sqlCommand.Parameters.AddWithValue("@RelatedActivityTime", relatedActivityTime); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { queuedActivityId = reader.GetGuid(0); itemCount = reader.GetInt32(1); } reader.Close(); } } if (queuedActivityId == Guid.Empty) { const string INSERT_SQL = @"INSERT INTO dbo.ActivityQueue (SiteId, WebId, ListId, UserId, PostTime, ItemCount) VALUES (@SiteId, @WebId, @ListId, @UserId, @ActivityTime, 2)"; using (var sqlCommand = new SqlCommand(INSERT_SQL, sqlConnection)) { sqlCommand.Parameters.AddWithValue("@SiteId", siteId); sqlCommand.Parameters.AddWithValue("@WebId", webId); sqlCommand.Parameters.AddWithValue("@ListId", listId); sqlCommand.Parameters.AddWithValue("@UserId", userId); sqlCommand.Parameters.AddWithValue("@ActivityTime", activityTime); sqlCommand.ExecuteNonQuery(); } } else { const string UPDATE_SQL = @"UPDATE dbo.ActivityQueue SET ItemCount = @ItemCount, PostTime = @ActivityTime WHERE ActivityQueueId = @Id"; using (var sqlCommand = new SqlCommand(UPDATE_SQL, sqlConnection)) { sqlCommand.Parameters.AddWithValue("@ItemCount", ++itemCount); sqlCommand.Parameters.AddWithValue("@ActivityTime", activityTime); sqlCommand.Parameters.AddWithValue("@Id", queuedActivityId); sqlCommand.ExecuteNonQuery(); } } sqlConnection.Close(); } }
public ThreadManager(DBConnectionManager dbConnectionManager) : base(dbConnectionManager) { }
public StreamManager(DBConnectionManager dbConnectionManager) : base(dbConnectionManager) { }
protected BaseManager(DBConnectionManager dbConnectionManager) { _dbConnectionManager = dbConnectionManager; }
public TransactionManager(DBConnectionManager dbConnectionManager) : base(dbConnectionManager) { }