public OrderCollection FetchByQuery(Query qry) { OrderCollection coll = new OrderCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public OrderCollection FetchAll() { OrderCollection coll = new OrderCollection(); Query qry = new Query(Order.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static NorthwindAccess.OrderCollection GetOrderCollection(int varProductID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [Orders] INNER JOIN [Order Details] ON [Orders].[OrderID] = [Order Details].[OrderID] WHERE [Order Details].[ProductID] = PARM__ProductID", Product.Schema.Provider.Name); cmd.AddParameter("PARM__ProductID", varProductID, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); OrderCollection coll = new OrderCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SaveOrderMap(int varProductID, OrderCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [Order Details] WHERE [Order Details].[ProductID] = PARM__ProductID", Product.Schema.Provider.Name); cmdDel.AddParameter("PARM__ProductID", varProductID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Order item in items) { OrderDetail varOrderDetail = new OrderDetail(); varOrderDetail.SetColumnValue("ProductID", varProductID); varOrderDetail.SetColumnValue("OrderID", item.GetPrimaryKeyValue()); varOrderDetail.Save(); } }
public OrderCollection FetchByID(object OrderID) { OrderCollection coll = new OrderCollection().Where("OrderID", OrderID).Load(); return(coll); }