internal int AddParameter(string name, object value, DBEnum.StoredProcedureParameterDirection parameterDirection)
{
DbParameter parameter = objFactory.CreateParameter();
parameter.ParameterName = name;
parameter.Value = value;
parameter.DbType = DbType.String;
parameter.Size = 50;
switch (parameterDirection)
{
case DBEnum.StoredProcedureParameterDirection.Input:
parameter.Direction = System.Data.ParameterDirection.Input;
break;
case DBEnum.StoredProcedureParameterDirection.Output:
parameter.Direction = System.Data.ParameterDirection.Output;
break;
case DBEnum.StoredProcedureParameterDirection.InputOutput:
parameter.Direction = System.Data.ParameterDirection.InputOutput;
break;
case DBEnum.StoredProcedureParameterDirection.ReturnValue:
parameter.Direction = System.Data.ParameterDirection.ReturnValue;
break;
}
return(objCommand.Parameters.Add(parameter));
}
public int AddParameter(string name, object value, DBEnum.StoredProcedureParameterDirection parameterDirection, int size, DbType dbType)
{
return(databaseHelper.AddParameter(name, value, parameterDirection, size, dbType));
}
public int AddParameter(string name, DBEnum.StoredProcedureParameterDirection parameterDirection)
{
return(databaseHelper.AddParameter(name, parameterDirection));
}
