private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader) { DBShippingByWeight shippingByWeight = new DBShippingByWeight(); shippingByWeight.ShippingByWeightID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID"); shippingByWeight.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID"); shippingByWeight.From = NopSqlDataHelper.GetDecimal(dataReader, "From"); shippingByWeight.To = NopSqlDataHelper.GetDecimal(dataReader, "To"); shippingByWeight.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage"); shippingByWeight.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage"); shippingByWeight.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount"); return shippingByWeight; }
private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader) { var item = new DBShippingByWeight(); item.ShippingByWeightId = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID"); item.ShippingMethodId = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID"); item.From = NopSqlDataHelper.GetDecimal(dataReader, "From"); item.To = NopSqlDataHelper.GetDecimal(dataReader, "To"); item.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage"); item.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage"); item.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount"); return(item); }
private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader) { DBShippingByWeight shippingByWeight = new DBShippingByWeight(); shippingByWeight.ShippingByWeightID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID"); shippingByWeight.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID"); shippingByWeight.From = NopSqlDataHelper.GetDecimal(dataReader, "From"); shippingByWeight.To = NopSqlDataHelper.GetDecimal(dataReader, "To"); shippingByWeight.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage"); shippingByWeight.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage"); shippingByWeight.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount"); return(shippingByWeight); }
/// <summary> /// Gets a ShippingByWeight /// </summary> /// <param name="ShippingByWeightID">ShippingByWeight identifier</param> /// <returns>ShippingByWeight</returns> public override DBShippingByWeight GetByID(int ShippingByWeightID) { DBShippingByWeight shippingByWeight = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadByPrimaryKey"); db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, ShippingByWeightID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { shippingByWeight = GetShippingByWeightFromReader(dataReader); } } return(shippingByWeight); }
private static ShippingByWeight DBMapping(DBShippingByWeight dbItem) { if (dbItem == null) return null; ShippingByWeight item = new ShippingByWeight(); item.ShippingByWeightID = dbItem.ShippingByWeightID; item.ShippingMethodID = dbItem.ShippingMethodID; item.From = dbItem.From; item.To = dbItem.To; item.UsePercentage = dbItem.UsePercentage; item.ShippingChargePercentage = dbItem.ShippingChargePercentage; item.ShippingChargeAmount = dbItem.ShippingChargeAmount; return item; }
/// <summary> /// Gets all ShippingByWeights /// </summary> /// <returns>ShippingByWeight collection</returns> public override DBShippingByWeightCollection GetAll() { DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader); shippingByWeightCollection.Add(shippingByWeight); } } return(shippingByWeightCollection); }
/// <summary> /// Gets all ShippingByWeights by shipping method identifier /// </summary> /// <param name="ShippingMethodID">The shipping method identifier</param> /// <returns>ShippingByWeight collection</returns> public override DBShippingByWeightCollection GetAllByShippingMethodID(int ShippingMethodID) { DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadByShippingMethodID"); db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader); shippingByWeightCollection.Add(shippingByWeight); } } return(shippingByWeightCollection); }
/// <summary> /// Updates the ShippingByWeight /// </summary> /// <param name="ShippingByWeightID">The ShippingByWeight identifier</param> /// <param name="ShippingMethodID">The shipping method identifier</param> /// <param name="From">The "from" value</param> /// <param name="To">The "to" value</param> /// <param name="UsePercentage">A value indicating whether to use percentage</param> /// <param name="ShippingChargePercentage">The shipping charge percentage</param> /// <param name="ShippingChargeAmount">The shipping charge amount</param> /// <returns>ShippingByWeight</returns> public override DBShippingByWeight UpdateShippingByWeight(int ShippingByWeightID, int ShippingMethodID, decimal From, decimal To, bool UsePercentage, decimal ShippingChargePercentage, decimal ShippingChargeAmount) { DBShippingByWeight shippingByWeight = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightUpdate"); db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, ShippingByWeightID); db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID); db.AddInParameter(dbCommand, "From", DbType.Decimal, From); db.AddInParameter(dbCommand, "To", DbType.Decimal, To); db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, UsePercentage); db.AddInParameter(dbCommand, "ShippingChargePercentage", DbType.Decimal, ShippingChargePercentage); db.AddInParameter(dbCommand, "ShippingChargeAmount", DbType.Decimal, ShippingChargeAmount); if (db.ExecuteNonQuery(dbCommand) > 0) { shippingByWeight = GetByID(ShippingByWeightID); } return(shippingByWeight); }
/// <summary> /// Updates the ShippingByWeight /// </summary> /// <param name="shippingByWeightId">The ShippingByWeight identifier</param> /// <param name="shippingMethodId">The shipping method identifier</param> /// <param name="from">The "from" value</param> /// <param name="to">The "to" value</param> /// <param name="usePercentage">A value indicating whether to use percentage</param> /// <param name="shippingChargePercentage">The shipping charge percentage</param> /// <param name="shippingChargeAmount">The shipping charge amount</param> /// <returns>ShippingByWeight</returns> public override DBShippingByWeight UpdateShippingByWeight(int shippingByWeightId, int shippingMethodId, decimal from, decimal to, bool usePercentage, decimal shippingChargePercentage, decimal shippingChargeAmount) { DBShippingByWeight item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightUpdate"); db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, shippingByWeightId); db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, shippingMethodId); db.AddInParameter(dbCommand, "From", DbType.Decimal, from); db.AddInParameter(dbCommand, "To", DbType.Decimal, to); db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, usePercentage); db.AddInParameter(dbCommand, "ShippingChargePercentage", DbType.Decimal, shippingChargePercentage); db.AddInParameter(dbCommand, "ShippingChargeAmount", DbType.Decimal, shippingChargeAmount); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetById(shippingByWeightId); } return(item); }