private DBMeasureDimension GetMeasureDimensionFromReader(IDataReader dataReader)
 {
     DBMeasureDimension measureDimension = new DBMeasureDimension();
     measureDimension.MeasureDimensionID = NopSqlDataHelper.GetInt(dataReader, "MeasureDimensionID");
     measureDimension.Name = NopSqlDataHelper.GetString(dataReader, "Name");
     measureDimension.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
     measureDimension.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
     return measureDimension;
 }
        private DBMeasureDimension GetMeasureDimensionFromReader(IDataReader dataReader)
        {
            DBMeasureDimension measureDimension = new DBMeasureDimension();

            measureDimension.MeasureDimensionID = NopSqlDataHelper.GetInt(dataReader, "MeasureDimensionID");
            measureDimension.Name          = NopSqlDataHelper.GetString(dataReader, "Name");
            measureDimension.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
            measureDimension.DisplayOrder  = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
            return(measureDimension);
        }
Пример #3
0
        private DBMeasureDimension GetMeasureDimensionFromReader(IDataReader dataReader)
        {
            var item = new DBMeasureDimension();

            item.MeasureDimensionId = NopSqlDataHelper.GetInt(dataReader, "MeasureDimensionID");
            item.Name          = NopSqlDataHelper.GetString(dataReader, "Name");
            item.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
            item.Ratio         = NopSqlDataHelper.GetDecimal(dataReader, "Ratio");
            item.DisplayOrder  = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
            return(item);
        }
Пример #4
0
        private static MeasureDimension DBMapping(DBMeasureDimension dbItem)
        {
            if (dbItem == null)
                return null;

            MeasureDimension item = new MeasureDimension();
            item.MeasureDimensionID = dbItem.MeasureDimensionID;
            item.Name = dbItem.Name;
            item.SystemKeyword = dbItem.SystemKeyword;
            item.DisplayOrder = dbItem.DisplayOrder;

            return item;
        }
Пример #5
0
        /// <summary>
        /// Gets a measure dimension by identifier
        /// </summary>
        /// <param name="measureDimensionId">Measure dimension identifier</param>
        /// <returns>Measure dimension</returns>
        public override DBMeasureDimension GetMeasureDimensionById(int measureDimensionId)
        {
            DBMeasureDimension measureDimension = null;
            Database           db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand          dbCommand = db.GetStoredProcCommand("Nop_MeasureDimensionLoadByPrimaryKey");

            db.AddInParameter(dbCommand, "MeasureDimensionID", DbType.Int32, measureDimensionId);
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                if (dataReader.Read())
                {
                    measureDimension = GetMeasureDimensionFromReader(dataReader);
                }
            }
            return(measureDimension);
        }
        /// <summary>
        /// Gets all measure dimensions
        /// </summary>
        /// <returns>Measure dimension collection</returns>
        public override DBMeasureDimensionCollection GetAllMeasureDimensions()
        {
            DBMeasureDimensionCollection measureDimensionCollection = new DBMeasureDimensionCollection();
            Database  db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand dbCommand = db.GetStoredProcCommand("Nop_MeasureDimensionLoadAll");

            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    DBMeasureDimension measureDimension = GetMeasureDimensionFromReader(dataReader);
                    measureDimensionCollection.Add(measureDimension);
                }
            }

            return(measureDimensionCollection);
        }
Пример #7
0
        /// <summary>
        /// Updates the measure dimension
        /// </summary>
        /// <param name="measureDimensionId">Measure dimension identifier</param>
        /// <param name="name">The name</param>
        /// <param name="systemKeyword">The system keyword</param>
        /// <param name="ratio">The ratio</param>
        /// <param name="displayOrder">The display order</param>
        /// <returns>A measure dimension</returns>
        public override DBMeasureDimension UpdateMeasureDimension(int measureDimensionId,
                                                                  string name, string systemKeyword, decimal ratio, int displayOrder)
        {
            DBMeasureDimension item      = null;
            Database           db        = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
            DbCommand          dbCommand = db.GetStoredProcCommand("Nop_MeasureDimensionUpdate");

            db.AddInParameter(dbCommand, "MeasureDimensionID", DbType.Int32, measureDimensionId);
            db.AddInParameter(dbCommand, "Name", DbType.String, name);
            db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, systemKeyword);
            db.AddInParameter(dbCommand, "Ratio", DbType.Decimal, ratio);
            db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
            if (db.ExecuteNonQuery(dbCommand) > 0)
            {
                item = GetMeasureDimensionById(measureDimensionId);
            }

            return(item);
        }