void ImplementChanges(DirtyRowStruct drs) { AppEngine.Database.Sermon sermon = new AppEngine.Database.Sermon(drs.SermonId); switch (drs.ColumnName) { case "Series": sermon.SeriesId = int.Parse(drs.Value); break; case "Date Created": sermon.DateCreated = DateTime.Parse(drs.Value); break; case "Venue": sermon.VenueId = int.Parse(drs.Value); break; case "Town": sermon.TownId = int.Parse(drs.Value); break; case "Activity": sermon.ActivityId = int.Parse(drs.Value); break; case "Speaker": sermon.SpeakerId = int.Parse(drs.Value); break; case "Theme": sermon.ThemeId = int.Parse(drs.Value); break; case "Title": sermon.Title = drs.Value; break; case "Key Text": sermon.KeyText = drs.Value; break; case "Hymn": sermon.Hymn = drs.Value; break; } sermon.Update(sermon); }
private void SaveTypedData() { try { DateTime datetime = dtPicker.Value; int series; try { if (!int.TryParse(cmbxSeries.SelectedValue.ToString(), out series)) { series = 0; } } catch { series = 0; } string venue; if (string.IsNullOrEmpty(txbVenue_Name.Text)) { venue = "NOT SET"; } if (txbVenue_Name.Text == txbVenue_Name.Watermark) { venue = "NOT SET"; } else { venue = txbVenue_Name.Text; } string town; if (string.IsNullOrEmpty(txbVenue_Town.Text)) { town = "NOT SET"; } if (txbVenue_Town.Text == txbVenue_Town.Watermark) { town = "NOT SET"; } else { town = txbVenue_Town.Text; } string activity; if (string.IsNullOrEmpty(txbVenue_Activity.Text)) { activity = "NOT SET"; } if (txbVenue_Activity.Text == txbVenue_Activity.Watermark) { activity = "NOT SET"; } else { activity = txbVenue_Activity.Text; } string speaker; if (string.IsNullOrEmpty(txbSpeakerName.Text)) { speaker = "NOT SET"; } if (txbSpeakerName.Text == txbSpeakerName.Watermark) { speaker = "NOT SET"; } else { speaker = txbSpeakerName.Text; } string keytext; if (string.IsNullOrEmpty(txbKeyText.Text)) { keytext = "NOT SET"; } if (txbKeyText.Text == txbKeyText.Watermark) { keytext = "NOT SET"; } else { keytext = txbKeyText.Text; } string hymn; if (string.IsNullOrEmpty(txbHymn.Text)) { hymn = "NOT SET"; } if (txbHymn.Text == txbHymn.Watermark) { hymn = "NOT SET"; } else { hymn = txbHymn.Text; } string title; if (string.IsNullOrEmpty(txbTitle.Text)) { title = "NOT SET"; } if (txbTitle.Text == txbTitle.Watermark) { title = "NOT SET"; } else { title = txbTitle.Text; } string theme; if (string.IsNullOrEmpty(txbTheme.Text)) { theme = "NOT SET"; } if (txbTheme.Text == txbTheme.Watermark) { theme = "NOT SET"; } else { theme = txbTheme.Text; } string content = rtbContent.Rtf; StatusBarMessages.SetStatusBarMessageAction("Saving " + title); if (isEdited == false)//new sermon { Sermon sermon = new Sermon(0, series, datetime, venue, town, activity, speaker, keytext, hymn, title, theme, content); string[] arraySubItems = Sermon.ComponentsToString(sermon); if (Sermon.WriteSermon(arraySubItems) == 1)//sermon inserted successfully { AppEngine.Database.Sermon dummy = new AppEngine.Database.Sermon() { Activity = sermon.Activity, Content = sermon.Content, DateCreated = sermon.DateCreated, Hymn = sermon.Hymn, KeyText = sermon.KeyText, Speaker = sermon.Speaker, Title = sermon.Title, Theme = sermon.Theme, Town = sermon.Town, Venue = sermon.Venue }; if (dummy.Exists(dummy)) { sermon.Id = dummy.Id; parentForm.tabControl.TabPages.Remove(parentForm.tabControl.SelectedTab); parentForm.AddNewTabPage(SermonReader.DisplayStoredSermon(Sermon.ComponentsToString(sermon))); treeViewEx.AddNewTreeNode(dummy.Title, dummy.Id.ToString()); } } else { MessageBox.Show("Document not added.\nPlease try again."); } } else//edited sermon: use existing ID { Sermon sermon = new Sermon(editedID, series, datetime, venue, town, activity, speaker, keytext, hymn, title, theme, content); string[] arraySubItems = Sermon.ComponentsToString(sermon); arraySubItems[iID] = editedID.ToString(); Sermon.OverwriteSermon(arraySubItems); parentForm.tabControl.TabPages.Remove(parentForm.tabControl.SelectedTab); parentForm.AddNewTabPage(SermonReader.DisplayStoredSermon(arraySubItems)); } StatusBarMessages.SetStatusBarMessageAction("Saved " + title); } catch { StatusBarMessages.SetStatusBarMessageAction("Error saving " + txbTitle.Text); } }
public void SortTreeView(string filter) { try { BeginUpdate(); Nodes.Clear(); List <AppEngine.Database.Sermon> list = new AppEngine.Database.Sermon().SelectAllCondensed(); list = list.OrderBy(x => x.DateCreated).ToList(); List <string> parentNodes = Sermon.GetParentNodes(filter, list); foreach (var parent in parentNodes) { if (!string.IsNullOrEmpty(parent)) { TreeNode parentNode = new TreeNode() { Text = parent, Name = "PARENTNODE" }; bool nodeExists = false; foreach (TreeNode node in Nodes) { if (node.Text == parentNode.Text) { nodeExists = true; } } if (nodeExists == false) { Nodes.Add(parentNode); } } } foreach (TreeNode parentNode in Nodes) { List <KeyValuePair <string, string> > childNodes = Sermon.GetChildNodes(filter, parentNode.Text, list); foreach (var entry in childNodes) { TreeNode childNode = new TreeNode() { Name = entry.Key, Text = entry.Value }; if (!parentNode.Nodes.Contains(childNode)) { parentNode.Nodes.Add(childNode); } else { MessageBox.Show("This child node already exists: " + childNode.Text); } } } EndUpdate(); } catch { EndUpdate(); } }