public List <PsLang> ListActive(Byte Active, UInt32 IDShop)
{
//System.Linq.IQueryable<PsLang> Return = from Table in this.DBPrestashop.PsLang
// where Table.Active == Active
// select Table;
//return Return.ToList();
return(DBPrestashop.ExecuteQuery <PsLang>(
"SELECT DISTINCT L.id_lang, L.name, L.active, L.iso_code, L.language_code, L.date_format_lite, L.date_format_full, L.is_rtl FROM ps_lang L " +
" INNER JOIN ps_lang_shop LS ON LS.id_lang = L.id_lang " +
" WHERE L.active = {0} AND LS.id_shop = {1} " +
" ", Active, IDShop).ToList());
}
public List <PsAttributeGroup> List(UInt32 IDShop)
{
//System.Linq.IQueryable<PsAttributeGroup> Return = from Table in this.DBPrestashop.PsAttributeGroup
// select Table;
//return Return.ToList();
List <PsAttributeGroup> attributes = new List <PsAttributeGroup>(
DBPrestashop.ExecuteQuery <PsAttributeGroup>(
"SELECT DISTINCT A.id_attribute_group, A.is_color_group, A.position FROM ps_attribute_group A " +
" INNER JOIN ps_attribute_group_shop ATS ON ATS.id_attribute_group = A.id_attribute_group " +
" WHERE ATS.id_shop = {0} " +
" ", IDShop));
return(attributes);
}
public List <ps_orders_resume> ListTopOrderResumeByDateAdd(Int32 Top, UInt32 Lang, UInt32 IDShop)
{
return(DBPrestashop.ExecuteQuery <ps_orders_resume>(
"SELECT " +
ps_fields_resume +
" FROM ps_orders as O " +
" LEFT JOIN ps_customer as C ON O.id_customer = C.id_customer " +
" LEFT JOIN ps_order_state_lang as OS ON O.current_state = OS.id_order_state " +
" WHERE O.id_shop = {0} AND OS.id_lang = {1} " +
((Core.Global.GetConfig().ConfigCommandeFiltreDate != null) ? " AND O.date_add >= '"
+ Core.Global.GetConfig().ConfigCommandeFiltreDate.Value.ToString("yyyy/MM/dd") + "'" : "") +
" ORDER BY " + ps_fields_resume_order +
" LIMIT {2} ", IDShop, Lang, Top).ToList());
}
public List <PsFeatureLang> ListLang(uint IdLang, uint IdShop)
{
//System.Linq.IQueryable<PsFeatureLang> Return = from Table in this.DBPrestashop.PsFeatureLang
// where Table.IDLang == IdLang
// select Table;
//return Return.ToList();
List <PsFeatureLang> attributes = new List <PsFeatureLang>(
DBPrestashop.ExecuteQuery <PsFeatureLang>(
"SELECT DISTINCT FL.id_feature, FL.id_lang, FL.name FROM ps_feature_lang FL " +
" INNER JOIN ps_feature_shop FS ON FS.id_feature = FL.id_feature " +
" WHERE FS.id_shop = {0} and FL.id_lang = {1} " +
" ", IdShop, IdLang));
return(attributes);
}
public List <PsProductAttribute> List(int articleId, UInt32 IDShop)
{
//System.Linq.IQueryable<PsProductAttribute> Return = from Table in this.DBPrestashop.PsProductAttribute
// where Table.IDProduct == articleId
// select Table;
//return Return.ToList();
List <PsProductAttribute> products = new List <PsProductAttribute>(
DBPrestashop.ExecuteQuery <PsProductAttribute>(
"SELECT DISTINCT P.* FROM ps_product_attribute P " +
" INNER JOIN ps_product_attribute_shop PS ON PS.id_product_attribute = P.id_product_attribute " +
" WHERE PS.id_shop = {0} " +
" ", IDShop));
return(products);
}
public List <PsCarrier> ListActive(Byte Active, UInt32 IDShop)
{
//System.Linq.IQueryable<PsCarrier> Return = from Table in this.DBPrestashop.PsCarrier
// where Table.Active == Active
// select Table;
//return Return.ToList();
return(DBPrestashop.ExecuteQuery <PsCarrier>(
"SELECT DISTINCT C.id_carrier, C.id_reference, C.id_tax_rules_group, C.name, " +
" C.url, C.active, C.deleted, C.shipping_handling, " +
" C.range_behavior, C.is_module, C.is_free, C.shipping_external, " +
" C.need_range, C.external_module_name, C.shipping_method, C.position, " +
" C.max_width, C.max_height, C.max_depth, C.max_weight, " +
" C.grade FROM ps_carrier C " +
" INNER JOIN ps_carrier_shop CS ON CS.id_carrier = C.id_carrier " +
" WHERE C.active = {0} AND CS.id_shop = {1} AND C.deleted = 0 " +
" ", Active, IDShop).ToList());
}