public static CouponProductCollection LoadForCoupon(Int32 couponId, bool excludeGiftCerts)
{
if (excludeGiftCerts)
{
CouponProductCollection CouponProducts = new CouponProductCollection();
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT CP.ProductId");
selectQuery.Append(" FROM ac_CouponProducts CP INNER JOIN ac_Products P ON CP.ProductId=P.ProductId");
selectQuery.Append(" WHERE CP.CouponId = @couponId");
selectQuery.Append(" AND P.IsGiftCertificate = 0");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@couponId", System.Data.DbType.Int32, couponId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
CouponProduct couponProduct = new CouponProduct();
couponProduct.CouponId = couponId;
couponProduct.ProductId = dr.GetInt32(0);
CouponProducts.Add(couponProduct);
}
dr.Close();
}
return(CouponProducts);
}
else
{
return(LoadForCoupon(couponId));
}
}
public static CouponProductCollection LoadForProduct(Int32 productId)
{
CouponProductCollection CouponProducts = new CouponProductCollection();
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT CouponId");
selectQuery.Append(" FROM ac_CouponProducts");
selectQuery.Append(" WHERE ProductId = @productId");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@productId", System.Data.DbType.Int32, productId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
CouponProduct couponProduct = new CouponProduct();
couponProduct.ProductId = productId;
couponProduct.CouponId = dr.GetInt32(0);
CouponProducts.Add(couponProduct);
}
dr.Close();
}
return(CouponProducts);
}
){kind=link}
){kind=link}