/// <summary>
/// Updates the discount
/// </summary>
/// <param name="DiscountID">Discount identifier</param>
/// <param name="DiscountTypeID">The discount type identifier</param>
/// <param name="DiscountRequirementID">The discount requirement identifier</param>
/// <param name="Name">The name</param>
/// <param name="UsePercentage">A value indicating whether to use percentage</param>
/// <param name="DiscountPercentage">The discount percentage</param>
/// <param name="DiscountAmount">The discount amount</param>
/// <param name="StartDate">The discount start date and time</param>
/// <param name="EndDate">The discount end date and time</param>
/// <param name="RequiresCouponCode">The value indicating whether discount requires coupon code</param>
/// <param name="CouponCode">The coupon code</param>
/// <param name="Deleted">A value indicating whether the entity has been deleted</param>
/// <returns>Discount</returns>
public override DBDiscount UpdateDiscount(int DiscountID, int DiscountTypeID, int DiscountRequirementID, string Name, bool UsePercentage, decimal DiscountPercentage, decimal DiscountAmount,
DateTime StartDate, DateTime EndDate, bool RequiresCouponCode, string CouponCode, bool Deleted)
{
DBDiscount discount = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountUpdate");
db.AddInParameter(dbCommand, "DiscountID", DbType.Int32, DiscountID);
db.AddInParameter(dbCommand, "DiscountTypeID", DbType.Int32, DiscountTypeID);
db.AddInParameter(dbCommand, "DiscountRequirementID", DbType.Int32, DiscountRequirementID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, UsePercentage);
db.AddInParameter(dbCommand, "DiscountPercentage", DbType.Decimal, DiscountPercentage);
db.AddInParameter(dbCommand, "DiscountAmount", DbType.Decimal, DiscountAmount);
db.AddInParameter(dbCommand, "StartDate", DbType.DateTime, StartDate);
db.AddInParameter(dbCommand, "EndDate", DbType.DateTime, EndDate);
db.AddInParameter(dbCommand, "RequiresCouponCode", DbType.Boolean, RequiresCouponCode);
db.AddInParameter(dbCommand, "CouponCode", DbType.String, CouponCode);
db.AddInParameter(dbCommand, "Deleted", DbType.Boolean, Deleted);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
discount = GetDiscountByID(DiscountID);
}
return(discount);
}
/// <summary>
/// Updates the discount
/// </summary>
/// <param name="discountId">Discount identifier</param>
/// <param name="discountTypeId">The discount type identifier</param>
/// <param name="discountRequirementId">The discount requirement identifier</param>
/// <param name="discountLimitationId">The discount limitation identifier</param>
/// <param name="name">The name</param>
/// <param name="usePercentage">A value indicating whether to use percentage</param>
/// <param name="discountPercentage">The discount percentage</param>
/// <param name="discountAmount">The discount amount</param>
/// <param name="startDate">The discount start date and time</param>
/// <param name="endDate">The discount end date and time</param>
/// <param name="requiresCouponCode">The value indicating whether discount requires coupon code</param>
/// <param name="couponCode">The coupon code</param>
/// <param name="deleted">A value indicating whether the entity has been deleted</param>
/// <returns>Discount</returns>
public override DBDiscount UpdateDiscount(int discountId, int discountTypeId,
int discountRequirementId, int discountLimitationId,
string name, bool usePercentage, decimal discountPercentage,
decimal discountAmount, DateTime startDate, DateTime endDate,
bool requiresCouponCode, string couponCode, bool deleted)
{
DBDiscount item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountUpdate");
db.AddInParameter(dbCommand, "DiscountID", DbType.Int32, discountId);
db.AddInParameter(dbCommand, "DiscountTypeID", DbType.Int32, discountTypeId);
db.AddInParameter(dbCommand, "DiscountRequirementID", DbType.Int32, discountRequirementId);
db.AddInParameter(dbCommand, "DiscountLimitationID", DbType.Int32, discountLimitationId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, usePercentage);
db.AddInParameter(dbCommand, "DiscountPercentage", DbType.Decimal, discountPercentage);
db.AddInParameter(dbCommand, "DiscountAmount", DbType.Decimal, discountAmount);
db.AddInParameter(dbCommand, "StartDate", DbType.DateTime, startDate);
db.AddInParameter(dbCommand, "EndDate", DbType.DateTime, endDate);
db.AddInParameter(dbCommand, "RequiresCouponCode", DbType.Boolean, requiresCouponCode);
db.AddInParameter(dbCommand, "CouponCode", DbType.String, couponCode);
db.AddInParameter(dbCommand, "Deleted", DbType.Boolean, deleted);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetDiscountById(discountId);
}
return(item);
}
/// <summary>
/// Gets all discounts
/// </summary>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <param name="DiscountTypeID">Discount type identifier; null to load all discount</param>
/// <returns>Discount collection</returns>
public override DBDiscountCollection GetAllDiscounts(bool showHidden, int?DiscountTypeID)
{
DBDiscountCollection discountCollection = new DBDiscountCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
if (DiscountTypeID.HasValue)
{
db.AddInParameter(dbCommand, "DiscountTypeID", DbType.Int32, DiscountTypeID.Value);
}
else
{
db.AddInParameter(dbCommand, "DiscountTypeID", DbType.Int32, null);
}
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBDiscount discount = GetDiscountFromReader(dataReader);
discountCollection.Add(discount);
}
}
return(discountCollection);
}
/// <summary>
/// Gets a discount
/// </summary>
/// <param name="discountId">Discount identifier</param>
/// <returns>Discount</returns>
public override DBDiscount GetDiscountById(int discountId)
{
DBDiscount item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountLoadByPrimaryKey");
db.AddInParameter(dbCommand, "DiscountID", DbType.Int32, discountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetDiscountFromReader(dataReader);
}
}
return(item);
}
private DBDiscount GetDiscountFromReader(IDataReader dataReader)
{
DBDiscount discount = new DBDiscount();
discount.DiscountID = NopSqlDataHelper.GetInt(dataReader, "DiscountID");
discount.DiscountTypeID = NopSqlDataHelper.GetInt(dataReader, "DiscountTypeID");
discount.DiscountRequirementID = NopSqlDataHelper.GetInt(dataReader, "DiscountRequirementID");
discount.Name = NopSqlDataHelper.GetString(dataReader, "Name");
discount.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
discount.DiscountPercentage = NopSqlDataHelper.GetDecimal(dataReader, "DiscountPercentage");
discount.DiscountAmount = NopSqlDataHelper.GetDecimal(dataReader, "DiscountAmount");
discount.StartDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "StartDate");
discount.EndDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "EndDate");
discount.RequiresCouponCode = NopSqlDataHelper.GetBoolean(dataReader, "RequiresCouponCode");
discount.CouponCode = NopSqlDataHelper.GetString(dataReader, "CouponCode");
discount.Deleted = NopSqlDataHelper.GetBoolean(dataReader, "Deleted");
return discount;
}
private DBDiscount GetDiscountFromReader(IDataReader dataReader)
{
DBDiscount discount = new DBDiscount();
discount.DiscountID = NopSqlDataHelper.GetInt(dataReader, "DiscountID");
discount.DiscountTypeID = NopSqlDataHelper.GetInt(dataReader, "DiscountTypeID");
discount.DiscountRequirementID = NopSqlDataHelper.GetInt(dataReader, "DiscountRequirementID");
discount.Name = NopSqlDataHelper.GetString(dataReader, "Name");
discount.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
discount.DiscountPercentage = NopSqlDataHelper.GetDecimal(dataReader, "DiscountPercentage");
discount.DiscountAmount = NopSqlDataHelper.GetDecimal(dataReader, "DiscountAmount");
discount.StartDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "StartDate");
discount.EndDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "EndDate");
discount.RequiresCouponCode = NopSqlDataHelper.GetBoolean(dataReader, "RequiresCouponCode");
discount.CouponCode = NopSqlDataHelper.GetString(dataReader, "CouponCode");
discount.Deleted = NopSqlDataHelper.GetBoolean(dataReader, "Deleted");
return(discount);
}
private DBDiscount GetDiscountFromReader(IDataReader dataReader)
{
var item = new DBDiscount();
item.DiscountId = NopSqlDataHelper.GetInt(dataReader, "DiscountID");
item.DiscountTypeId = NopSqlDataHelper.GetInt(dataReader, "DiscountTypeID");
item.DiscountLimitationId = NopSqlDataHelper.GetInt(dataReader, "DiscountLimitationID");
item.DiscountRequirementId = NopSqlDataHelper.GetInt(dataReader, "DiscountRequirementID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
item.DiscountPercentage = NopSqlDataHelper.GetDecimal(dataReader, "DiscountPercentage");
item.DiscountAmount = NopSqlDataHelper.GetDecimal(dataReader, "DiscountAmount");
item.StartDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "StartDate");
item.EndDate = NopSqlDataHelper.GetUtcDateTime(dataReader, "EndDate");
item.RequiresCouponCode = NopSqlDataHelper.GetBoolean(dataReader, "RequiresCouponCode");
item.CouponCode = NopSqlDataHelper.GetString(dataReader, "CouponCode");
item.Deleted = NopSqlDataHelper.GetBoolean(dataReader, "Deleted");
return(item);
}
/// <summary>
/// Gets a discount collection of a category
/// </summary>
/// <param name="CategoryID">Category identifier</param>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <returns>Discount collection</returns>
public override DBDiscountCollection GetDiscountsByCategoryID(int CategoryID, bool showHidden)
{
DBDiscountCollection discountCollection = new DBDiscountCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountLoadByCategoryID");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, CategoryID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBDiscount discount = GetDiscountFromReader(dataReader);
discountCollection.Add(discount);
}
}
return(discountCollection);
}
private static Discount DBMapping(DBDiscount dbItem)
{
if (dbItem == null)
return null;
Discount item = new Discount();
item.DiscountID = dbItem.DiscountID;
item.DiscountTypeID = dbItem.DiscountTypeID;
item.DiscountRequirementID = dbItem.DiscountRequirementID;
item.Name = dbItem.Name;
item.UsePercentage = dbItem.UsePercentage;
item.DiscountPercentage = dbItem.DiscountPercentage;
item.DiscountAmount = dbItem.DiscountAmount;
item.StartDate = dbItem.StartDate;
item.EndDate = dbItem.EndDate;
item.RequiresCouponCode = dbItem.RequiresCouponCode;
item.CouponCode = dbItem.CouponCode;
item.Deleted = dbItem.Deleted;
return item;
}