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