public string Put(Reserveren res) { try { string query = @"update dbo.Reserveren set Datum ='" + res.Datum + @"', Tijd = '" + res.Tijd + @"', GebruikerId = '" + res.GebruikerId + @"', RuimteId ='" + res.RuimteId + @"' where ReserverenId = " + res.ReserverenId + @" "; DataTable table = new DataTable(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["MReserverenDB"].ConnectionString)) using (var cmd = new SqlCommand(query, con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } return("Resreveren is gewijzigd!!"); } catch (Exception) { return("Reserveren wijzigen is mislukt!!"); } }
public void Navigate(string page) { switch (page) { case "Parkings": var parkings = new Parkings(); ApplicationHelper.NavigationService.Navigate(parkings); break; case "Parking": var parking = new Parking(); ApplicationHelper.NavigationService.Navigate(parking); break; case "Home": var home = new Home(); ApplicationHelper.NavigationService.Navigate(home); break; case "Reserveren": var reserveren = new Reserveren(); ApplicationHelper.NavigationService.Navigate(reserveren); break; case "Statistiek": var statistiek = new Statistiek(); ApplicationHelper.NavigationService.Navigate(statistiek); break; default: break; } }
public string Post(Reserveren res) { try { string query = @"insert into dbo.Reserveren values ( '" + res.GebruikerId + @"', '" + res.RuimteId + @"', '" + res.Datum + @"', '" + res.Tijd + @"') "; DataTable table = new DataTable(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["MReserverenDB"].ConnectionString)) using (var cmd = new SqlCommand(query, con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } return("Reserveren is Gemaakt!!"); } catch (Exception) { return("Reserveren mislukt!!"); } }