public DataTable ExecuteQuery(string sql, ParameterPair[] param)
{
DataTable table = new DataTable();
try
{
SqlCommand command = new SqlCommand(sql, _sqlconnection);
SqlParameter p;
for (int i = 0; i < param.Length; i++)
{
ParameterPair pp = param[i];
p = new SqlParameter(pp.ParameterName, pp.Value);
command.Parameters.Add(p);
}
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(table);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
return(table);
}
public static IList <ParameterPair> GetParameters(IConfigurable configurable)
{
if (!configurable.Properties.ContainsKey(GraphConst.Properties.Parameters))
{
return(new List <ParameterPair>());
}
var result = new List <ParameterPair>();
var joinedParams = configurable.Properties[GraphConst.Properties.Parameters];
return(joinedParams.Split(new[] { GraphConst.Properties.PropertyValuesSeparator }, StringSplitOptions.None)
.Select(complexValue =>
{
var simpleValues = complexValue.Split(new[] { GraphConst.Properties.PropertyComplexValueSeparator }, StringSplitOptions.None);
if (simpleValues.Count() < 2)
{
throw new ApplicationException($"Parameters list is malformed!");
}
var parameterPair = new ParameterPair()
{
Type = simpleValues[0],
Name = simpleValues[1]
};
return parameterPair;
})
.ToList());
}
private static Parameter ConvertToParameter(ParameterPair parameterPair)
{
return(new Parameter()
{
Type = TypeName.CreateTypeName(parameterPair.Type),
Name = parameterPair.Name
});
}
protected override IParameterDicConverter setupParamDicConverter()
{
return(ParameterDicConverters.ConvertVMParameter(
AddVariable.FromGetter("{WindowManager}", (pms) => _evm.WindowManager),
AddVariable.FromGetter("{Events}", (pms) => _evm.InternalEvents),
AddVariable.FromGetter("{GlobalEvents}", (pms) => _evm.Events),
AddVariable.FromParameterPairs(
ParameterPair.FromVariable("{Explorer}", _evm),
ParameterPair.FromVariable("{DirectoryTree}", _evm.DirectoryTree),
ParameterPair.FromVariable("{FileList}", _evm.FileList),
ParameterPair.FromVariable("{Statusbar}", _evm.Statusbar)
)));
//return ParameterDicConverters.ConvertVMParameter(
// new Tuple<string, object>("Explorer", _evm),
// new Tuple<string, object>("DirectoryTree", _evm.DirectoryTree),
// new Tuple<string, object>("FileList", _evm.FileList),
// new Tuple<string, object>("Statusbar", _evm.Statusbar),
// new Tuple<string, object>("WindowManager", _windowManager),
// new Tuple<string, object>("Events", _events),
// new Tuple<string, object>("GlobalEvents", _globalEvents)
// );
}
