[HttpGet("{postid}")] // here must put in /<idvalue> to ge
public async Task <PostWithUser> Get(string postid)
{
int postID = 1;
if (Int32.TryParse(postid, out postID))
{
return(await Task.Run(() =>
{
var pwusQuery = from p in context.Posts
join u in context.Users
on p.UserID equals u.UserID
orderby p.PostID descending
select new
{
p.PostID,
p.BlogPost,
p.ImageFile,
p.WeatherType,
p.ZipCode,
p.TempFahr,
p.WeatherJson,
p.PublishDateTime,
u.UserID,
u.FirstName,
u.LastName,
u.Username
};
PostWithUser pwu = new PostWithUser();
foreach (var item in pwusQuery)
{
if (item.PostID == postID)
{
var matching_pwu = new PostWithUser(item.PostID, item.BlogPost, item.ImageFile, item.WeatherType, item.ZipCode,
item.TempFahr, item.WeatherJson, item.PublishDateTime,
item.UserID, item.FirstName, item.LastName,
item.Username);
pwu = matching_pwu;
}
}
return pwu;
}));
}
return(await Task.Run(() =>
{
return new PostWithUser();
}));
}
public async Task <IEnumerable <PostWithUser> > Get()
{
return(await Task.Run(() => {
var pwusQuery = from p in context.Posts
join u in context.Users
on p.UserID equals u.UserID
orderby p.PostID descending
select new
{
p.PostID,
p.BlogPost,
p.ImageFile,
p.WeatherType,
p.ZipCode,
p.TempFahr,
p.WeatherJson,
p.PublishDateTime,
u.UserID,
u.FirstName,
u.LastName,
u.Username
};
var pwus = new List <PostWithUser>();
foreach (var item in pwusQuery)
{
var postWithUser = new PostWithUser(item.PostID, item.BlogPost, item.ImageFile, item.WeatherType, item.ZipCode,
item.TempFahr, item.WeatherJson, item.PublishDateTime,
item.UserID, item.FirstName, item.LastName,
item.Username);
pwus.Add(postWithUser);
}
return pwus;
}));
}
