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 ActionResult UpdateActorNAme([FromBody] UpdateActorNameRequest updateActorName)
{
var selected_result = "";
var result = _DatabaseLayer.GetActor(updateActorName);
if (result == null)
{
return(BadRequest());
}
else
{
Actor actor = result;
actor.Surname = updateActorName.NewSurname;
actor.setFullName();
selected_result = _DatabaseLayer.UpdateActorName(actor);
}
return(Ok(selected_result));
}
