public CategoryCollection FetchByQuery(Query qry) { CategoryCollection coll = new CategoryCollection(); coll.Load(qry.ExecuteReader()); return(coll); }
public CategoryCollection FetchAll() { CategoryCollection coll = new CategoryCollection(); Query qry = new Query(Category.Schema); coll.Load(qry.ExecuteReader()); return(coll); }
public static Chapter08.NorthwindDAL.CategoryCollection GetCategoryCollection(int varProductID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM 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); 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 ProductID=@ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("@ProductID", varProductID); //add this in 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); }