private void RecNew_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrWhiteSpace(NameBox.Text) && !string.IsNullOrWhiteSpace(PageBox.Text)) { List <string> Tags = new List <string>(); if (TagList.Items.Count > 0) { foreach (var item in TagList.Items) { Tags.Add(item.ToString()); } } string[] TagsArray = new string[Tags.Count]; Tags.CopyTo(TagsArray); string TagString = TagsClass.GetTagStringFromList(TagsArray); DBClass dbclass = new DBClass(); if (dbclass.InsertRecord(NameBox.Text, AuthBox.Text, TagString, PageBox.Text, PathBox.Text) == true) { MessageBox.Show("Operation Successfully Completed", "Info"); } bufdata = dbclass.QueryRecord(); RecList.ItemsSource = bufdata; UpdateViewSource(); } else { MessageBox.Show("A record must have name and page number to storage", "Info"); } }
private void RecUpd_Click(object sender, RoutedEventArgs e) { DataStruct eventdata = RecList.SelectedItem as DataStruct; if (eventdata != null && eventdata is DataStruct) { Int64 rowid = eventdata.id; List <string> Tags = new List <string>(); if (TagList.Items.Count > 0) { foreach (var item in TagList.Items) { Tags.Add(item.ToString()); } } string[] TagsArray = new string[Tags.Count]; Tags.CopyTo(TagsArray); string TagString = TagsClass.GetTagStringFromList(TagsArray); DBClass dbclass = new DBClass(); if (dbclass.UpdateRecord(rowid, NameBox.Text, AuthBox.Text, TagString, PageBox.Text, PathBox.Text)) { MessageBox.Show("Operation Successfully Completed", "Info"); } for (int i = 0; i < bufdata.Count; i++) { if (bufdata[i].id == rowid) { bufdata[i].author = AuthBox.Text; bufdata[i].name = NameBox.Text; bufdata[i].page = int.Parse(PageBox.Text); bufdata[i].path = PathBox.Text; bufdata[i].tagstring = TagString; } } UpdateViewSource(); } }