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