/// <summary>
/// Método que retorna a lista de reviews feitas ao mate
/// </summary>
/// <param name="mate">Id do mate</param>
/// <returns>Lista de reviews</returns>
public List <MateReviewsModel> MateReviewsList(int mate)
{
List <MateReviewsModel> reviews = new List <MateReviewsModel>();
using (SqlCommand cmd = _connection.Fetch().CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT MateReview.Rating, MateReview.Comment, dbo.[User].UserName as Author FROM MateReview " +
"inner join dbo.[User] ON dbo.[User].Id = MateReview.EmployerId " +
"Where MateId=@mate";
cmd.Parameters.Add("@mate", SqlDbType.Int).Value = mate;
using (SqlDataAdapter adpt = new SqlDataAdapter(cmd))
{
DataTable table = new DataTable();
adpt.Fill(table);
foreach (DataRow row in table.Rows)
{
MateReviewsModel mr = new MateReviewsModel
{
Rating = Convert.ToSingle(row["Rating"]),
Comment = row["Comment"].ToString(),
Author = row["Author"].ToString()
};
reviews.Add(mr);
}
}
}
return(reviews);
}
public ActionResult <MateReviewsModel> ReviewMate(int mate, MateReviewsModel revModel)
{
int?employerID = ClaimHelper.GetIdFromClaimIdentity((ClaimsIdentity)this.ControllerContext.HttpContext.User.Identity);
// caso o mate id seja nulo
if (employerID == null)
{
return(Unauthorized(new ErrorMessageModel("Utilizador não existe!")));
}
MateReview review = _mapper.Map <MateReview>(revModel);
IReviewMateDAO ReviewMateDAO = new ReviewMateDAO(_connection);
MateReviewsModel reviewModel = _mapper.Map <MateReviewsModel>(ReviewMateDAO.ReviewMate((int)employerID, mate, review));
return(Ok(reviewModel));
}
