コード例 #1
0
        public TimeEntry GetLastTimeEntry(bool getInternal = false)
        {
            using (var cnn = GetConnection())
                using (var cmd = cnn.CreateCommand())
                {
                    var internalWhere = (getInternal) ? "" : "WHERE Internal = 0";

                    cmd.CommandText = "SELECT * FROM TimeEntries " + internalWhere + " ORDER BY Id DESC LIMIT 1";

                    using (var reader = cmd.ExecuteReader())
                    {
                        if (!reader.Read())
                        {
                            return(null);
                        }

                        var timeEntry = new TimeEntry
                        {
                            TimeRecorded =
                                DateTime.SpecifyKind(reader.GetDateTime(reader.GetOrdinal("TimeRecorded")),
                                                     DateTimeKind.Local),
                            Comment        = reader.Get <string>("Comment"),
                            Id             = reader.Get <int>("Id"),
                            Task           = _localTaskRepository.GetTaskById(reader.Get <string>("TaskId")),
                            AssociatedTask = _localTaskRepository.GetTaskById(reader.Get <string>("AssociatedTaskId")),
                            Synced         = reader.Get <bool>("Synced"),
                            MinutesSpent   = reader.Get <int>("MinutesSpent"),
                            Internal       = reader.Get <bool>("Internal"),
                            Project        = _localProjectRepository.GetProjectById(reader.Get <string>("ProjectId"))
                        };

                        return(timeEntry);
                    }
                }
        }
コード例 #2
0
        public IEnumerable <Task> GetTasks(string projectId = null, bool emptyProjectIdIsOk = false)
        {
            var tasks = new List <Task>();

            using (var cnn = GetConnection())
                using (var cmd = cnn.CreateCommand())
                {
                    cmd.CommandText = @"SELECT * FROM Tasks WHERE ParentId == ''";

                    if (emptyProjectIdIsOk || !string.IsNullOrEmpty(projectId))
                    {
                        cmd.CommandText += " AND ProjectId = @projectId";

                        cmd.Prepare();
                        cmd.Parameters.AddWithValue("@projectId", projectId);
                    }

                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var task = new Task
                            {
                                Id          = reader.Get <string>("Id"),
                                Name        = reader.Get <string>("Name"),
                                Description = reader.Get <string>("Description"),
                                Parent      = GetTaskById(reader.Get <string>("ParentId")),
                                Project     = _localProjectRepository.GetProjectById(reader.Get <string>("ProjectId"))
                            };
                            task.Tasks = GetTaskChildren(task);

                            tasks.Add(task);
                        }
                    }
                }

            return(tasks);
        }
コード例 #3
0
ファイル: ProjectService.cs プロジェクト: surgeforward/nagger
 public Project GetProjectById(string id)
 {
     return(_localProjectRepository.GetProjectById(id));
 }