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