public CategoryCollection FetchByQuery(Query qry) { CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public CategoryCollection FetchAll() { CategoryCollection coll = new CategoryCollection(); Query qry = new Query(Category.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static Northwind.CategoryCollection GetCategoryCollection(int varProductID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Categories] INNER JOIN [Product_Category_Map] ON [Categories].[CategoryID] = [Product_Category_Map].[CategoryID] WHERE [Product_Category_Map].[ProductID] = @ProductID", Product.Schema.Provider.Name); cmd.AddParameter("@ProductID", varProductID, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SaveCategoryMap(int varProductID, CategoryCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [Product_Category_Map] WHERE [Product_Category_Map].[ProductID] = @ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("@ProductID", varProductID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Category item in items) { ProductCategoryMap varProductCategoryMap = new ProductCategoryMap(); varProductCategoryMap.SetColumnValue("ProductID", varProductID); varProductCategoryMap.SetColumnValue("CategoryID", item.GetPrimaryKeyValue()); varProductCategoryMap.Save(); } }
public CategoryCollection FetchByID(object CategoryID) { CategoryCollection coll = new CategoryCollection().Where("CategoryID", CategoryID).Load(); return(coll); }