/// <summary>
/// Method to update a review
/// </summary>
/// <param name="review"></param>
public void UpdateReview(CarReview review)
{
var originalReview = _repo.Query <CarReview>().Where(o => o.Id == review.Id).FirstOrDefault();
originalReview.Message = review.Message;
_repo.Update <CarReview>(originalReview);
}
private void TextBlockMouseDown(object sender, MouseButtonEventArgs e)
{
if (e.ClickCount >= 2)
{
if (CheckConnection())
{
if (carsListBox.SelectedItem == null)
{
return;
}
Car selectedCar = carsListBox.SelectedItem as Car;
if (selectedCar == null)
{
return;
}
string carName = selectedCar.Manufacturer + " " + selectedCar.Model;
string carReview = selectedCar.Review;
string carImage = selectedCar.Image;
int? idOwner = selectedCar.IdOwner;
int year = selectedCar.ProductionYear;
CarReview ShowCarReview = new CarReview(carName, year, carReview, carImage, idOwner);
ShowCarReview.ShowDialog();
}
else
{
MessageBox.Show("Sorry, seems like it is not possible to connect to DB at the moment");
}
}
}
//ADD CAR REVIEW
public IActionResult Post(int id, [FromBody] CarReview review)
{
if (ModelState.IsValid)
{
if (review.Id == 0)
{
_repo.AddCarReview(id, review, HttpContext.ApplicationServices);
}
else
{
_repo.UpdateReview(review);
}
return(Ok(review));
}
return(HttpBadRequest(ModelState));
}
/// <summary>
/// Method to add a car review
/// </summary>
/// <param name="Id"></param>
/// <param name="review"></param>
/// <param name="sp"></param>
public async void AddCarReview(int Id, CarReview review, IServiceProvider sp)
{
var _db = sp.GetService <ApplicationDbContext>();
var result = await Get(review.Message);
//Section to add sentiment entity/score to a car review
review.SentimentEntities = new List <SentimentInfo>();
foreach (var r in result)
{
var sentiment = new SentimentInfo()
{
SentimentScore = r.sentiment.score,
EntityType = r.sentiment.type
};
review.SentimentEntities.Add(sentiment);
}
review.TimeCreated = DateTime.Now;
var car = _db.Cars.Where(c => c.Id == Id).Include(u => u.Reviews).FirstOrDefault();
car.Reviews.Add(review);
_db.SaveChanges();
}
