public RecentlyOpenedDocs()
{
//Ensure entries still exist in sermons table
List <Database.RODs> rods = new Database.RODs().SelectAll();
List <Database.Sermon> sermons = new Database.Sermon().SelectAll();
bool found = false;
for (int i = rods.Count - 1; i >= 0; i--)
{
found = false;
for (int j = 0; j < sermons.Count; j++)
{
if ((sermons[j].Id == rods[i].Id) && (sermons[j].Title == rods[i].Title))
{
found = true;
break;
}
}
if (!found)
{
Database.RODs rod = new Database.RODs(rods[i].Id);
rod.Delete(rod);
}
}
}
static public string[] GetSermonComponents(int id)
{
Database.Sermon dummy = new Database.Sermon(id);
Sermon sermon = new Sermon(dummy.Id, dummy.SeriesId, dummy.DateCreated, dummy.Venue, dummy.Town, dummy.Activity, dummy.Speaker, dummy.KeyText, dummy.Hymn, dummy.Title, dummy.Theme, dummy.Content);
return(ComponentsToString(sermon));
}
static public string GetSermonComponent(int id, string column)
{
string value = string.Empty;
Database.Sermon sermon = new Database.Sermon(id);
value = SermonSwitch(sermon, column);
return(value);
}
static public void DeleteSermon(int id)
{
Database.Sermon sermon = new Database.Sermon(id);
if (sermon != null)
{
sermon.Delete(sermon);
RecentlyOpenedDocs.DeleteSermonFromID(id);
}
}
static public int WriteSermon(string[] arraySermonComponents)
{
Database.Sermon sermon = new Database.Sermon()
{
Activity = arraySermonComponents[iVenueActivity],
Content = arraySermonComponents[iContent],
DateCreated = DateTime.Parse(arraySermonComponents[iDateCreated]),
Hymn = arraySermonComponents[iHymn],
KeyText = arraySermonComponents[iKeyText],
SeriesId = int.Parse(arraySermonComponents[iSeries]),
Speaker = arraySermonComponents[iSpeaker],
Theme = arraySermonComponents[iTheme],
Title = arraySermonComponents[iTitle],
Town = arraySermonComponents[iVenueTown],
Venue = arraySermonComponents[iVenue]
};
return(sermon.Insert(sermon));
}
static private string SermonSwitch(Database.Sermon sermon, string column)
{
switch (column.ToUpper())
{
case "ACTIVITY":
return(sermon.Activity);
case "CONTENT":
return(sermon.Content);
case "YEAR":
return(sermon.DateCreated.Year.ToString());
case "HYMN":
return(sermon.Hymn);
case "KEYTEXT":
return(sermon.KeyText);
case "SERIES":
return(sermon.Series);
case "SPEAKER":
return(sermon.Speaker);
case "TITLE":
return(sermon.Title);
case "THEME":
return(sermon.Theme);
case "TOWN":
return(sermon.Town);
case "VENUE":
return(sermon.Venue);
default:
return(String.Empty);
}
}
static public string[,] Search(string column, string searchString, bool considerCase, bool matchWhole)
{
try
{
List <string> foundItems_Speaker = new List <string>();
List <string> foundItems_Title = new List <string>();
List <string> foundItems_ID = new List <string>();
Database.Sermon dummy = new Database.Sermon();
List <Database.Sermon> sermons = dummy.SelectAll();
if (!considerCase)//considerCase == false: do not match case
{
if (matchWhole)
{
foreach (Database.Sermon sermon in sermons)
{
if (SermonSwitch(sermon, column).ToLower() == searchString.ToLower())
{
SearchGetValues(ref foundItems_ID, ref foundItems_Speaker, ref foundItems_Title, sermon);
}
}
}
else
{
foreach (Database.Sermon sermon in sermons)
{
if (StringSearch.AllExist_InOrder(SermonSwitch(sermon, column).ToLower(), searchString.ToLower()))
{
SearchGetValues(ref foundItems_ID, ref foundItems_Speaker, ref foundItems_Title, sermon);
}
}
}
}
else//considerCase == true: match case
{
if (matchWhole)
{
foreach (Database.Sermon sermon in sermons)
{
if (SermonSwitch(sermon, column) == searchString)
{
SearchGetValues(ref foundItems_ID, ref foundItems_Speaker, ref foundItems_Title, sermon);
}
}
}
else
{
foreach (Database.Sermon sermon in sermons)
{
if (StringSearch.AllExist_InOrder(SermonSwitch(sermon, column), searchString))
{
SearchGetValues(ref foundItems_ID, ref foundItems_Speaker, ref foundItems_Title, sermon);
}
}
}
}
string[,] foundItems = new string[3, foundItems_Title.Count];
for (int i = 0; i < foundItems_ID.Count; i++)
{
foundItems[0, i] = foundItems_Title[i];
foundItems[1, i] = foundItems_Speaker[i];
foundItems[2, i] = foundItems_ID[i];
}
return(foundItems);
}
catch
{
return(null);
}
}
static private void SearchGetValues(ref List <string> foundIDs, ref List <string> foundSpeakers, ref List <string> foundTitles, Database.Sermon sermon)
{
try
{
foundIDs.Add(sermon.Id.ToString());
foundSpeakers.Add(sermon.Speaker);
foundTitles.Add(sermon.Title);
}
catch
{
//the property is null maybe???
}
}
