namespace SigStock
{
    public class Customizer : MercatorUi.ICustomizers.ISigCreated
    {

        public void SigCreated(MercatorUi.Sig.Sig sig) // Mercator moet worden herstart om de wijzigingen in de customizer via SigCreated door te voeren.
        {
            sig.SearchingAll += Sig_SearchingAll;
        }

        private void Sig_SearchingAll(object sender, MercatorUi.Sig.Sig.SearchingAllEventArgs e)
        {
            e.WhereClause += " or (S_MODELEN like '{0}%')"
                           + " or exists(SELECT * from RAYONS (NOLOCK) where (rayons.id=stock.s_id_rayon) and (rayons.nom like '{0}%'))";
        }
    }
}