protected void dataBindDelays()
    {
        BLLdelay BLLDelay = new BLLdelay();

        IList<Delay> listDelays = BLLDelay.selectAll();
        rptDelays.DataSource = listDelays;
        rptDelays.DataBind();
    }
    // User voegt een vertraging toe
    public void rptDepartures_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandName == "addDelay")
        {
            try
            {
                // Rowindex van repeater
                int index = e.Item.ItemIndex;

                // Element uit list halen met index
                Departure departure = departures.ElementAt(index);

                // Vertraging toevoegen aan database
                BLLdelay BLLdelay = new BLLdelay();

                // Eerst checken of vertraging al is toegevoegd
                if (BLLdelay.delayExists(departure.time, departure.vehicle))
                {
                    feedback.Attributes["class"] = "alert-message block-message";
                    lblFeedback.Text = "Deze vertraging is reeds toegevoegd.";
                }
                else
                {
                    // Userid ophalen
                    var user = Membership.GetUser();
                    string userID = user.ProviderUserKey.ToString();
                    Guid uUserID = new Guid(userID);

                    Delay delay = new Delay();
                    delay.delay_startStation = departure.startStation;
                    delay.delay_destinationStation = departure.destinationStation;
                    delay.delay_vehicle = departure.vehicle;
                    delay.delay_time = departure.time;
                    delay.delay_delayTime = departure.delay;
                    delay.fk_delay_uid = uUserID;

                    BLLdelay.insertDelay(delay);
                    feedback.Attributes["class"] = "alert-message block-message";
                    lblFeedback.Text = "Vertraging succesvol toegevoegd.";
                }
            }
            catch (Exception ex)
            {
                feedback.Attributes["class"] = "alert-message block-message";
                lblFeedback.Text = "Er is een fout opgetreden bij het toevoegen van deze vertraging.";
            }
        }
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        LinkButton btn = (LinkButton)sender;
        BLLdelay BLLDelay = new BLLdelay();

        try
        {
            BLLDelay.delete(Convert.ToInt16(btn.CommandName));
            feedback.Attributes["class"] = "alert-message block-message";
            lblFeedback.Text = "Vertraging succesvol verwijderd.";
        }
        catch (Exception ex)
        {
            feedback.Attributes["class"] = "alert-message block-message";
            lblFeedback.Text = "Vertraging kon niet verwijderd worden <br />" + ex.Message;
        }

        this.dataBindDelays();
    }