/// <summary>
/// Add parameters into a SqlDataAccessParameter object and add that to the list. Size and Precision are assigned a 0
/// value.
/// </summary>
/// <param name="name">Gets added to Name property</param>
/// <param name="dbType">Gets added to DataType property</param>
/// <param name="oValue">Gets added to Value property</param>
public void Add(string name, SqlDbType dbType, object oValue)
{
SqlDataAccessParameter dto = new SqlDataAccessParameter();
dto.Name = name;
dto.DataType = dbType;
dto.Size = 0;
dto.Precision = 0;
dto.ObjectValue = oValue;
Add(dto);
}
/// <summary>
/// Add parameters into a SqlDataAccessParameter object and add that to the list. Precision is assigned a 0 value.
/// </summary>
/// <param name="name">Gets added to Name property</param>
/// <param name="dbType">Gets added to DataType property</param>
/// <param name="size">Gets added to Size property</param>
/// <param name="value">Gets added to Value property</param>
public void Add(string name, SqlDbType dbType, int size, string value)
{
SqlDataAccessParameter dto = new SqlDataAccessParameter();
dto.Name = name;
dto.DataType = dbType;
dto.Size = size;
dto.Precision = 0;
dto.Value = value;
Add(dto);
}
/// <summary>
/// Gets data from stored procedure with one parameter
/// </summary>
/// <param name="parameter">Single parameter to send to database</param>
/// <param name="procedureName">Stored procedure to call</param>
/// <returns>DtoDataSet filled with data from database</returns>
public DtoDataSet GetData(SqlDataAccessParameter parameter, string procedureName)
{
return(GetData(new[] { parameter }, procedureName));
}
/// <summary>
/// Adds SqlDataAccessParameter to SqlDataAccessParameter List
/// </summary>
/// <param name="dtoParam">SqlDataAccessParameter to add</param>
public void Add(SqlDataAccessParameter dtoParam)
{
_ColParameters.Add(dtoParam);
}
