public List <ProjectRecord> FindBy(long accountId) { const string sql = @" select id, account_id, name, active from projects where account_id = @accountId order by name asc"; return(_template.FindBy(sql, reader => new ProjectRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetString(2), reader.GetBoolean(3) ), "@accountId", accountId)); }
public List <StoryRecord> FindBy(long projectId) { const string sql = @" select id, project_id, name from stories where project_id = @projectId"; return(_template.FindBy(sql, reader => new StoryRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetString(2) ), "@projectId", projectId)); }
public UserRecord FindObjectBy(long id) { var sql = @"select id, name from users where id = @id limit 1"; var userRecords = _template.FindBy(sql, reader => new UserRecord( reader.GetInt64(0), reader.GetString(1) ), "@id", id); return(userRecords.Count > 0 ? userRecords.First() : null); }
public List <AccountRecord> FindBy(long ownerId) { var sql = "select id, owner_id, name from accounts where owner_id = @ownerId"; var records = _template.FindBy(sql, reader => new AccountRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetString(2) ), "@ownerId", ownerId); return(records); }
public AccountRecord FindBy(long ownerId) { var sql = @" select id, owner_id, name from accounts where owner_id = @ownerId order by name desc limit 1"; var userRecords = _template.FindBy(sql, reader => new AccountRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetString(2) ), "@ownerId", ownerId); return(userRecords.Count > 0 ? userRecords.First() : null); }
public List <AllocationRecord> FindBy(long projectId) { const string sql = @" select id, project_id, user_id, first_day, last_day from allocations where project_id = @projectId order by first_day"; return(_template.FindBy(sql, reader => new AllocationRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetInt64(2), reader.GetDateTime(3), reader.GetDateTime(4) ), "@projectId", projectId)); }
public List <TimeEntryRecord> FindBy(long userId) { const string sql = @" select id, project_id, user_id, date, hours from time_entries where user_id = @userId"; return(_template.FindBy(sql, reader => new TimeEntryRecord( reader.GetInt64(0), reader.GetInt64(1), reader.GetInt64(2), reader.GetDateTime(3), reader.GetInt32(4) ), "@userId", userId)); }