public int Save(ActivityDto activity) { using (var con = new SqlConnection(ConnectionString)) { con.Open(); var q = con.Query<int>( @"INSERT INTO Activity(ObjectID,ObjectType,ActivityDesc,ObjectTitle,OldState,NewState,TeamId,CreatedDate,CreatedByID) VALUES(@objectId,@objectType,@desc,@title,@oldState,@newState,@teamId,@createdDate,@userId);SELECT CAST(SCOPE_IDENTITY() as int)", new { @objectId = activity.ObjectId, @objectType = activity.ObjectType, @title = activity.ObjectTitle, @oldState = activity.OldState, @newState = activity.NewState, @desc = activity.Description, @teamId = activity.TeamId, @createdDate = DateTime.Now, @userId = activity.Actor.Id }); return q.First(); } }
public ActivityDto SaveActivity(CreateIssue model, IssueDetailVM previousVersion, IssueDetailVM newVersion) { bool isStateChanged = false; var activity = new ActivityDto() { ObjectId = newVersion.Id, ObjectType = "Issue" }; if (previousVersion == null) { activity.ObjectUrl = "issue/" + newVersion.Id; //activity.CreatedBy = activity.Description = "Created"; activity.ObjectTite = model.Title; isStateChanged = true; } else { if (previousVersion.Status.Id != newVersion.Status.Id) { // status of issue updated activity.Description = "Changed status"; activity.NewState = newVersion.Status.Name; activity.OldState = previousVersion.Status.Name; activity.ObjectTite = newVersion.Title; isStateChanged = true; } else if (previousVersion.Category.Id != newVersion.Category.Id) { activity.Description = "Changed category"; activity.NewState = newVersion.Category.Name; activity.OldState = previousVersion.Category.Name; activity.ObjectTite = newVersion.Title; isStateChanged = true; } } activity.TeamId = userSessionHelper.TeamId; activity.Actor = new UserDto { Id = userSessionHelper.UserId }; if (isStateChanged) { var newId = activityRepository.Save(activity); return activityRepository.GetActivityItem(newId); } return null; }
public ActivityDto SaveActivity(int commentId, int issueId) { var issue = issueRepository.GetIssue(issueId); if (issue != null) { var activity = new ActivityDto() {ObjectId = commentId, ObjectType = "Comment"}; activity.Description = "Commented"; //activity.NewState = newVersion.Status.Name; // activity.OldState = previousVersion.Status.Name; activity.ObjectTite = issue.Title; activity.TeamId = userSessionHelper.TeamId; activity.Actor = new UserDto {Id = userSessionHelper.UserId}; var newId = activityRepository.Save(activity); return activityRepository.GetActivityItem(newId); } return null; }
public int Save(ActivityDto activity) { using (var db = new TeamEntitiesConn()) { var a = new Activity { OldState = activity.OldState, NewState = activity.NewState, ObjectID = activity.ObjectId, ObjectType = activity.ObjectType, ActivityDesc = activity.Description, ObjectTitle = activity.ObjectTite, CreatedByID = activity.Actor.Id, TeamID = activity.TeamId, CreatedDate = DateTime.Now }; db.Activities.Add(a); db.SaveChanges(); return a.ID; } }