string FindSREKeyUsingName(List <SreKey> keys, SreKeyTypes sreKeyType)
{
SreKey key = (from e in keys
where e.Name == sreKeyType.ToString()
select e).SingleOrDefault();
return(key != null ? key.Value : string.Empty);
}
public static bool IsConnectionStringType(this SreKeyTypes type)
{
if ((type == SreKeyTypes.ConnectionStringOracle) ||
(type == SreKeyTypes.ConnectionStringSqlCe) ||
(type == SreKeyTypes.ConnectionStringSqlServer) ||
(type == SreKeyTypes.ConnectionStringDB2iSeries))
{
return(true);
}
return(false);
}
public static string GetKeyValue(this List <SreKey> keys, SreKeyTypes keyType)
{
SreKey srekey = (from k in keys
where k.Name == keyType.ToString()
select k).SingleOrDefault();
if (srekey == null)
{
return(string.Empty);
}
return(string.IsNullOrEmpty(srekey.Value) ? string.Empty : srekey.Value);
}
void BindData()
{
lstvwKeys.Items.Clear();
foreach (SreKey key in _Keys)
{
ListViewItem item = new ListViewItem(key.Name);
item.SubItems.Add(key.Value);
SreKeyTypes keytype = (SreKeyTypes)key.Type;
item.SubItems.Add(keytype.ToString());
item.SubItems.Add(key.Type.ToString());
item.Checked = key.IsDefault == true?true:false;
lstvwKeys.Items.Add(item);
}
}
public static DatabaseTypes GetDatabaseType(this SreKey key)
{
SreKeyTypes sreKeyType = (SreKeyTypes)key.Type;
switch (sreKeyType)
{
case SreKeyTypes.ConnectionStringSqlServer:
return(DatabaseTypes.SqlServer);
case SreKeyTypes.ConnectionStringOracle:
return(DatabaseTypes.Oracle);
case SreKeyTypes.ConnectionStringDB2iSeries:
return(DatabaseTypes.DB2iSeries);
case SreKeyTypes.ConnectionStringSqlCe:
return(DatabaseTypes.SqlCe);
default:
throw new Exception(sreKeyType.ToString() + " is not database type key!");
}
}
