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)); }