public void InsertRecentActivity(Core.Entities.RecentActivity recentActivity)
{
var insertSQL = @"INSERT INTO dbo.[RecentActivity](
RecentActivityGuid,
Entity,
EntityGuid,
UserGuid,
UserAction,
CreatedBy,
CreatedOn,
UpdatedBy,
UpdatedOn,
IsDeleted)
VALUES(
@RecentActivityGuid,
@Entity,
@EntityGuid,
@UserGuid,
@UserAction,
@CreatedBy,
@CreatedOn,
@UpdatedBy,
@UpdatedOn,
@IsDeleted)";
_context.Connection.Execute(insertSQL, recentActivity);
}
public void UpdateRecentActivity(Core.Entities.RecentActivity recentActivity)
{
var updateQuery = @"UPDATE [dbo].[RecentActivity]
SET UserAction = @UserAction,
UpdatedBy = @UpdatedBy,
UpdatedOn = @UpdatedOn,
IsDeleted = @IsDeleted
WHERE RecentActivityGuid = @RecentActivityGuid
";
_context.Connection.Execute(updateQuery, recentActivity);
}
public void InsertRecentActivity(Core.Entities.RecentActivity recentActivity)
{
recentActivity.RecentActivityGuid = Guid.NewGuid();
var activity = _recentActivityRepo.CheckIfExistInActivity(recentActivity.Entity, recentActivity.EntityGuid, recentActivity.UserGuid, recentActivity.UserAction);
if (activity != null)
{
activity.UpdatedOn = DateTime.Now;
activity.UpdatedBy = recentActivity.UpdatedBy;
activity.IsDeleted = false;
_recentActivityRepo.UpdateRecentActivity(activity);
}
else
{
_recentActivityRepo.InsertRecentActivity(recentActivity);
}
}
public void UpdateRecentActivity(Core.Entities.RecentActivity recentActivity)
{
_recentActivityRepo.UpdateRecentActivity(recentActivity);
}
