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()); } }