public static BasketCouponCollection LoadForBasket(Int32 basketId) { BasketCouponCollection BasketCoupons = new BasketCouponCollection(); //CREATE THE DYNAMIC SQL TO LOAD OBJECT! StringBuilder selectQuery = new StringBuilder(); selectQuery.Append("SELECT " + BasketCoupon.GetColumnNames(string.Empty)); selectQuery.Append(" FROM ac_BasketCoupons"); selectQuery.Append(" WHERE BasketId = @basketId"); selectQuery.Append(" ORDER BY AppliedDate DESC"); Database database = Token.Instance.Database; DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString()); database.AddInParameter(selectCommand, "@basketId", System.Data.DbType.Int32, basketId); //EXECUTE THE COMMAND using (IDataReader dr = database.ExecuteReader(selectCommand)) { while (dr.Read()) { BasketCoupon basketCoupon = new BasketCoupon(); BasketCoupon.LoadDataReader(basketCoupon, dr); BasketCoupons.Add(basketCoupon); } dr.Close(); } return(BasketCoupons); }
/// <summary> /// Loads the given BasketCoupon object from the given database data reader. /// </summary> /// <param name="basketCoupon">The BasketCoupon object to load.</param> /// <param name="dr">The database data reader to read data from.</param> public static void LoadDataReader(BasketCoupon basketCoupon, IDataReader dr) { //SET FIELDS FROM ROW DATA basketCoupon.BasketId = dr.GetInt32(0); basketCoupon.CouponId = dr.GetInt32(1); basketCoupon.AppliedDate = LocaleHelper.ToLocalTime(dr.GetDateTime(2)); basketCoupon.IsDirty = false; }
public static bool Delete(Int32 basketId, Int32 couponId) { BasketCoupon basketCoupon = new BasketCoupon(); if (basketCoupon.Load(basketId, couponId)) { return(basketCoupon.Delete()); } return(false); }
public static SaveResult Insert(BasketCoupon basketCoupon) { return(basketCoupon.Save()); }
public static bool Delete(BasketCoupon basketCoupon) { return(basketCoupon.Delete()); }
public static SaveResult Update(BasketCoupon basketCoupon) { return(basketCoupon.Save()); }