public IActionResult Update(ActorUpdateModel actorUpdateModel)
{
Actor actor = _mapper.Map <Actor>(actorUpdateModel);
ActorResponseModel actorresponse = _mapper.Map <ActorResponseModel>(_actorRepository.Update(actor));
return(Ok(actorresponse));
}
protected override async Task <HttpResponseMessage> SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
{
_logger.LogInformation("Starting ActorDetailsHandler...");
var response = await base.SendAsync(request, cancellationToken);
if (!response.IsSuccessStatusCode)
{
return(response);
}
var responseContent = await response.Content.ReadAsStringAsync();
var actorDetails = JsonSerializer.Deserialize <ActorModel>(responseContent, new JsonSerializerOptions {
PropertyNameCaseInsensitive = true
});
var movies = await _moviesService.GetMovies(actorDetails.Movies);
var actorResponse = new ActorResponseModel()
{
Id = actorDetails.Id,
FirstName = actorDetails.FirstName,
LastName = actorDetails.LastName,
Likes = actorDetails.Likes,
Movies = movies.ToList()
};
response.Content = new StringContent(JsonSerializer.Serialize(actorResponse), System.Text.Encoding.UTF8, "application/json");
_logger.LogInformation("Handler completed");
return(response);
}
public Actor GetActor(UpdateActorNameRequest updateActorName)
{
ActorResponseModel actorResponse = new ActorResponseModel();
string getActor = "select * From ACTOR " +
"WHERE GIVENNAME = @givename and SURNAME = @surname";
// create connection and command
SqlConnection connecting = new SqlConnection(connectionString);
using (SqlCommand getActorCmd = new SqlCommand(getActor, connecting))
{
getActorCmd.Parameters.Add("@newSurname", SqlDbType.VarChar, 100).Value = updateActorName.NewSurname;
getActorCmd.Parameters.Add("@givename", SqlDbType.VarChar, 100).Value = updateActorName.GivenName;
getActorCmd.Parameters.Add("@surname", SqlDbType.VarChar, 100).Value = updateActorName.Surname;
try
{
connecting.Open();
using (SqlDataReader reader = getActorCmd.ExecuteReader())
{
while (reader.Read())
{
// ORM - Object Relation Mapping
actorResponse.Actors.Add(
new Actor()
{
ActorNo = Convert.ToInt32(reader[0]),
FullName = reader[1].ToString(),
GivenName = reader[2].ToString(),
Surname = reader[3].ToString()
});
}
reader.Close();
}
connecting.Close();
}
catch (SqlException ex)
{
throw new ApplicationException($"Some sql error happened + {ex}");
}
}
return(actorResponse.Actors[0]);
}
public IActionResult Create(ActorCreateModel actorCreateModel)
{
//Actor actor = new Actor();
//actor.Name = actorCreateModel.Name;
//actor.Surname = actorCreateModel.Surname;
//actor.Age = actorCreateModel.Age;
//_actorRepository.Create(actor);
//return Ok(actorCreateModel);
Actor actor = _mapper.Map <Actor>(actorCreateModel);
foreach (var actor1 in actorCreateModel.MovieId)
{
ActorMovie actorMovie = new ActorMovie();
actorMovie.Movie = _movieRepository.GetById(actor1);
actor.Movies.Add(actorMovie);
}
ActorResponseModel actorResponse = _mapper.Map <ActorResponseModel>(_actorRepository.Create(actor));
return(Ok(actorResponse));
}
public IActionResult GetById(int id)
{
ActorResponseModel actorResponse = _mapper.Map <ActorResponseModel>(_actorRepository.GetById(id));
return(Ok(actorResponse));
}
