internal bool hasRelationship(DTOJobFavorite fav)
{
string sql = "SELECT * FROM jobfavorites WHERE jobId = @JobId AND user = @User";
var found = _db.QueryFirstOrDefault <DTOJobFavorite>(sql, fav);
return(found != null);
}
internal DTOJobFavorite Create(DTOJobFavorite fav)
{
if (_repo.hasRelationship(fav))
{
throw new Exception("you already have that fav");
}
return(_repo.Create(fav));
}
public ActionResult <DTOJobFavorite> Create([FromBody] DTOJobFavorite fav)
{
try
{
fav.User = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
return(Ok(_cfs.Create(fav)));
}
catch (System.Exception err)
{
return(BadRequest(err.Message));
}
}
internal DTOJobFavorite Create(DTOJobFavorite fav)
{
string sql = @"
INSERT INTO jobfavorites
(user, jobid)
VALUES
(@User, @JobId);
SELECT LAST_INSERT_ID();
";
fav.Id = _db.ExecuteScalar <int>(sql, fav);
return(fav);
}
