private bool LoadByPrimaryKeyDynamic(System.Int32 orderId, System.String couponCode) { OrderCouponQuery query = new OrderCouponQuery(); query.Where(query.OrderId == orderId, query.CouponCode == couponCode); return(this.Load(query)); }
public int GetNumberOfRedemptions() { //SELECT //COUNT(oc.CouponCode) as NumRedemptions //FROM DNNspot_Store_OrderCoupon oc //INNER JOIN DNNspot_Store_Order o ON o.Id = oc.OrderId //WHERE o.StoreId = @storeId AND CouponCode = @couponCode //GROUP BY oc.CouponCode OrderCouponQuery oc = new OrderCouponQuery("oc"); OrderQuery o = new OrderQuery("o"); oc.Select(oc.CouponCode.Count().As("NumRedemptions")); oc.InnerJoin(o).On(o.Id == oc.OrderId); oc.Where(o.StoreId == this.StoreId.Value, oc.CouponCode.ToUpper() == this.Code.ToUpper()); oc.GroupBy(oc.CouponCode); object scalar = oc.ExecuteScalar(); if (scalar != null) { return((int)scalar); } return(0); }