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