projectService.getProjects().then(function (response) {
    $scope.projects = response.data;
    $scope.loading = false;
}, function() {
    messageService.showError("Failed to get projects. Please refresh and try again");
});


service.getProjects = function() {
    return $http.get(baseUrl + 'API/Projects/');
};

[Route("")]
public List<Project> GetProjects()
{
    return _projectService.GetProjects(_companyId.ToString());
}


public List<Project> GetProjects(string companyId)
{
    return _databaseHelper.QueryProc<Project>("projects_get", new { companyId }).ToList();
}


public class Project
{
    public Guid Id { get; set; }
    public Guid CompanyId { get; set; }
    public string Status { get; set; }
    public string PurchaseOrderNumber { get; set; }
}

[{
    "Id": "daef5b27-fb8c-4804-a407-0165e17c3a60",
    "CompanyId": "76bca824-6e93-45a5-bc5a-ba20d030ebce",
    "Status": "New",
    "PurchaseOrderNumber": "1234-01-01T00:00:00.000Z"
}, {
    "Id": "09d87946-dec2-4721-bf71-df436919b599",
    "CompanyId": "76bca824-6e93-45a5-bc5a-ba20d030ebce",
    "Status": "New",
    "PurchaseOrderNumber": "160728"
}]

SELECT [id]
        ,[companyId]
        ,[status]
        ,[purchaseOrderNumber]
    FROM [dbo].[projects]