public List <T> getAllProducts(string subCategoryID) // tüm ürünleri getir
{
List <TablesFilterParameters> filters = new List <TablesFilterParameters>();
List <InnerJoinTableInfos> innertables = new List <InnerJoinTableInfos>();
InnerJoinTableInfos table1 = new InnerJoinTableInfos()
{
innerTableName = "brands",
baseTableColumn = "product_brandID",
innerTableColumn = "brand_id"
};
innertables.Add(table1);
TablesFilterParameters filter1 = new TablesFilterParameters()
{
tableName = "products",
columnName = "product_subCategoryID",
filterValue = subCategoryID
};
filters.Add(filter1);
return(entities.operation.getAll("products", innertables, filters));
}
public List <T> getAllSoldProducts() // Satılmış olan ürün bilgileri
{
List <InnerJoinTableInfos> innerTables = new List <InnerJoinTableInfos>(); // inner join yapılacak tablo listesi
InnerJoinTableInfos inner = new InnerJoinTableInfos()
{
baseTableColumn = "productSold_productID",
innerTableName = "products",
innerTableColumn = "product_ID"
};
List <TablesFilterParameters> filters = new List <TablesFilterParameters>(); // where koşulu uygulanacak tablo,column,value bilgileri
TablesFilterParameters filter = new TablesFilterParameters()
{
tableName = "soldProducts",
columnName = "productSold_reasonID",
filterValue = "1"
};
innerTables.Add(inner); // listeye oluşturduğumu kuralları ekliyoruz
filters.Add(filter); // listeye oluşturduğumu kuralları ekliyoruz
return(manager.operation.getAll("soldProducts", innerTables, filters));
}
public List <T> getAllProductsAndBrand() // ürün ve markalrı getir
{
List <InnerJoinTableInfos> innertables = new List <InnerJoinTableInfos>();
InnerJoinTableInfos table1 = new InnerJoinTableInfos()
{
innerTableName = "brands",
baseTableColumn = "product_brandID",
innerTableColumn = "brand_id"
};
innertables.Add(table1);
return(entities.operation.getAll("products", innertables));
}
