private bool LoadByPrimaryKeyDynamic(System.Int32 id)
{
ShippingServiceRateTypeQuery query = new ShippingServiceRateTypeQuery();
query.Where(query.Id == id);
return(this.Load(query));
}
protected void InitQuery(ShippingServiceRateTypeQuery query)
{
query.OnLoadDelegate = this.OnQueryLoaded;
if (!query.es2.HasConnection)
{
query.es2.Connection = ((IEntityCollection)this).Connection;
}
}
public static ShippingServiceRateType Find(int shippingServiceId, string name)
{
var q = new ShippingServiceRateTypeQuery();
q.Where(q.ShippingServiceId == shippingServiceId, q.Name == name);
ShippingServiceRateType shippingMethod = new ShippingServiceRateType();
return(shippingMethod.Load(q) ? shippingMethod : null);
}
public List <ShippingServiceRateType> GetAllRateTypes()
{
//List<ShippingServiceRateType> rateTypes = this.ShippingServiceRateTypeCollectionByShippingServiceId;
//rateTypes.Sort((left, right) => left.DisplayName.CompareTo(right.DisplayName));
//return rateTypes;
var q = new ShippingServiceRateTypeQuery();
q.Where(q.ShippingServiceId == this.Id);
q.OrderBy(q.SortOrder.Ascending, q.DisplayName.Ascending);
var collection = new ShippingServiceRateTypeCollection();
collection.Load(q);
return(collection.ToList());
}
public static List <ShippingServiceRateType> GetList(int storeId)
{
//SELECT
//rt.*
//FROM DNNspot_Store_ShippingServiceRateType rt
//INNER JOIN DNNspot_Store_ShippingService s ON rt.ShippingServiceId = s.Id
//WHERE s.StoreId = 1
var rt = new ShippingServiceRateTypeQuery("rt");
var s = new ShippingServiceQuery("s");
rt.Select(rt).InnerJoin(s).On(rt.ShippingServiceId == s.Id).Where(s.StoreId == storeId);
rt.OrderBy(rt.DisplayName.Ascending);
var collection = new ShippingServiceRateTypeCollection();
collection.Load(rt);
return(collection.ToList());
}
public bool Load(ShippingServiceRateTypeQuery query)
{
this.query = query;
InitQuery(this.query);
return(Query.Load());
}
