public async Task <ActionResult <TblUsersHavingPosts> > RemoveRequestedPost(RequestedPost requestedPost)
{
TblUsersHavingPosts tblUsersHavingPosts = new TblUsersHavingPosts();
tblUsersHavingPosts.Username = requestedPost.Username;
tblUsersHavingPosts.PostId = requestedPost.PostId;
tblUsersHavingPosts.Status = requestedPost.Status;
List <TblUsersHavingPosts> alreadyRequestedPost = _context.TblUsersHavingPosts
.FromSqlRaw("select * from TblUsersHavingPosts where Username = {0} and PostId = {1} " +
"and Status = 'requested'", tblUsersHavingPosts.Username, tblUsersHavingPosts.PostId)
.ToList <TblUsersHavingPosts>();
if (alreadyRequestedPost.Count > 0)
{
_context.TblUsersHavingPosts.RemoveRange(alreadyRequestedPost);
}
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblUsersHavingPosts", new { id = tblUsersHavingPosts.Id }, tblUsersHavingPosts));
}
public async Task <ActionResult <TblUsersHavingPosts> > AddRequestedPost(RequestedPost requestedPost)
{
TblUsersHavingPosts tblUsersHavingPosts = new TblUsersHavingPosts();
tblUsersHavingPosts.Username = requestedPost.Username;
tblUsersHavingPosts.PostId = requestedPost.PostId;
tblUsersHavingPosts.Status = requestedPost.Status;
List <TblUsersHavingPosts> listAccepted = _context.TblUsersHavingPosts
.FromSqlRaw("select * from TblUsersHavingPosts where Username = {0} and Status = 'accepted'", tblUsersHavingPosts.Username)
.ToList <TblUsersHavingPosts>();
if (listAccepted.Count > 0)
{
return(BadRequest());
}
else
{
_context.TblUsersHavingPosts.Add(tblUsersHavingPosts);
}
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblUsersHavingPosts", new { id = tblUsersHavingPosts.Id }, tblUsersHavingPosts));
}
