public object GetDynamicParameters()
{
if (SmoContext.IsSet && SmoContext.IsConnected && _dynLib == null)
{
if (SmoContext.GetNullOrEmpty(SmoContext.Jobs))
{
SmoContext.SetJobs(SmoContext.Connection.JobServer.Jobs);
}
_dynLib = new DynamicLibrary();
var dp = new DynamicParameter <Microsoft.SqlServer.Management.Smo.Agent.Job>("JobName", SmoContext.Jobs, x => x.Name, "Name", true)
{
Position = 0,
Mandatory = false,
ParameterSetName = "ByJobName"
};
_dynLib.Add(dp);
}
else if (_dynLib == null)
{
_dynLib = new DynamicLibrary();
_dynLib.Add("JobName", new RuntimeDefinedParameter("JobName", typeof(string[]), new Collection <Attribute>
{
new ParameterAttribute
{
Mandatory = false,
Position = 0,
ParameterSetName = "ByJobName"
}
}));
}
return(_dynLib);
}
public object GetDynamicParameters()
{
if (_dynLib == null)
{
_dynLib = new DynamicLibrary();
DynamicParameter <Assembly> dp = null;
RuntimeDefinedParameter rtParam = null;
Assembly[] Assemblies = AppDomain.CurrentDomain.GetAssemblies();
if (!Scope.Equals("File"))
{
dp = new DynamicParameter <Assembly>(PNAME, Assemblies, x => x.FullName, "FullName")
{
Mandatory = false
};
rtParam = dp.AsRuntimeParameter();
}
else
{
var pAtt = new ParameterAttribute
{
Mandatory = true
};
rtParam = new RuntimeDefinedParameter(PNAME, PTYPE, new Collection <Attribute>
{
pAtt
});
}
_dynLib.Add(PNAME, rtParam);
}
return(_dynLib);
}
public void dpCheckedChanged(object sender, EventArgs e)
{
switch (sender.GetType().ToString())
{
case "System.Windows.Forms.CheckBox":
CheckBox cb = (CheckBox)sender;
DynamicParameter dp_cb = (DynamicParameter)cb.Tag;
if (!dp_cb.IsInitializing)
{
dp_cb.ParameterValue = cb.Checked.ToString();
}
SetGoButtonStatus(GetSelectedActionItem(dp_cb.ActionItemID));
break;
case "System.Windows.Forms.RadioButton":
RadioButton rb = (RadioButton)sender;
DynamicParameter dp_rb = (DynamicParameter)rb.Tag;
if (!dp_rb.IsInitializing)
{
dp_rb.ParameterValue = rb.Checked.ToString();
}
SetGoButtonStatus(GetSelectedActionItem(dp_rb.ActionItemID));
break;
default:
break;
}
}
public static void AndInStringsCondition(
StringBuilder condition,
DynamicParameter parameters,
string name,
string valueName,
params string[] values)
{
condition.Append($" AND {name} IN (");
var index = 1;
foreach (var value in values)
{
if (!String.IsNullOrEmpty(value))
{
var parameterName = $"{valueName}{index}";
condition.Append($"@{parameterName}, ");
parameters.Add(parameterName, value);
index++;
}
}
if (index == 1)
{
condition.Length -= 10 + name.Length;
}
else
{
condition.Length -= 2;
condition.Append(')');
}
}
public void Should_Get_From_Cache()
{
var(cacheManager, dynamicParameterStoreSubstitute, cacheSubstitute) = InitializeFakes();
var testDynamicParameter = new DynamicParameter
{
Id = -1,
ParameterName = "Test123",
InputType = "TestType"
};
cacheSubstitute
.Get(testDynamicParameter.Id.ToString(), Arg.Any <Func <string, object> >())
.Returns(testDynamicParameter);
var dynamicParameterManager = Resolve <IDynamicParameterManager>();
var entity = dynamicParameterManager.Get(testDynamicParameter.Id);
CheckEquality(entity, testDynamicParameter);
cacheManager.Received().GetCache(Arg.Any <string>());
cacheSubstitute.Received().Get(testDynamicParameter.Id.ToString(), Arg.Any <Func <string, object> >());
dynamicParameterStoreSubstitute.DidNotReceive().Get(testDynamicParameter.Id);
}
private void CheckEquality(DynamicParameter p1, DynamicParameter p2)
{
p1.ShouldNotBeNull();
p2.ShouldNotBeNull();
p1.Id.ShouldBe(p2.Id);
p1.ParameterName.ShouldBe(p2.ParameterName);
p1.InputType.ShouldBe(p2.InputType);
}
public DynamicParameter Get(DynamicParameterType parameterType, DynamicParameterData data, int level)
{
DynamicParameter parameter = CreateParameter(parameterType, level, data);
parameter.SetCalculators(GetProgressionCalculator(data.Parameter.progressionType), GetProgressionCalculator(data.Price.progressionType));
return(parameter);
}
public void dpNumericUpDownValueChanged(object sender, EventArgs e)
{
NumericUpDown nud = (NumericUpDown)sender;
DynamicParameter dp_nud = (DynamicParameter)nud.Tag;
if (!dp_nud.IsInitializing)
{
dp_nud.ParameterValue = nud.Value.ToString();
}
SetGoButtonStatus(GetSelectedActionItem(dp_nud.ActionItemID));
}
public DynamicParameter Get(DynamicParameterType parameterType)
{
int level = m_dynamicParametersLevels[(int)parameterType];
DynamicParameterData data = m_cityData.GetDynamicParameterData(parameterType);
DynamicParameter parameter = CreateParameter(parameterType, level, data);
parameter.SetCalculators(GetProgressionCalculator(data.Parameter.progressionType), GetProgressionCalculator(data.Price.progressionType));
return(parameter);
}
public void Initialize(CurrencyType currencyType, DynamicParameter dynamicParameter, Sprite walletSprite, string format)
{
m_upgradesCount = 0;
m_currencyType = currencyType;
m_dynamicParameter = dynamicParameter;
m_walletImage.sprite = walletSprite;
m_valueFormat = format;
}
public void dpDTPickerValueChanged(object sender, EventArgs e)
{
DateTimePicker dtp = (DateTimePicker)sender;
DynamicParameter dp_dtp = (DynamicParameter)dtp.Tag;
if (!dp_dtp.IsInitializing)
{
dp_dtp.ParameterValue = dtp.Value.ToString();
}
SetGoButtonStatus(GetSelectedActionItem(dp_dtp.ActionItemID));
}
public void dpTextBoxTextChanged(object sender, EventArgs e)
{
TextBox tb = (TextBox)sender;
DynamicParameter dp_tb = (DynamicParameter)tb.Tag;
if (!dp_tb.IsInitializing)
{
dp_tb.ParameterValue = tb.Text;
}
SetGoButtonStatus(GetSelectedActionItem(dp_tb.ActionItemID));
}
protected private DynamicLibrary NewDynamicLibrary(MgSmoCollection <Database> dbCol)
{
var dl = new DynamicLibrary();
var dp = new DynamicParameter <Database>(BaseDatabaseCmdlet.DBNAME, SmoContext.Databases, x => x.Name, "Name", true)
{
Mandatory = true
};
dl.Add(dp);
return(dl);
}
private float GetTimeOfDrawingOnePixel()
{
DynamicParametersManager dynamicParametersManager = DynamicParametersManager.Instance;
DynamicParameter sprayCapacity = dynamicParametersManager.Get(DynamicParameterType.SprayBottleCapacity);
//TODO вынести в константу
float runningTime = 5 / dynamicParametersManager.Get(DynamicParameterType.RunningSpeed).Value;
float drawingTime = (dynamicParametersManager.Get(DynamicParameterType.DrawingSpeed).Value *sprayCapacity.Value) / sprayCapacity.FirstValue;
float sprayCoast = sprayCapacity.Value / sprayCapacity.FirstValue;
return((runningTime + drawingTime) / sprayCoast);
}
public object GetDynamicParameters()
{
_dynLib = new DynamicLibrary();
Server s = this.SqlServer == null && SmoContext.IsSet && SmoContext.IsConnected
? SmoContext.Connection
: this.SqlServer;
var dp = new DynamicParameter <string>("DefaultDatabase", typeof(string), s.Databases.Cast <Database>().Select(x => x.Name));
_dynLib.Add(dp);
return(_dynLib);
}
public object GetDynamicParameters()
{
_lib = new DynamicLibrary();
if (Context.IsConnected)
{
var idp = new DynamicParameter <Tag>(PARAM, true, Context.TagManager.AllTags, x => x.Label)
{
Mandatory = false
};
_lib.Add(idp);
}
return(_lib);
}
private void LoadMultiSelectionParameterAndDisplayValues(DynamicParameter dp)
{
// this method loads a readonly/display-only listbox of items the user has selected from a larger list
StringBuilder sbParameterlist = new StringBuilder();
StringBuilder sbDisplayList = new StringBuilder();
List <ListObject> loList = dp.SelectedQueryDataListObjects;
if (dp.MultiSelectionDisplayListBox != null)
{
dp.MultiSelectionDisplayListBox.Items.Clear();
}
for (int i = 0; i <= loList.Count - 1; i++)
{
ListObject lo = loList.ElementAt(i);
if (dp.MultiSelectionDisplayListBox != null)
{
dp.MultiSelectionDisplayListBox.Items.Add(lo);
}
if (i < loList.Count - 1)
{
switch (dp.DataTypeID)
{
case ((int)Enums.DataTypes.Int):
sbParameterlist.Append(lo.IDValue.ToString() + ",");
break;
default:
sbParameterlist.Append(lo.DisplayValue + ",");
break;
}
sbDisplayList.Append(lo.DisplayValue + ", ");
}
else
{
switch (dp.DataTypeID)
{
case ((int)Enums.DataTypes.Int):
sbParameterlist.Append(lo.IDValue.ToString());
break;
default:
sbParameterlist.Append(lo.DisplayValue);
break;
}
sbDisplayList.Append(lo.DisplayValue);
}
}
dp.ParameterValue = sbParameterlist.ToString();
dp.ParameterValueDisplayValue = sbDisplayList.ToString();
}
public DynamicParameter Get(DynamicParameterType type)
{
DynamicParameter parameter = default;
for (int i = 0; i < m_dynamicParameters.Count; i++)
{
if (m_dynamicParameters[i].ParameterType == type)
{
return(m_dynamicParameters[i]);
}
}
return(parameter);
}
public object GetDynamicParameters()
{
_lib = new DynamicLibrary();
if (Context.IsConnected)
{
var idp = new DynamicParameter <IndexerSchema>(PARAM, true, Context.IndexerSchemas, x => x.Name)
{
Mandatory = true,
Position = 0
};
_lib.Add(idp);
}
return(_lib);
}
public void Debug()
{
for (int i = 0; i < m_dynamicParameters.Count; i++)
{
DynamicParameter dynamicParameter =
GetDynamicParameter(m_dynamicParameters[i].type, m_dynamicParameters[i]);
for (int level = 1; level < 20; level++)
{
dynamicParameter.SetLevel(level);
dynamicParameter.SetCalculators(GetProgressionCalculator(m_dynamicParameters[i].Parameter.progressionType), GetProgressionCalculator(m_dynamicParameters[i].Price.progressionType));
UnityEngine.Debug.Log($"{dynamicParameter.ParameterType} - Level: {level}, Value: {dynamicParameter.Value}, Price: {dynamicParameter.Price}");
}
}
}
public object GetDynamicParameters()
{
if (_dynLib == null)
{
_dynLib = new DynamicLibrary();
var dp = new DynamicParameter <string>("Collation", typeof(string))
{
AllowNull = true,
Mandatory = false
};
dp.ValidatedItems.AddRange(SmoContext.ServerCollations);
_dynLib.Add(dp);
}
return(_dynLib);
}
public virtual object GetDynamicParameters()
{
if (_info == null)
{
_info = Encoding.GetEncodings();
}
_dynLib = new DynamicLibrary();
var dp = new DynamicParameter <EncodingInfo>(ENCODING, _info, x => x.Name, "Name")
{
Mandatory = false,
Position = 1
};
_dynLib.Add(dp);
return(_dynLib);
}
public static void AndNameCondition(
StringBuilder condition,
DynamicParameter parameters,
string column,
string name,
object value,
string op = "=")
{
condition.Append(" AND ");
condition.Append(column);
condition.Append(' ');
condition.Append(op);
condition.Append(" @");
condition.Append(name);
parameters.Add(name, value);
}
protected DynamicParameter CreateAndGetDynamicParameterWithTestPermission()
{
var rnd = new Random();
var dynamicParameter = new DynamicParameter()
{
InputType = GetRandomAllowedInputType(),
ParameterName = "City" + rnd.Next(),
Permission = TestPermission,
TenantId = AbpSession.TenantId
};
WithUnitOfWork(() =>
{
DynamicParameterStore.Add(dynamicParameter);
});
return(dynamicParameter);
}
public void Should_Add_And_Change_Cache()
{
var(cacheManager, dynamicParameterStoreSubstitute, cacheSubstitute) = InitializeFakes();
var dynamicParameterManager = Resolve <IDynamicParameterManager>();
var testDynamicParameter = new DynamicParameter
{
ParameterName = "Test123",
InputType = GetRandomAllowedInputType()
};
dynamicParameterManager.Add(testDynamicParameter);
cacheSubstitute.Received()
.Set(testDynamicParameter.Id.ToString(), testDynamicParameter, Arg.Any <TimeSpan?>(), Arg.Any <TimeSpan?>());
dynamicParameterStoreSubstitute.Received().Add(testDynamicParameter);
}
public static void AndStringCondition(
StringBuilder condition,
DynamicParameter parameters,
string column,
string value,
string op = "=")
{
if (!String.IsNullOrEmpty(value))
{
condition.Append(" AND ");
condition.Append(column);
condition.Append(' ');
condition.Append(op);
condition.Append(" @");
condition.Append(column);
parameters.Add(column, value);
}
}
public override object GetDynamicParameters()
{
if (_dynLib == null && (this.SqlServer != null || (SmoContext.IsSet && SmoContext.IsConnected)))
{
Server s = this.SqlServer != null
? this.SqlServer
: SmoContext.Connection;
_dynLib = new DynamicLibrary();
var dp = new DynamicParameter <Database>("Database", s.Databases.Cast <Database>(), x => x.Name, "Name", true)
{
Mandatory = false
};
_dynLib.Add(dp);
}
return(_dynLib);
}
public object GetDynamicParameters()
{
if (_dynLib == null)
{
if (AllProps == null)
{
AllProps = this.GetPropsToLoad();
}
_dynLib = new DynamicLibrary();
var dp = new DynamicParameter <string>(PROPERTIES, AllProps, x => x, null, true)
{
Mandatory = false
};
dp.ValidatedItems.Add("*");
_dynLib.Add(dp);
}
return(_dynLib);
}
public static void AndNullableCondition <T>(
StringBuilder condition,
DynamicParameter parameters,
string column,
T?value,
string op = "=")
where T : struct
{
if (value.HasValue)
{
condition.Append(" AND ");
condition.Append(column);
condition.Append(' ');
condition.Append(op);
condition.Append(" @");
condition.Append(column);
parameters.Add(column, value);
}
}
public void Should_Not_Add_If_Input_Type_Is_Not_Exists()
{
var testDynamicParameter = new DynamicParameter
{
ParameterName = "Test123",
InputType = "asd123"
};
var dynamicParameterManager = Resolve <IDynamicParameterManager>();
try
{
dynamicParameterManager.Add(testDynamicParameter);
throw new Exception("Should check if input type exists");
}
catch (Exception e)
{
e.Message.ShouldContain("asd123");
}
}
public virtual void AddParameter(DynamicParameter parameter)
{
Parameters.Add(new DynamicParameterDescriptor(this, parameter.Name, parameter.Type));
}
