/// <summary>
/// Make stored procedure param.
/// </summary>
/// <param name="ParamName">Name of param.</param>
/// <param name="DbType">Param type.</param>
/// <param name="Size">Param size.</param>
/// <param name="Direction">Parm direction.</param>
/// <param name="Value">Param value.</param>
/// <returns>New parameter.</returns>
public static NpgsqlParameter MakeParam(string ParamName, NpgsqlTypes.NpgsqlDbType DbType, Int32 Size, object Value)
{
NpgsqlParameter param;
if (Size > 0)
param = new NpgsqlParameter(ParamName, DbType, Size);
else
param = new NpgsqlParameter(ParamName, DbType);
param.Direction = ParameterDirection.Input;
param.Value = Value;
return param;
}
/// <summary>
/// Make stored procedure param.
/// </summary>
/// <param name="ParamName">Name of param.</param>
/// <param name="DbType">Param type.</param>
/// <param name="Size">Param size.</param>
/// <param name="Direction">Parm direction.</param>
/// <param name="Value">Param value.</param>
/// <returns>New parameter.</returns>
public static NpgsqlParameter MakeParam(string ParamName, NpgsqlTypes.NpgsqlDbType DbType, Int32 Size, ParameterDirection Direction, object Value)
{
NpgsqlParameter param;
if (Size > 0)
param = new NpgsqlParameter(ParamName, DbType, Size);
else
param = new NpgsqlParameter(ParamName, DbType);
param.Direction = Direction;
if (!(Direction == ParameterDirection.Output && Value == null))
param.Value = Value;
return param;
}
public void AddParameter(string name, object value, NpgsqlTypes.NpgsqlDbType npgsqlDbType, ParameterDirection direccion)
{
if (_npgsqlCommand == null)
{
throw new Exception("Command not initialized.");
}
NpgsqlParameter parametro = new NpgsqlParameter();
parametro.ParameterName = name;
parametro.NpgsqlDbType = npgsqlDbType;
parametro.Value = value;
parametro.Direction = direccion;
_npgsqlCommand.Parameters.Add(parametro);
}
public TypeValuePair(NpgsqlTypes.NpgsqlDbType a, string value)
{
this.valueType = a;
this.value = value;
}
/// <summary>
/// Initializes a new instance of the <see cref="SettingsPropertyColumn"/> class.
/// </summary>
/// <param name="settings">
/// The settings.
/// </param>
/// <param name="dataType">
/// The data type.
/// </param>
/// <param name="size">
/// The size.
/// </param>
public SettingsPropertyColumn(SettingsProperty settings, NpgsqlTypes.NpgsqlDbType dataType, int size)
{
this.DataType = dataType;
this.Settings = settings;
this.Size = size;
}
public void __AddProfileColumn( string Name, NpgsqlTypes.NpgsqlDbType columnType, int size)
{
// get column type...
string type = columnType.ToString();
if ( size > 0 )
{
type += "(" + size.ToString() + ")";
}
string sql = String.Format( @"ALTER TABLE {0} ADD {1} {2} ", MsSqlDbAccess.GetObjectName( "prov_profile" ), Name, type );
using ( NpgsqlCommand cmd = new NpgsqlCommand( sql ) )
{
cmd.CommandType = CommandType.Text;
_dbAccess.ExecuteNonQuery(cmd);
}
}
public static bool GetDbTypeAndSizeFromString(string providerData, out NpgsqlTypes.NpgsqlDbType dbType, out int size)
{
return LegacyDb.GetDbTypeAndSizeFromString(providerData, out dbType, out size);
}
