private bool LoadByPrimaryKeyDynamic(System.Int32 id)
{
ShippingServiceQuery query = new ShippingServiceQuery();
query.Where(query.Id == id);
return(this.Load(query));
}
protected void InitQuery(ShippingServiceQuery query)
{
query.OnLoadDelegate = this.OnQueryLoaded;
if (!query.es2.HasConnection)
{
query.es2.Connection = ((IEntityCollection)this).Connection;
}
}
public static ShippingService Find(int storeId, ShippingProviderType providerType)
{
var q = new ShippingServiceQuery();
q.Where(q.StoreId == storeId, q.ShippingProviderType == (short)providerType);
var service = new ShippingService();
if (service.Load(q))
{
return(service);
}
return(null);
}
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(ShippingServiceQuery query)
{
this.query = query;
InitQuery(this.query);
return(Query.Load());
}