public bool DoesActorRoleExist(ActorRole ar)
{
using (var cmd = new NpgsqlCommand()) {
cmd.Connection = conn;
cmd.CommandText = "SELECT EXISTS(SELECT * FROM actorRoles WHERE seriesId = @seriesId AND actorId = @actorId)";
cmd.Parameters.AddWithValue("seriesId", ar.series.id);
cmd.Parameters.AddWithValue("actorId", ar.actor.id);
return((bool)cmd.ExecuteScalar());
}
}
public int?InsertOrUpdateActorRole(ActorRole ar)
{
if (DoesActorRoleExist(ar))
{
return(ar.id);
}
using (var cmd = new NpgsqlCommand()) {
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO actorRoles " +
"(seriesRole, seriesId, actorId) " +
"VALUES " +
"(@seriesRole, @seriesId, @actorId) " +
"RETURNING id";
cmd.Parameters.AddWithValue("seriesRole", ar.role);
cmd.Parameters.AddWithValue("seriesId", ar.series.id);
cmd.Parameters.AddWithValue("actorId", ar.actor.id);
return((int)cmd.ExecuteScalar());
}
}
