internal OrionDeleteQuery(OrionDatabase parentXDatabase, String tableName, String whereClause) : base(parentXDatabase) { StringBuilder strQueryString; strQueryString = new StringBuilder("DELETE FROM " + tableName); if (String.IsNullOrWhiteSpace(whereClause) == false) { whereClause = OrionQuery.TrimWhereClause(whereClause); strQueryString.Append(" WHERE " + whereClause); } this.QueryString = strQueryString.ToString(); this.QueryType = QueryTypes.Delete; this.m_xCommand = this.ParentOrionDatabase.CreateCommand(this.QueryString); }// OrionDeleteQuery()
internal OrionExecuteQuery(OrionDatabase parentXDatabase, String queryString) : base(parentXDatabase) { String[] strQueryElements; strQueryElements = queryString.Split(' '); if (strQueryElements[0].ToUpperInvariant() != "SELECT") { this.QueryString = queryString; this.QueryType = QueryTypes.Execute; this.m_xCommand = this.ParentOrionDatabase.CreateCommand(this.QueryString); } else { throw new OrionException("The SQL query should not be a SELECT one;"); } }// OrionExecuteQuery()
}// Cleanup() #endregion #region Internal methods internal static void PopulateTable(OrionDatabase sourceBase, String tableName, Boolean clearTable) { OrionInsertQuery xQueryTemp; if (clearTable == true) { sourceBase.PrepareQueryDelete(tableName).Execute(); } xQueryTemp = sourceBase.PrepareQueryInsert(tableName, "id", "titre", "nationalite", "titre_original"); foreach (StructNewRowValue xNewRowValuesTemp in Commons.NewRowValues) { xQueryTemp["id"] = xNewRowValuesTemp.Id; xQueryTemp["titre"] = xNewRowValuesTemp.Title; xQueryTemp["nationalite"] = xNewRowValuesTemp.Country; xQueryTemp["titre_original"] = xNewRowValuesTemp.OriginalTitle; xQueryTemp.Execute(); } }// PopulateTable()
internal OrionRowCountQuery(OrionDatabase parentXDatabase, String tableName, String whereClause = null) : base(parentXDatabase) { StringBuilder strQueryString; this.QueryType = QueryTypes.RowCount; strQueryString = new StringBuilder("SELECT COUNT(*) FROM " + tableName); if (String.IsNullOrWhiteSpace(whereClause) == false) { whereClause = OrionQuery.TrimWhereClause(whereClause); strQueryString.Append(" WHERE " + whereClause); } this.QueryString = strQueryString.ToString(); if (this.xDataAdapter == null) { this.xDataAdapter = this.ParentOrionDatabase.CreateDataAdapter(this.QueryString); } this.xDataAdapter.MissingMappingAction = MissingMappingAction.Passthrough; this.xDataAdapter.SelectCommand.Transaction = this.ParentOrionDatabase.Transaction; }// OrionRowCountQuery
}// OrionInsertQuery() internal OrionInsertQuery(OrionDatabase parentXDatabase, String tableName, DataRow sourceRow, params String[] exclusions) : base(parentXDatabase) { Boolean bExcluded; StringBuilder strQueryString, strColumns, strValues; strQueryString = new StringBuilder("INSERT INTO " + tableName); strColumns = new StringBuilder("("); strValues = new StringBuilder("VALUES ("); if (sourceRow != null) { foreach (DataColumn xColumnTemp in sourceRow.Table.Columns) { bExcluded = false; if (exclusions != null) { foreach (String strExclusionTemp in exclusions) { if (strExclusionTemp == xColumnTemp.ColumnName) { bExcluded = true; break; } } } if (bExcluded == false) { strColumns.Append(xColumnTemp.ColumnName + ","); strValues.Append(this.ParentOrionDatabase.ParameterCharacter + xColumnTemp.ColumnName + ","); } } strQueryString.Append(" " + strColumns.ToString().Trim(',') + ")"); strQueryString.Append(" " + strValues.ToString().Trim(',') + ")"); this.QueryString = strQueryString.ToString(); this.QueryType = QueryTypes.Insert; this.SQLCommand = this.ParentOrionDatabase.CreateCommand(this.QueryString); this.SQLCommand.Transaction = this.ParentOrionDatabase.Transaction; foreach (DataColumn xColumnTemp in sourceRow.Table.Columns) { bExcluded = false; foreach (String strExclusionTemp in exclusions) { if (strExclusionTemp == xColumnTemp.ColumnName) { bExcluded = true; break; } } if (bExcluded == false) { this.AddParameter(xColumnTemp.ColumnName, sourceRow[xColumnTemp.ColumnName]); } } } }// OrionInsertQuery()
protected OrionQuery(OrionDatabase parentOrionDatabase) { this.ParentOrionDatabase = parentOrionDatabase; }// OrionQuery()