void SetupControl()
{
switch (_type)
{
case FieldType.text:
textBox1.Visible = true;
break;
case FieldType.number:
textBox1.Visible = true;
break;
case FieldType.dropdown:
comboBox1.Visible = true;
IList <ComboBoxObject> items;
items = ComboBoxObject.LoadFromQuery(_query);
comboBox1.DisplayMember = "Text";
comboBox1.ValueMember = "Value";
comboBox1.DataSource = items;
break;
case FieldType.checkbox:
checkBox1.Visible = true;
break;
default:
textBox1.Visible = true;
break;
}
}
private void listModule()
{
ctxEdit.Enabled = false;
tsbEdit.Enabled = false;
ctxDelete.Enabled = false;
tsbDelete.Enabled = false;
var stats = ComboBoxObject.LoadFromQuery("SELECT [FK_MODULE_ID] as Value,cast(ROUND(cast(sum([ACTIVITY_TIME]) as float)/3600,2) as nvarchar) + 'h ('+cast(ROUND((cast(sum([ACTIVITY_TIME]) as float)/cast(sum([OPENED_TIME]) as float))*100,1) as nvarchar)+'%) - ' + CAST(COUNT(Distinct FORMNAME) as nvarchar) + ' Forms - ' + cast(COUNT(DISTINCT USERID) as nvarchar) + ' Users' as Text FROM [SYNAPSE].[dbo].[Synapse_Statistics] GROUP BY FK_MODULE_ID");
usage.Clear();
foreach (ComboBoxObject stat in stats)
{
usage.Add(stat.Value, stat.Text);
}
modules = SynapseModule.Load();
foreach (SynapseModule module in modules)
{
if (File.Exists(Application.StartupPath + "\\ModulesIcons\\" + module.TECHNICALNAME + ".ico"))
{
LargeImageList.Images.Add(module.TECHNICALNAME, Image.FromFile(Application.StartupPath + "\\ModulesIcons\\" + module.TECHNICALNAME + ".ico"));
}
else
{
LargeImageList.Images.Add(module.TECHNICALNAME, Image.FromFile(Application.StartupPath + "\\ModulesIcons\\Default.png"));
}
}
olvModules.SetObjects(modules.OrderBy(x => x.FriendlyName.ToString()).ToList());
}
private static void GenerateDBFields()
{
var DBFields = ComboBoxObject.LoadFromQuery("select (T.TABLE_NAME+'.'+C.COLUMN_NAME) as Text,C.COLUMN_NAME as Value from INFORMATION_SCHEMA.TABLES T inner join INFORMATION_SCHEMA.COLUMNS C on T.TABLE_NAME=C.TABLE_NAME;");
foreach (ComboBoxObject field in DBFields)
{
string translated = string.Empty;
if (!dic["Default"].ContainsKey(field.Text.ToUpperInvariant()))
{
dic["Default"].Add(field.Text.ToUpperInvariant(), field.Value.ToString().ToUpperInvariant());
Console.WriteLine("...adding " + field.Text.ToUpperInvariant() + " with value:" + field.Value.ToString().ToUpperInvariant());
}
foreach (SynapseLanguage lang in Languages)
{
if (!dic[lang.CULTURE].ContainsKey(field.Text.ToUpperInvariant()))
{
dic[lang.CULTURE].Add(field.Text.ToUpperInvariant(), field.Value.ToString().ToUpperInvariant());
Console.WriteLine("...adding " + field.Text.ToUpperInvariant() + " with value:" + field.Value.ToString().ToUpperInvariant());
}
}
}
}
