private StatusTypeDB CreateStatusType(int key, string name)
        {
            var statusType = new StatusTypeDB
            {
                Key  = key,
                Name = name
            };

            _context.StatusTypes.Add(statusType);
            _context.SaveChanges();
            return(statusType);
        }
        private TaskDB CreateTask(int id, ObjectiveDB objective, string title, string details, int priority, StatusTypeDB statusType, DateTime lastUpdateDate)
        {
            var task = new TaskDB
            {
                Id             = id,
                Details        = details,
                Objective      = objective,
                ObjectiveId    = objective.Id,
                Priority       = priority,
                StatusType     = statusType,
                StatusTypeKey  = statusType.Key,
                Title          = title,
                LastUpdateDate = lastUpdateDate
            };

            _context.Tasks.Add(task);
            _context.SaveChanges();
            return(task);
        }
        private ObjectiveDB CreateObjective(int id, string title, string details, int priority, StatusTypeDB statusType, DateTime?statusDate, string statusDetails, DateTime lastUpdateDate)
        {
            var objective = new ObjectiveDB
            {
                Id             = id,
                Details        = details,
                Priority       = priority,
                StatusDate     = statusDate,
                StatusDetails  = statusDetails,
                StatusType     = statusType,
                StatusTypeKey  = statusType.Key,
                Title          = title,
                LastUpdateDate = lastUpdateDate
            };

            _context.Objectives.Add(objective);
            _context.SaveChanges();
            return(objective);
        }
        private ObjectiveHistoryDB CreateObjectiveHistory(int id, ObjectiveDB objective, bool isNew, StatusTypeDB currentStatusType, StatusTypeDB previousStatusType, DateTime updateDate)
        {
            var history = new ObjectiveHistoryDB
            {
                Id = id,
                CurrentStatusType    = currentStatusType,
                CurrentStatusTypeKey = currentStatusType.Key,
                IsNew                 = isNew,
                Objective             = objective,
                ObjectiveId           = objective.Id,
                PreviousStatusType    = previousStatusType,
                PreviousStatusTypeKey = previousStatusType?.Key,
                UpdateDate            = updateDate
            };

            _context.ObjectiveHistories.Add(history);
            _context.SaveChanges();
            return(history);
        }