/// <summary>
/// Static method to build setting arguments for a database setting helper
/// </summary>
/// <param name="commandText">The query or stored proc</param>
/// <param name="commandType">If it's a query or stored proc</param>
/// <param name="parameters">Parameters, if any</param>
/// <returns>A predefined set of args</returns>
public static IList <IIpArgument> GetDatabaseArg(string commandText, CommandType commandType, IList <IDbDataParameter> parameters)
{
var retVal = new List <IIpArgument>();
var queryArg = new IpArgument {
ArgumentKey = "commandText", ArgumentValue = commandText
};
queryArg.KeyValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(queryArg.ArgumentKey),
new IpStringValueValidator(queryArg.ArgumentKey, "commandText")
};
queryArg.ValueValidators = new List <IIpValidator>
{
new IpTypeValidator <string>(queryArg.ArgumentValue),
new IpRequiredStringValidator(queryArg.ArgumentValue)
};
var typeArg = new IpArgument {
ArgumentKey = "commandType", ArgumentValue = commandType
};
typeArg.KeyValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(typeArg.ArgumentKey),
new IpStringValueValidator(typeArg.ArgumentKey, "commandType")
};
typeArg.ValueValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(queryArg.ArgumentValue),
new IpTypeValidator <CommandType>(queryArg.ArgumentValue)
};
var paramArg = new IpArgument {
ArgumentKey = "parameters", ArgumentValue = parameters
};
paramArg.KeyValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(typeArg.ArgumentKey),
new IpStringValueValidator(typeArg.ArgumentKey, "parameters")
};
paramArg.ValueValidators = new List <IIpValidator>
{
new IpTypeValidator <IList <IDbDataParameter> >(paramArg.ArgumentValue)
};
retVal.Add(queryArg);
retVal.Add(typeArg);
retVal.Add(paramArg);
return(retVal);
}
/// <summary>
/// Static Method to Get Common App Settings Arg
/// </summary>
/// <returns>An App Settings Arg</returns>
public static IIpArgument GetStandardAppSettingArg()
{
var retVal = new IpArgument {
ArgumentKey = "ConfigSection", ArgumentValue = "appSettings"
};
retVal.KeyValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(retVal.ArgumentKey),
new IpStringValueValidator(retVal.ArgumentKey, "ConfigSection")
};
retVal.ValueValidators = new List <IIpValidator>
{
new IpStringValueValidator(retVal.ArgumentValue, "appSettings")
};
return(retVal);
}
/// <summary>
/// Static Method to Get Common Setting Value Arg
/// </summary>
/// <param name="value">The Value for the Setting Value</param>
/// <returns>A Setting Value Arg</returns>
public static IIpArgument GetStandardSettingValueArg(string value)
{
var retVal = new IpArgument {
ArgumentKey = "SettingValue", ArgumentValue = value
};
retVal.KeyValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(retVal.ArgumentKey),
new IpStringValueValidator(retVal.ArgumentKey, "SettingValue")
};
retVal.ValueValidators = new List <IIpValidator>
{
new IpRequiredStringValidator(retVal.ArgumentValue)
};
return(retVal);
}
