<页面x:类＝“GolfComp.Views.TeamListPage”xmlns＝“http://schemas.microsoft.com/winfx/2006/xaml/presentation”xmlns: x＝“http://schemas.microsoft.com/winfx/2006/xaml”xmlns:本地＝“使用:GolfComp。视图”xmlns: d＝“http://schemas.microsoft.com/expression/blend/2008”xmlns: mc＝“http://schemas.openxmlformats.org/markup-compatibility/2006”xmlns:控制＝“使用:Microsoft.Toolkit.Uwp.UI.Controls”xmlns: telerikGrid＝“使用:Telerik.UI.Xaml.Controls.Grid”主持人:可忽略的＝“d”背景＝“{ThemeResource ApplicationPageBackgroundThemeBrush}”><网格背景＝“{ThemeResource ApplicationPageBackgroundThemeBrush}”><RelativePanel><CommandBarx:名字＝“mainCommandBar”HorizontalAlignment＝“拉伸”IsEnabled＝“{x:绑定enableCommandBar}”><AppBarButton点击＝“Insert_new_entry”图标＝“添加”标签＝“新”ToolTipService。工具提示＝“新纪录”/><AppBarButton点击＝“Delete_Click”图标＝“删除”标签＝“删除”ToolTipService。工具提示＝“删除记录”/><AppBarButton点击＝“UpdateRecord_Click”图标＝“刷新”标签＝“更新”ToolTipService。工具提示＝“更新记录”/>CommandBar><StackPanelx:名字＝“newRecordStackPanel”取向＝“水平”RelativePanel。下面＝“mainCommandBar”><组合框x:名字＝“golfclubDropDown”头＝“Homeclub”保证金＝“8 8 8 16日”MinWidth＝“150”/><组合框x:名字＝“klasseDropDown”头＝“竞争”保证金＝“8 8 8 16日”MinWidth＝“150”/><文本框x:名字＝“TeamNaamTextBox”头＝“Teamnaam”编辑中＝“teamnaam”保证金＝“8 8 8 16日”/><AppBarButtonx:名字＝“DeleteNewRecord”点击＝“DeleteNewRecord_Click”图标＝“取消”/><AppBarButtonx:名字＝“SaveNewRecord”点击＝“SaveNewRecord_Click”图标＝“保存”/>StackPanel><telerikGrid: RadDataGridAutoGenerateColumns＝“假”x:名字＝“Datagrid”BorderThickness＝“0”ColumnDataOperationsMode＝“飞出”GridLinesVisibility＝“没有”GroupPanelPosition＝“左”RelativePanel。AlignLeftWithPanel＝“真正的”RelativePanel。AlignRightWithPanel＝“真正的”RelativePanel。下面＝“newRecordStackPanel”UserEditMode＝“内联”设置SelectedItem＝"{x:Bind SelectedItem, Mode= two}"><telerikGrid: RadDataGrid。列><telerikGrid: DataGridComboBoxColumnPropertyName＝“竞争”头＝“竞争”ItemsSource＝“{x:绑定klasse}”DisplayMemberPath＝“竞争”SelectedValuePath＝“Klasse_Id”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler1Id”头＝“? 1”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler2Id”头＝“? 2”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler3Id”头＝“3 ?”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler4Id”头＝“4 ?”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler5Id”头＝“5 ?”/><telerikGrid: DataGridNumericalColumnPropertyName＝“Speler6Id”头＝“6 ?”/><telerikGrid: DataGridTextColumnPropertyName＝“拿”头＝“Teamnaam”/>telerikGrid: RadDataGrid。列>telerikGrid: RadDataGrid>RelativePanel>网格>页面>

名称空间GolfComp。的观点{///<摘要>///可以单独使用或在框架内导航到的空页面。///> < /总结公共密封部分类TeamListPage：页面，INotifyPropertyChanged{ObservableCollection speler =新ObservableCollection < SpelerModel > ();ObservableCollection golfclub =新ObservableCollection < GolfclubModel > ();ObservableCollection team =新ObservableCollection < TeamModel > ();ObservableCollection coach =新ObservableCollection < CoachModel > ();ObservableCollection KlasseModel =新ObservableCollection < KlasseModel > ();保龄球enableCommandBar =真正的;公共TeamListPage（）{这.InitializeComponent ();newRecordStackPanel。能见度=能见度，坍塌;}受保护的覆盖无效OnNavigatedTo（NavigationEventArgs e）{基地.OnNavigatedTo (e);GetData ();wireUpDropdowns ();如果(Datagrid。ItemsSource = =零){数据网格。ItemsSource＝team; } }公共无效GetData（）{字符串sql1 =“SELECT * from speller”;varspelerlijst = SqliteDataAccess。LoadData < SpelerModel > (sql1新字典<字符串，对象> ());spelerlijst。ForEach(x => speler.Add(x));字符串sql2 ="select * from Golfclub";vargolfclublijst = SqliteDataAccess。LoadData < GolfclubModel > (sql2新字典<字符串，对象> ());golfclublijst。ForEach(x => . gofclub . add (x));字符串sql3 =“选择团队。Id, KlasseId, Speler1Id, Speler2Id, Speler3Id, Speler4Id, Speler5Id, Speler6Id, Team。Naam, Klasse_Id, Klasse_Naam, Klasse_Omschrijving from Team”+“克拉斯和克拉斯在一起。Klasse_Id = Team.KlasseId;";varteamlijst = SqliteDataAccess。LoadData < TeamModel > (sql3新字典<字符串，对象> ());teamlijst。ForEach(x = bb0 team.Add(x));字符串sql4 =“select * from Coach”;varcoachlijst = SqliteDataAccess。LoadData < CoachModel > (sql4新字典<字符串，对象> ());coachlijst。ForEach(x => coach.Add(x));字符串sql5 =“select * from Klasse”;varklasselijst = SqliteDataAccess。LoadData < KlasseModel > (sql5新字典<字符串，对象> ());klasselijst。ForEach(x =>);}私人无效wireUpDropdowns（）{golfclubDropDown。ItemsSource＝golfclub; golfclubDropDown.DisplayMemberPath =“拿”;golfclubDropDown。SelectedValuePath =“Id”;klasseDropDown。ItemsSource＝klasse; klasseDropDown.DisplayMemberPath =“竞争”;klasseDropDown。SelectedValuePath =“Klasse_Id”;}私人无效Delete_Click（对象sender, RoutedEventArgs）{字符串sql =“删除Id = @Id的团队”;试一试{字典<字符串，对象> parameters =新字典<字符串，对象> {{“@ id”,设置SelectedItem。Id}};SqliteDataAccess。作用(sql参数);speler.Clear ();GetData ();} catch {MessageDialog MessageDialog =新MessageDialog (“四:选择者甚至记录”）;_ = messagedialog.ShowAsync();返回;}}私人无效UpdateRecord_Click（对象sender, RoutedEventArgs）{字符串sql =“更新团队设置KlasseId = @KlasseId, Speler1Id = @Speler1Id, Speler2Id = @Speler2Id，”+"Speler3Id = @Speler3Id, Speler4Id = @Speler4Id, Speler5Id = @Speler5Id, Speler6Id = @Speler6Id， "+“Naam = @Naam, CoachId = @CoachId, ClubId = @ClubId, PuntenVoor = @PuntenVoor, PuntenTegen = @PuntenTegen”+"where Id = @Id";试一试{字典<字符串，对象> parameters =新字典<字符串，对象> {{“@ id”,设置SelectedItem。Id}， {“@KlasseId”,设置SelectedItem。Klasse_Id}， {“@Speler1Id”,设置SelectedItem。Speler1Id}, {“@Speler2Id”,设置SelectedItem。Speler2Id}, {“@Speler3Id”,设置SelectedItem。Speler3Id}, {“@Speler4Id”,设置SelectedItem。Speler4Id}, {“@Speler5Id”,设置SelectedItem。Speler5Id}, {“@Speler6Id”,设置SelectedItem。Speler6Id}, {“@Naam”,设置SelectedItem。拿安},{“@CoachId”,设置SelectedItem。CoachId}, {“@ClubId”,设置SelectedItem。ClubId}, {“@PuntenVoor”,设置SelectedItem。PuntenVoor}, {“@PuntenTegen”,设置SelectedItem。PuntenTegen}};SqliteDataAccess。SaveData (sql参数);speler.Clear ();GetData ();MessageDialog =新MessageDialog (“成功:wijzigingen weggeschreven”）;_ = messagedialog.ShowAsync();} catch (Exception ex) {MessageDialog MessageDialog =新MessageDialog (ex.Message);_ = messagedialog.ShowAsync();返回;}}私人无效Insert_new_entry（对象sender, RoutedEventArgs）{enableCommandBar =假;newRecordStackPanel。可见性=可见性;}私人无效DeleteNewRecord_Click（对象sender, RoutedEventArgs）{enableCommandBar =真正的;newRecordStackPanel。能见度=能见度，坍塌;}私人（保龄球ValidateForm() {保龄球isValid =真正的;TeamModel模型=新TeamModel ();试一试{模型。KlasseId = (int) klasseDropDown.SelectedValue;模型。Speler1Id =0;模型。Speler2Id =0;模型。Speler3Id =0;模型。Speler4Id =0;模型。Speler5Id =0;模型。Speler6Id =0;模型。Naam = TeamNaamTextBox.Text;模型。CoachId =0;模型。ClubId = (int) golfclubDropDown.SelectedValue;模型。PuntenVoor =0;模型。PuntenTegen =0;} catch {isValid =假;}返回(isValid模型);}私人无效SaveNewRecord_Click（对象sender, RoutedEventArgs）{TeamModel模型=新TeamModel ();字符串sql =“插入到团队(KlasseId, Speler1Id, Speler2Id, Speler3Id, Speler4Id, Speler5Id, Speler6Id, Naam, CoachId, ClubId, PuntenVoor, PuntenTegen)”+“values (@KlasseId， @Speler1Id， @Speler2Id， @Speler3Id， @Speler4Id， @Speler5Id， @Speler6Id， @Naam， @CoachId， @ClubId， @PuntenVoor， @PuntenTegen)”;varform = ValidateForm();如果(形式。isValid = =假) {MessageDialog MessageDialog =新MessageDialog (“foutieve其。“这是我的机会。”）;_ = messagedialog.ShowAsync();返回;}如果(TeamNaamTextBox。文本= =”“) {MessageDialog MessageDialog =新MessageDialog (“你来吧!”）;_ = messagedialog.ShowAsync();返回;词典}<字符串，对象> parameters =新字典<字符串，对象> {{“@KlasseId”， form.model.KlasseId}， {“@Speler1Id”, form.model。spelerid}， {“@Speler2Id”, form.model。Speler2Id}，“@Speler3Id”, form.model。spelerid}， {“@Speler4Id”, form.model。spelerid}， {“@Speler5Id”, form.model。Speler5Id}， {“@Speler6Id”, form.model。Speler6Id}， {“@Naam”， form.model.Naam}， {“@CoachId”， form.model.CoachId}， {“@ClubId”， form.model.ClubId}， {“@PuntenVoor”， form.model.PuntenVoor}， {“@PuntenTegen”， form.model.PuntenTegen}};SqliteDataAccess。SaveData (sql参数);/ / speler.Add (form.model);enableCommandBar =真正的;newRecordStackPanel。能见度=能见度，坍塌;team.Clear ();GetData ();wireUpDropdowns ();}公共事件PropertyChangedEventHandler propertychange;公共无效OnPropertyChanged（(CallerMemberName)字符串propertyName =零）= > propertychange ?。调用(这，新PropertyChangedEventArgs (propertyName));私人TeamModel _selectedItem;公共TeamModel SelectedItem {得到= > _selectedItem;集{如果(_selectedItem ! =价值) {_selectedItem =价值;OnPropertyChanged ();} } } } }