public OrderDetailCollection GetAllOrderDetails()
{
string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount
from [Order Details]" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
OrderDetailCollection cc = new OrderDetailCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc);
cc.AcceptChanges();
return(cc);
}
public OrderDetailCollection GetOrderDetailsByOrderId(int OrderId)
{
string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount
from [Order Details] where OrderId = @OrderId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@OrderId", SqlDbType.Int, 0, "OrderId");
cmd.Parameters[0].Value = OrderId;
OrderDetailCollection cc = new OrderDetailCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc);
cc.AcceptChanges();
return(cc);
}
