private object SelectValue(ColumnInfo.ColumnTypeInfo.TypeClasses colClass, string colType)
{
object val = null;
switch (colClass)
{
case ColumnInfo.ColumnTypeInfo.TypeClasses.Boolean:
{
val = _boolVal.SelectedItem as string == "True";
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.DateTime:
{
val = FormatDateTimeVal(colType);
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Floating:
{
val = double.Parse(_valTextBox.Text);
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Integer:
{
val = long.Parse(_valTextBox.Text);
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Text:
{
val = _valTextBox.Text;
break;
}
}
return(val);
}
private void SetNewHandler(ColumnInfo.ColumnTypeInfo.TypeClasses newColClass, string colType, ColumnInfo col)
{
Control newControl = null;
if (newColClass == ColumnInfo.ColumnTypeInfo.TypeClasses.Floating || newColClass == ColumnInfo.ColumnTypeInfo.TypeClasses.Integer || newColClass == ColumnInfo.ColumnTypeInfo.TypeClasses.Text)
{
var values = new List <string>();
_valTextBox.Items.Clear();
using (var connection = new SqlConnection(ConfigurationManager
.ConnectionStrings[ConnStrName]
.ConnectionString))
{
connection.Open();
var command = new SqlCommand($"SELECT [{col.RealName}] FROM [{col.TableName}]", connection);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
_valTextBox.Items.Add(reader[col.RealName].ToString());
}
}
}
}
switch (newColClass)
{
case ColumnInfo.ColumnTypeInfo.TypeClasses.Boolean:
{
newControl = _boolVal;
addCondButton.Enabled = true;
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.DateTime:
{
newControl = _dateVal;
SetDateTimeFormat(colType);
addCondButton.Enabled = true;
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Floating:
{
newControl = _valTextBox;
_valTextBox.TextChanged += FloatTextBoxChanged;
addCondButton.Enabled = false;
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Integer:
{
newControl = _valTextBox;
_valTextBox.TextChanged += IntTextBoxChanged;
addCondButton.Enabled = false;
break;
}
case ColumnInfo.ColumnTypeInfo.TypeClasses.Text:
{
newControl = _valTextBox;
_valTextBox.TextChanged += TextTextBoxValChanged;
addCondButton.Enabled = false;
break;
}
}
critPropsPanel.Controls.Add(newControl, 5, 1);
}
