/// <summary>
        /// Get with transaction
        /// </summary>
        public PM_ALT_CRITERION_AGGR Get(object entityId, DbTransaction transaction)
        {
            ArgumentValidator.CheckForNullArgument(entityId, "entityId");
            ArgumentValidator.CheckForNullArgument(transaction, "transaction");

            PM_ALT_CRITERION_AGGR PM_ALT_CRITERION_AGGREntity = null;

            try
            {
                Database  db        = GetDatabaseInstance();
                DbCommand dbCommand = db.GetSqlStringCommand(PM_ALT_CRITERION_AGGRDAO.SqlGet);

                db.AddInParameter(dbCommand, "@AggregationID", DbType.Guid, entityId);
                using (IDataReader dataReader = db.ExecuteReader(dbCommand, transaction))
                {
                    if (dataReader.Read())
                    {
                        PM_ALT_CRITERION_AGGREntity = ReadEntity(dataReader);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
            }

            return(PM_ALT_CRITERION_AGGREntity);
        }
        private void UpdateAll(PM_ALT_CRITERION_AGGR entity, DbTransaction transaction)
        {
            ArgumentValidator.CheckForNullArgument(entity, "entity");
            ArgumentValidator.CheckForNullArgument(transaction, "transaction");

            PersistentPM_ALT_CRITERION_AGGR PM_ALT_CRITERION_AGGREntity = entity as PersistentPM_ALT_CRITERION_AGGR;

            try
            {
                Database  db        = GetDatabaseInstance();
                DbCommand dbCommand = db.GetSqlStringCommand(PM_ALT_CRITERION_AGGRDAO.SqlUpdate);

                db.AddInParameter(dbCommand, "@AggregationID", DbType.Guid, PM_ALT_CRITERION_AGGREntity.AggregationID);
                db.AddInParameter(dbCommand, "@AlertID", DbType.Guid, PM_ALT_CRITERION_AGGREntity.AlertID);
                db.AddInParameter(dbCommand, "@Element", DbType.String, PM_ALT_CRITERION_AGGREntity.Element);
                db.AddInParameter(dbCommand, "@Alias", DbType.String, PM_ALT_CRITERION_AGGREntity.Alias);
                db.AddInParameter(dbCommand, "@Sequence", DbType.Int32, PM_ALT_CRITERION_AGGREntity.Sequence);
                db.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, PM_ALT_CRITERION_AGGREntity.IsActive);
                db.AddInParameter(dbCommand, "@RowDeleted", DbType.Boolean, PM_ALT_CRITERION_AGGREntity.RowDeleted);
                db.AddInParameter(dbCommand, "@CreatedBy", DbType.String, PM_ALT_CRITERION_AGGREntity.CreatedBy);
                db.AddInParameter(dbCommand, "@CreatedOn", DbType.DateTime, PM_ALT_CRITERION_AGGREntity.CreatedOn);
                db.AddInParameter(dbCommand, "@ModifiedBy", DbType.String, PM_ALT_CRITERION_AGGREntity.ModifiedBy);
                db.AddInParameter(dbCommand, "@ModifiedOn", DbType.DateTime, PM_ALT_CRITERION_AGGREntity.ModifiedOn);
                int result = db.ExecuteNonQuery(dbCommand, transaction);

                if (result == 0)
                {
                    throw new EntityNotFoundException();
                }
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
            }
        }
Esempio n. 3
0
 //
 public void SaveBatch(Guid alertID, IList <PM_ALT_CRITERION_AGGR> entities, out string returnMessage)
 {
     returnMessage = string.Empty;
     //
     try
     {
         //1.
         _PM_ALT_CRITERION_AGGRDAO.SetDeletedByAlert(alertID);
         //2.
         foreach (PM_ALT_CRITERION_AGGR entity in entities)
         {
             PM_ALT_CRITERION_AGGR entityExisted = this.GetEntity(entity.AggregationID.Value);
             if (null == entityExisted)
             {
                 this.Insert(entity);
             }
             else
             {
                 entity.RowDeleted = false;
                 this.UpdateSome(entity);
             }
         }
         //3.
         _PM_ALT_CRITERION_AGGRDAO.ClearDeletedByAlert(alertID);
     }
     catch (Exception ex)
     {
         returnMessage = ex.Message;
         return;
     }
 }
 public void Update(PM_ALT_CRITERION_AGGR entity, bool updateAll, DbTransaction transaction)
 {
     if (!updateAll)
     {
         UpdateSome(entity, transaction);
     }
     else
     {
         UpdateAll(entity, transaction);
     }
 }
 public void Update(PM_ALT_CRITERION_AGGR entity, bool updateAll)
 {
     if (!updateAll)
     {
         UpdateSome(entity);
     }
     else
     {
         UpdateAll(entity);
     }
 }
Esempio n. 6
0
        public void UpdateSome(PM_ALT_CRITERION_AGGR entity)
        {
            try
            {
                ArgumentValidator.CheckForNullArgument(entity, "PM_ALT_CRITERION_AGGR Entity");

                _PM_ALT_CRITERION_AGGRDAO.Update(entity, false);
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
            }
        }
Esempio n. 7
0
        public void Delete(PM_ALT_CRITERION_AGGR entity)
        {
            try
            {
                ArgumentValidator.CheckForNullArgument(entity, "PM_ALT_CRITERION_AGGR Entity");

                _PM_ALT_CRITERION_AGGRDAO.Delete(entity.AggregationID);
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
            }
        }
Esempio n. 8
0
        //
        #region base interface impl

        public PM_ALT_CRITERION_AGGR Insert(PM_ALT_CRITERION_AGGR entity)
        {
            PM_ALT_CRITERION_AGGR newEntity = null;

            try
            {
                ArgumentValidator.CheckForNullArgument(entity, "PM_ALT_CRITERION_AGGR Entity");

                newEntity = _PM_ALT_CRITERION_AGGRDAO.Insert(entity);
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
            }

            return(newEntity);
        }
Esempio n. 9
0
        public PM_ALT_CRITERION_AGGR GetEntity(Guid entityGuid)
        {
            PM_ALT_CRITERION_AGGR entity = null;

            try
            {
                ArgumentValidator.CheckForNullArgument(entityGuid, "PM_ALT_CRITERION_AGGR Guid");

                entity = _PM_ALT_CRITERION_AGGRDAO.Get(entityGuid);
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy);
            }

            return(entity);
        }
        private static PM_ALT_CRITERION_AGGR ReadEntity(IDataReader dataReader)
        {
            PM_ALT_CRITERION_AGGR PM_ALT_CRITERION_AGGREntity = new PM_ALT_CRITERION_AGGR();
            object value;


            value = dataReader["AggregationID"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.AggregationID = (Guid?)value;
            }

            value = dataReader["AlertID"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.AlertID = (Guid?)value;
            }

            value = dataReader["Element"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.Element = (String)value;
            }

            value = dataReader["Alias"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.Alias = (String)value;
            }

            value = dataReader["Sequence"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.Sequence = (Int32?)value;
            }

            value = dataReader["IsActive"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.IsActive = (Boolean?)value;
            }

            value = dataReader["RowDeleted"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.RowDeleted = (Boolean?)value;
            }

            value = dataReader["CreatedBy"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.CreatedBy = (String)value;
            }

            value = dataReader["CreatedOn"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.CreatedOn = (DateTime?)value;
            }

            value = dataReader["ModifiedBy"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.ModifiedBy = (String)value;
            }

            value = dataReader["ModifiedOn"];
            if (value != DBNull.Value)
            {
                PM_ALT_CRITERION_AGGREntity.ModifiedOn = (DateTime?)value;
            }

            return(PM_ALT_CRITERION_AGGREntity);
        }
        private void UpdateSome(PM_ALT_CRITERION_AGGR entity, DbTransaction transaction)
        {
            ArgumentValidator.CheckForNullArgument(entity, "entity");
            ArgumentValidator.CheckForNullArgument(transaction, "transaction");

            PersistentPM_ALT_CRITERION_AGGR PM_ALT_CRITERION_AGGREntity = entity as PersistentPM_ALT_CRITERION_AGGR;

            StringBuilder sqlUpdateSome = new StringBuilder();

            sqlUpdateSome.Append("UPDATE dbo.PM_ALT_CRITERION_AGGR SET ");

            PropertyInfo[] propertyInfos        = PM_ALT_CRITERION_AGGREntity.GetType().GetProperties();
            Hashtable      propertyValues       = new System.Collections.Hashtable();
            int            columnCountForUpdate = 0;

            foreach (PropertyInfo propertyInfo in propertyInfos)
            {
                if (EntityMapping.ContainsProperty(propertyInfo.Name))
                {
                    object     propertyValue = propertyInfo.GetValue(PM_ALT_CRITERION_AGGREntity, null);
                    ORProperty property      = EntityMapping[propertyInfo.Name];
                    if (!property.IsPrimaryKey)
                    {
                        if (!PM_ALT_CRITERION_AGGREntity.IsDefaultValue(propertyInfo.Name))
                        {
                            propertyValues[propertyInfo.Name] = propertyValue;

                            sqlUpdateSome.Append(" " + property.ColumnName + " = @" + property.ColumnName + ",");
                            columnCountForUpdate++;
                        }
                    }
                    else
                    {
                        propertyValues[propertyInfo.Name] = propertyValue;
                    }
                }
            }
            if (columnCountForUpdate == 0)
            {
                return;
            }

            sqlUpdateSome.Remove(sqlUpdateSome.Length - 1, 1);
            sqlUpdateSome.Append(" WHERE 1 = 1 ");
            sqlUpdateSome.Append(" AND AggregationID = @AggregationID ");

            try
            {
                Database  db        = GetDatabaseInstance();
                DbCommand dbCommand = db.GetSqlStringCommand(sqlUpdateSome.ToString());

                foreach (DictionaryEntry de in propertyValues)
                {
                    ORProperty property = EntityMapping[de.Key.ToString()];
                    db.AddInParameter(dbCommand, "@" + property.ColumnName, property.DatabaseType, de.Value);
                }

                int result = db.ExecuteNonQuery(dbCommand, transaction);

                if (result == 0)
                {
                    throw new EntityNotFoundException();
                }
            }
            catch (Exception ex)
            {
                ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy);
            }
        }
        /// <summary>
        /// Update with transaction
        /// </summary>

        public void Update(PM_ALT_CRITERION_AGGR entity, DbTransaction transaction)
        {
            Update(entity, true, transaction);
        }
        /// <summary>
        /// Update
        /// </summary>

        public void Update(PM_ALT_CRITERION_AGGR entity)
        {
            Update(entity, true);
        }