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> 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));
}
Operations <T> manager = new Operations <T>(); // Operations classında ki metodlara ulaşmak için bir nesne oluşturuyoruz.
public List <T> getAllResolvedFault()
{
List <TablesFilterParameters> filters = new List <TablesFilterParameters>(); //
TablesFilterParameters filter = new TablesFilterParameters()
{
tableName = "faultInfos",
columnName = "statusID",
filterValue = "2"
};
filters.Add(filter);
return(manager.operation.getAll("faultInfos", null, filters));
}
public List <T> getAllSubCategory(string mainCategoryID) // alt kategorileri getir
{
List <TablesFilterParameters> filters = new List <TablesFilterParameters>();
TablesFilterParameters filter1 = new TablesFilterParameters()
{
tableName = "subCategory",
columnName = "subCategory_mainCatgID",
filterValue = mainCategoryID
};
filters.Add(filter1);
return(entities.operation.getAll("subCategory", null, filters));
}
