public static SpecialOfferProduct AssociateSpecialOfferWithProduct
([ContributedAction("Special Offers")] SpecialOffer offer,
[ContributedAction("Special Offers")] Product product,
IFunctionalContainer container)
{
//First check if association already exists
IQueryable <SpecialOfferProduct> query = from sop in container.Instances <SpecialOfferProduct>()
where sop.SpecialOfferID == offer.SpecialOfferID &&
sop.ProductID == product.ProductID
select sop;
if (query.Count() != 0)
{
var t = Container.NewTitleBuilder();
t.Append(offer).Append(" is already associated with").Append(product);
WarnUser(t.ToString());
return(null);
}
var newSop = new SpecialOfferProduct();
newSop.SpecialOffer = offer;
newSop.Product = product;
//product.SpecialOfferProduct.Add(newSop);
Persist(ref newSop);
return(newSop);
}
public static (SpecialOffer, SpecialOffer) CreateMultipleSpecialOffers(
string description,
[Mask("P")] decimal discountPct,
string type,
string category,
int minQty,
DateTime startDate
)
{
var so = new SpecialOffer() with
{
Description = description,
DiscountPct = discountPct,
Type = type,
Category = category,
MinQty = minQty,
//Deliberately created non-current so they don't show up
//in Current Special Offers (but can be viewed via All Special Offers)
StartDate = startDate,
EndDate = new DateTime(2003, 12, 31)
};
return(so, so);
}
public static SpecialOffer CreateNewSpecialOffer()
{
var obj = new SpecialOffer();
//set up any parameters
//MakePersistent();
return(obj);
}
public SpecialOffer NoDiscount() {
if (_noDiscount == null) {
IQueryable<SpecialOffer> query = from obj in Instances<SpecialOffer>()
where obj.SpecialOfferID == 1
select obj;
_noDiscount = query.FirstOrDefault();
}
return _noDiscount;
}
public SpecialOffer NoDiscount()
{
if (_noDiscount == null)
{
IQueryable <SpecialOffer> query = from obj in Instances <SpecialOffer>()
where obj.SpecialOfferID == 1
select obj;
_noDiscount = query.FirstOrDefault();
}
return(_noDiscount);
}
public static SpecialOffer_Edit CreateFrom(SpecialOffer x)
=> new SpecialOffer_Edit
{
Category = x.Category,
Description = x.Description,
DiscountPct = x.DiscountPct,
EndDate = x.EndDate,
MaxQty = x.MaxQty,
MinQty = x.MinQty,
SpecialOfferID = x.SpecialOfferID,
StartDate = x.StartDate,
Type = x.Type
};
public SpecialOfferProduct AssociateSpecialOfferWithProduct(SpecialOffer offer, Product product) {
//First check if association already exists
IQueryable<SpecialOfferProduct> query = from sop in Instances<SpecialOfferProduct>()
where sop.SpecialOfferID == offer.SpecialOfferID &&
sop.ProductID == product.ProductID
select sop;
if (query.Count() != 0) {
var t = new TitleBuilder();
t.Append(offer).Append(" is already associated with").Append(product);
WarnUser(t.ToString());
return null;
}
var newSop = NewTransientInstance<SpecialOfferProduct>();
newSop.SpecialOffer = offer;
newSop.Product = product;
//product.SpecialOfferProduct.Add(newSop);
Persist(ref newSop);
return newSop;
}
public virtual SpecialOfferProduct BestSpecialOfferProduct(short quantity)
{
//reason for testing end date against 1/6/2004 is that in AW database, all offers terminate by 30/6/04
var query = from obj in Container.Instances <SpecialOfferProduct>()
where obj.Product.ProductID == ProductID &&
obj.SpecialOffer.StartDate <= DateTime.Now &&
obj.SpecialOffer.EndDate >= new DateTime(2004, 6, 1) &&
obj.SpecialOffer.MinQty < quantity
orderby obj.SpecialOffer.DiscountPct descending
select obj;
SpecialOfferProduct best = query.FirstOrDefault();
if (best != null)
{
return(best);
}
SpecialOffer none = SpecialOfferRepository.NoDiscount();
return(SpecialOfferRepository.AssociateSpecialOfferWithProduct(none, this));
}
public static void CreateMultipleSpecialOffers(
string description,
[Mask("P")] decimal discountPct,
string type,
string category,
int minQty,
DateTime startDate
)
{
var so = new SpecialOffer();
so.Description = description;
so.DiscountPct = discountPct;
so.Type = type;
so.Category = category;
so.MinQty = minQty;
//Deliberately created non-current so they don't show up
//in Current Special Offers (but can be viewed via All Special Offers)
so.StartDate = startDate;
so.EndDate = new DateTime(2003, 12, 31);
Container.Persist(ref so);
}
public static SpecialOffer Updating(SpecialOffer x, [Injected] DateTime now) => x with
/// <summary>
/// Deprecated Method for adding a new object to the SpecialOffers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSpecialOffers(SpecialOffer specialOffer)
{
base.AddObject("SpecialOffers", specialOffer);
}
/// <summary>
/// Create a new SpecialOffer object.
/// </summary>
/// <param name="specialOfferID">Initial value of the SpecialOfferID property.</param>
/// <param name="description">Initial value of the Description property.</param>
/// <param name="discountPct">Initial value of the DiscountPct property.</param>
/// <param name="type">Initial value of the Type property.</param>
/// <param name="category">Initial value of the Category property.</param>
/// <param name="startDate">Initial value of the StartDate property.</param>
/// <param name="endDate">Initial value of the EndDate property.</param>
/// <param name="minQty">Initial value of the MinQty property.</param>
/// <param name="rowguid">Initial value of the rowguid property.</param>
/// <param name="modifiedDate">Initial value of the ModifiedDate property.</param>
public static SpecialOffer CreateSpecialOffer(global::System.Int32 specialOfferID, global::System.String description, global::System.Decimal discountPct, global::System.String type, global::System.String category, global::System.DateTime startDate, global::System.DateTime endDate, global::System.Int32 minQty, global::System.Guid rowguid, global::System.DateTime modifiedDate)
{
SpecialOffer specialOffer = new SpecialOffer();
specialOffer.SpecialOfferID = specialOfferID;
specialOffer.Description = description;
specialOffer.DiscountPct = discountPct;
specialOffer.Type = type;
specialOffer.Category = category;
specialOffer.StartDate = startDate;
specialOffer.EndDate = endDate;
specialOffer.MinQty = minQty;
specialOffer.rowguid = rowguid;
specialOffer.ModifiedDate = modifiedDate;
return specialOffer;
}
public static SpecialOffer_Edit CreateNewSpecialOffer(this SpecialOffer x)
{
return(SpecialOffer_EditFunctions.CreateFrom(x));
}