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()); }