/// <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); }