protected void CreateCoupon()
{
if (ValidateData())
{
try
{
var coupon = new Coupon()
{
Code = txtCode.Text,
Enabled = chkEnabled.Checked,
Type = (CouponType)Enum.Parse(typeof(CouponType), ddlCouponType.SelectedValue),
Value = float.Parse(txtValue.Text.Replace(".", ",")),
ExpirationDate =
txtExpirationDate.Text.IsNotEmpty()
? (DateTime?)DateTime.Parse(txtExpirationDate.Text).AddHours(23).AddMinutes(59).AddSeconds(59)
: null,
PossibleUses = int.Parse(txtPosibleUses.Text),
MinimalOrderPrice = float.Parse(txtMinimalOrderPrice.Text.Replace(".", ",")),
ActualUses = 0,
AddingDate = DateTime.Now,
};
CouponService.AddCoupon(coupon);
if (ViewState["SelectedCategories"] != null)
{
List<int> list = (List<int>)ViewState["SelectedCategories"];
foreach (var catID in list)
{
CouponService.AddCategoryToCoupon(coupon.CouponID, catID);
}
}
List<int> listproducts = (List<int>)ViewState["SelectedProducts"];
if (listproducts != null)
{
foreach (var productid in listproducts)
{
CouponService.AddProductToCoupon(coupon.CouponID, productid);
}
}
}
catch (Exception ex)
{
MsgErr(ex.Message + " CreateCoupon main");
Debug.LogError(ex);
}
}
}
public static void AddCoupon(Coupon coupon)
{
coupon.CouponID = SQLDataAccess.ExecuteScalar<int>(" INSERT INTO [Catalog].[Coupon] " +
" ([Code], [Type], [Value], [AddingDate], [ExpirationDate], [PossibleUses], [ActualUses], [Enabled], [MinimalOrderPrice]) " +
" VALUES (@Code, @Type, @Value, @AddingDate, @ExpirationDate, @PossibleUses, @ActualUses, @Enabled, @MinimalOrderPrice); SELECT SCOPE_IDENTITY();",
CommandType.Text,
new SqlParameter("@Code", coupon.Code),
new SqlParameter("@Type", coupon.Type),
new SqlParameter("@Value", coupon.Value),
new SqlParameter("@AddingDate", coupon.AddingDate),
new SqlParameter("@ExpirationDate", coupon.ExpirationDate ?? (object)DBNull.Value),
new SqlParameter("@PossibleUses", coupon.PossibleUses),
new SqlParameter("@ActualUses", coupon.ActualUses),
new SqlParameter("@Enabled", coupon.Enabled),
new SqlParameter("@MinimalOrderPrice", coupon.MinimalOrderPrice)
);
}
public static void UpdateCoupon(Coupon coupon)
{
SQLDataAccess.ExecuteNonQuery(" UPDATE [Catalog].[Coupon] SET [Code] = @Code, [Type] = @Type, [Value] = @Value, [AddingDate]=@AddingDate, [ExpirationDate] = @ExpirationDate, [PossibleUses] = @PossibleUses, [ActualUses] = @ActualUses, [Enabled] = @Enabled, [MinimalOrderPrice] = @MinimalOrderPrice " +
" WHERE CouponID = @CouponID", CommandType.Text,
new SqlParameter("@CouponID", coupon.CouponID),
new SqlParameter("@Code", coupon.Code),
new SqlParameter("@Type", coupon.Type),
new SqlParameter("@Value", coupon.Value),
new SqlParameter("@AddingDate", coupon.AddingDate),
new SqlParameter("@ExpirationDate", coupon.ExpirationDate ?? (object)DBNull.Value),
new SqlParameter("@PossibleUses", coupon.PossibleUses),
new SqlParameter("@ActualUses", coupon.ActualUses),
new SqlParameter("@Enabled", coupon.Enabled),
new SqlParameter("@MinimalOrderPrice", coupon.MinimalOrderPrice)
);
}