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