Example #1
0
 /// <summary>
 /// This method overloads the base class method to support DAS specific properties.
 /// </summary>
 /// <param name="table">Table to be merged.</param>
 /// <param name="preserveChanges"><c>True</c> means all changes are preserved.</param>
 /// <param name="missingSchemaAction"><seealso cref="System.Data.MissingSchemaAction"></seealso></param>
 public void Merge(DASDataTable table, bool preserveChanges, MissingSchemaAction missingSchemaAction)
 {
     base.Merge(table, preserveChanges, missingSchemaAction);
     foreach (DASDataRow row in table.Rows)
     {
         var _with1 = Rows.ItemByDBKey(row.DBKey);
         _with1.SQL = row.SQL;
     }
 }
Example #2
0
        /// <summary>
        /// This function checks whether the row does exists in the database.
        /// </summary>
        /// <returns><c>True</c>, if row exists.</returns>
        public bool ExistsInDB()
        {
            bool           ReturnValue   = false;
            var            stringBuilder = new StringBuilder();
            var            TableDAS      = Table.DAS;
            DataRowVersion rowVersion;

            var dataTable = new DASDataTable(TableDAS)
            {
                DBTableName = Table.DBTableName
            };

            switch (RowState)
            {
            case DataRowState.Added:
                rowVersion = DataRowVersion.Current;
                break;

            case DataRowState.Detached:
                rowVersion = DataRowVersion.Default;
                break;

            default:
                rowVersion = DataRowVersion.Original;
                break;
            }

            long i = 1;

            foreach (DASDataColumn column in Table.PrimaryKey)
            {
                switch (column.DASDataType)
                {
                case DASDataColumn.DASDataTypes.DASDATE:
                    TableDAS.AddParameter(string.Format("@P{0}", i), this[column, rowVersion], DAS.ParameterModes.PARM_IN, DAS.ServerTypes.ST_DATE);
                    break;

                case DASDataColumn.DASDataTypes.DASDOUBLE:
                case DASDataColumn.DASDataTypes.DASLONG:
                    TableDAS.AddParameter(string.Format("@P{0}", i), this[column, rowVersion], DAS.ParameterModes.PARM_IN, DAS.ServerTypes.ST_NUMBER);
                    break;

                case DASDataColumn.DASDataTypes.DASSTRING:
                    TableDAS.AddParameter(string.Format("@P{0}", i), this[column, rowVersion], DAS.ParameterModes.PARM_IN, DAS.ServerTypes.ST_VARCHAR2);
                    break;

                default:
                    throw new UnsupportedDataTypeException(column.DASDataType.ToString());
                }
                i++;
            }
            try
            {
                stringBuilder.AppendFormat("SELECT NULL FROM {0}", dataTable.DBTableName);
                i = 1;
                foreach (DASDataColumn column in Table.PrimaryKey)
                {
                    if (i == 1)
                    {
                        stringBuilder.Append(" WHERE ");
                    }
                    else
                    {
                        stringBuilder.Append(" AND ");
                    }
                    stringBuilder.AppendFormat("{0} = @P{1}", column.ColumnName, i++);
                }

                TableDAS.FillDataTable(dataTable, stringBuilder.ToString());
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex.InnerException);
            }
            finally
            {
                for (var k = 1; k <= Table.PrimaryKey.Length; k++)
                {
                    TableDAS.RemoveParameter(string.Format("@P{0}", k));
                }
            }

            if (dataTable.Rows.Count() == 1)
            {
                ReturnValue = true;
            }
            else if (dataTable.Rows.Count() > 1)
            {
                throw new TooManyRowsFoundException();
            }

            return(ReturnValue);
        }
Example #3
0
 /// <summary>
 /// This method overloads the base class method to support DAS specific properties.
 /// </summary>
 /// <param name="table">Table to be merged.</param>
 public void Merge(DASDataTable table)
 {
     Merge(table, true, MissingSchemaAction.Error);
 }
Example #4
0
 /// <summary>
 /// This method overloads the base class method to support DAS specific properties.
 /// </summary>
 /// <param name="table">Table to be merged.</param>
 /// <param name="preserveChanges"><c>True</c> means all changes are preserved.</param>
 public void Merge(DASDataTable table, bool preserveChanges)
 {
     Merge(table, preserveChanges, MissingSchemaAction.Error);
 }