/// <summary>
/// Refresh cached data.
/// </summary>
/// <param name="userContext">User context.</param>
protected override void RefreshCache(IUserContext userContext)
{
lock (LumpSplitEventTypes)
{
LumpSplitEventTypes.Clear();
}
lock (Taxa)
{
Taxa.Clear();
}
lock (TaxonAlertStatuses)
{
TaxonAlertStatuses.Clear();
}
lock (TaxonCategories)
{
TaxonCategories.Clear();
}
lock (TaxonChangeStatuses)
{
TaxonChangeStatuses.Clear();
}
lock (TaxonChildQualityStatistics)
{
TaxonChildQualityStatistics.Clear();
}
lock (TaxonNameCategories)
{
TaxonNameCategories.Clear();
}
lock (TaxonNameCategoryTypes)
{
TaxonNameCategoryTypes.Clear();
}
lock (TaxonNames)
{
TaxonNames.Clear();
}
lock (TaxonNameStatuses)
{
TaxonNameStatuses.Clear();
}
lock (TaxonNameUsages)
{
TaxonNameUsages.Clear();
}
lock (TaxonRevisionEventTypes)
{
TaxonRevisionEventTypes.Clear();
}
lock (TaxonRevisionStates)
{
TaxonRevisionStates.Clear();
}
}
/// <summary>
/// Get taxon names for specified locale and taxon.
/// </summary>
/// <param name="taxon">Taxon.</param>
/// <param name="locale">Locale.</param>
/// <returns>Taxon names for specified locale.</returns>
protected virtual TaxonNameList GetTaxonNames(ITaxon taxon, ILocale locale)
{
String cacheKey;
TaxonNameList taxonNames = null;
cacheKey = GetTaxonNameCacheKey(taxon, locale);
if (TaxonNames.ContainsKey(cacheKey))
{
taxonNames = (TaxonNameList)(TaxonNames[cacheKey]);
}
return(taxonNames);
}
/// <summary>
/// Get taxon names for specified locale and taxon.
/// </summary>
/// <param name="taxon">Taxon.</param>
/// <param name="locale">Locale.</param>
/// <returns>Taxon names for specified locale.</returns>
protected override TaxonNameList GetTaxonNames(ITaxon taxon, ILocale locale)
{
String cacheKey;
TaxonNameList taxonNames = null;
cacheKey = GetTaxonNameCacheKey(taxon, locale);
lock (TaxonNames)
{
if (TaxonNames.ContainsKey(cacheKey))
{
taxonNames = (TaxonNameList)(TaxonNames[cacheKey]);
}
}
return(taxonNames);
}
/// <summary>
/// Refresh cached data.
/// </summary>
/// <param name="userContext">User context.</param>
protected virtual void RefreshCache(IUserContext userContext)
{
LumpSplitEventTypes.Clear();
Taxa.Clear();
TaxonAlertStatuses.Clear();
TaxonCategories.Clear();
TaxonChangeStatuses.Clear();
TaxonChildQualityStatistics.Clear();
TaxonNameCategories.Clear();
TaxonNameCategoryTypes.Clear();
TaxonNames.Clear();
TaxonNameStatuses.Clear();
TaxonNameUsages.Clear();
TaxonRevisionEventTypes.Clear();
TaxonRevisionStates.Clear();
}
public int getTaxa(string source, string target)
{
//Alte DB-Einträge löschen
string connString = "Data Source=\"" + sdfPath + "\";Max Database Size=128;Default Lock Escalation=100;";
SqlCeConnection conn = new SqlCeConnection(connString);
DbCommand command = conn.CreateCommand();
conn.Open();
StringBuilder sb = new StringBuilder();
sb.Append("Delete From ").Append(target);
command.CommandText = sb.ToString();
command.ExecuteNonQuery();
conn.Close();
//Neue Taxa holen
List <TaxonNames> taxa = new List <TaxonNames>();
DbCommand com = ConnRepository.CreateCommand();
sb = new StringBuilder();
sb.Append("Select * From ").Append(source);
com.CommandText = sb.ToString();
ConnRepository.Open();
DbDataReader reader = com.ExecuteReader();
while (reader.Read())
{
TaxonNames taxon = SerRepository.CreateISerializableObject <TaxonNames>();
taxon.NameURI = reader.GetString(0);
taxon.TaxonNameCache = reader.GetString(1);
taxon.Synonym = reader.GetString(2);
taxa.Add(taxon);
}
ConnRepository.Close();
SerMobile.Connector.BeginTransaction();
foreach (TaxonNames taxon in taxa)
{
SerMobile.Connector.InsertPlain(taxon, target);
}
SerMobile.Connector.Commit();
return(taxa.Count);
}
private void textBoxSearch_TextChanged(object sender, EventArgs e)
{
if (this.textBoxSearch.Text.Trim().Length >= 1)
{
try
{
// Ausgabe des Zeichens verhindern
TaxonNames actual = DataFunctions.Instance.CreateTaxonNames();
actual.TaxonNameCache = this.textBoxSearch.Text;//Unterstützung von Arbeitsnamen
actual.NameURI = String.Empty;
String input = this.textBoxSearch.Text.Trim();
input += "%";
input = input.Replace(" ", "% ");
input = input.Replace("'", "''");
this.comboBoxIdentification.Items.Clear();
comboBoxIdentification.Items.Insert(0, actual.TaxonNameCache);
this.comboBoxIdentification.SelectedItem = actual.TaxonNameCache;
IList <string> Ilist = DataFunctions.Instance.RetrieveTaxonCache(input, this.labelTaxonomicGroup.Text);//Auswahl der TaxonomischenGruppe gewährleisten
foreach (string item in Ilist)
{
if (item != null)
{
comboBoxIdentification.Items.Add(item);
if (item.Equals(actual.TaxonNameCache))//prüfen,ob der Arbeitsname bereits eine korrekte Bezeichnung ist. Falls ja diesen durch das vollständige Objekt ersetzen
{
comboBoxIdentification.SelectedItem = item;
}
}
}
}
catch (ConnectionCorruptedException ex)
{
this.comboBoxIdentification.Items.Clear();
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
}
}
