/// <summary>
/// Executes ExecuteNonQuery function
/// </summary>
/// <param name="spName">SQL String or stored procedure name</param>
/// <returns>integer value</returns>
internal int ExecuteNonQuery(string spName)
{
wlParameterCollection obj = this.AddParameterCollection(this.Parameters);
int intRetVal = wlData.ExecuteNonQuery(ConnectionStringName, CommandType.StoredProcedure, spName, obj);
_errorCode = wlData.ErrorCode;
return(intRetVal);
}
/// <summary>
/// Executes ExecuteDataSet function
/// </summary>
/// <param name="spName">SQL String or stored procedure name</param>
/// <returns>return DataSet</returns>
internal DataSet ExecuteDataSet(string spName)
{
wlParameterCollection obj = this.AddParameterCollection(this.Parameters);
DataSet ds = wlData.ExecuteDataset(ConnectionStringName, CommandType.StoredProcedure, spName, obj);
_errorCode = wlData.ErrorCode;
return(ds);
}
/// <summary>
/// Executes ExecuteScalar function
/// </summary>
/// <param name="spName">SQL String or stored procedure name</param>
/// <returns>string value</returns>
internal string ExecuteScalar(string spName)
{
string strRetVal;
wlParameterCollection obj = this.AddParameterCollection(this.Parameters);
strRetVal = wlData.ExecuteScalar(ConnectionStringName, CommandType.StoredProcedure, spName, obj).ToString();
_errorCode = wlData.ErrorCode;
return(strRetVal);
}
/// <summary>
/// Handles the communication with the database, Constructs the list and returns to the calling layer
/// </summary>
/// <param name="spName">SQL String or stored procedure name</param>
/// <param name="dbParameter">array of Dbparameter</param>
/// <returns>Returns the List of the entity</returns>
internal IDataReader Execute(string spName, DbParameter[] dbParameter)
{
wlParameterCollection obj = this.AddParameterCollection(dbParameter);
IDataReader idr = wlData.ExecuteReader(ConnectionStringName, CommandType.StoredProcedure, spName, obj);
_errorCode = wlData.ErrorCode;
return(idr);
}
/// <summary>
/// Add parameters to wlParameterCollection Class
/// </summary>
/// <param name="dbParam">array of Dbparameter</param>
/// <returns>return wlParameterCollection</returns>
private wlParameterCollection AddParameterCollection(DbParameter[] dbParam)
{
wlParameterCollection obj = new wlParameterCollection();
SqlParameter p;
foreach (DbParameter d in dbParam)
{
p = new SqlParameter();
p.ParameterName = d.ParameterName;
p.Direction = d.Direction;
p.Value = d.Value;
p.Size = d.Size;
p.DbType = d.DbType;
obj.Add(p);
}
return(obj);
}
