private void Populate() { OrderDetailPaging paging = new OrderDetailPaging(this.PagingControl1.PageIndex, this.PagingControl1.RecordsPerPage, OrderDetail.FieldNameConstants.OrderId, true); OrderDetailCollection orderDetailCollection = null; if (this.Request["orderid"] != null) { int orderId; int.TryParse(this.Request["orderid"], out orderId); orderDetailCollection = OrderDetailCollection.RunSelect(x => x.OrderId == orderId, paging); lblHeader.Text = "This is a list of all orders details for order <a href='/OrderItem.aspx?id=" + orderId + "'>" + orderId + "</a>."; } else if (this.Request["productid"] != null) { int productId = int.Parse(this.Request["productid"]); orderDetailCollection = OrderDetailCollection.RunSelect(x => x.ProductId == productId, paging); Product product = Product.SelectUsingPK(productId); lblHeader.Text = "This is a list of all orders details for product <a href='/ProductItem.aspx?id=" + product.ProductId + "'>" + product.ProductName + "</a>."; } else { orderDetailCollection = OrderDetailCollection.RunSelect(x => true, paging); lblHeader.Text = "This is a list of all order details."; } this.PagingControl1.ItemCount = paging.RecordCount; grdItem.DataSource = orderDetailCollection; grdItem.DataBind(); SessionHelper.LastOrderListSearch = this.Request.Url.AbsoluteUri; }
public OrderDetailCollection FetchAll() { OrderDetailCollection coll = new OrderDetailCollection(); Query qry = new Query(OrderDetail.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
private OrderCollection LoadAll() { OrderCollection Orders = _Dal.GetAllOrders(); foreach (Order order in Orders) { CustomerCollection customers = _Dal.GetCustomerByCustomerId(order.CustomerID); if (customers.Count > 0) { order.Customer = customers[0]; } OrderDetailCollection details = _Dal.GetOrderDetailsByOrderId(order.OrderID); foreach (OrderDetail detail in details) { order.OrderDetails.Add(detail); ProductCollection products = _Dal.GetProductByProductId(detail.ProductID); if (products.Count > 0) { detail.Product = products[0]; } } } return(Orders); }
//internal static void EmployeeProc(IDataReader dr, FieldDictionary Fields, object Param) //{ // EmployeeCollection coll = Param as EmployeeCollection; // Employee item = Mapper.ReadEmployee(dr, Fields); // coll.Add(item); //} internal static void OrderDetailProc(IDataReader dr, FieldDictionary Fields, object Param) { OrderDetailCollection coll = Param as OrderDetailCollection; OrderDetail item = Mapper.ReadOrderDetail(dr, Fields); coll.Add(item); }
private void productSelectComboBox_SelectedIndexChanged(object sender, System.EventArgs e) { // get the selected product if (productSelectComboBox.SelectedItem == null) { return; } ProductEntity selectedProduct = (ProductEntity)productSelectComboBox.SelectedItem; _productFilter.Value = selectedProduct.ProductId; // select the customers CustomerCollection customers = new CustomerCollection(); // select the customers using the relations and the filter we defined customers.GetMulti(_productFilter, 0, _customerSorter, _relationsToWalk); // bind them customersDataGrid.DataSource = customers; // get scalar for amount of times this product is sold. OrderDetailCollection orderDetails = new OrderDetailCollection(); object scalarValue = orderDetails.GetScalar( OrderDetailFieldIndex.Quantity, null, AggregateFunction.Sum, (OrderDetailFields.ProductId == selectedProduct.ProductId)); int amountUnitSold = 0; if (scalarValue != System.DBNull.Value) { amountUnitSold = (int)scalarValue; } _amountUnitsSoldTextBox.Text = amountUnitSold.ToString(); }
private void button1_Click(object sender, EventArgs e) { var headers = new OrderHeaderCollection(); var details = new OrderDetailCollection(); headers.Add(new OrderHeader() { OrderId = 6, CustomerId = 51, OrderedAt = Convert.ToDateTime("1/1/2008") }); details.Add(new OrderDetail() { OrderId = 6, LineNumber = 1, ProductId = 12, Quantity = 2, Price = 15.95m }); details.Add(new OrderDetail() { OrderId = 6, LineNumber = 2, ProductId = 57, Quantity = 1, Price = 59.99m }); details.Add(new OrderDetail() { OrderId = 6, LineNumber = 3, ProductId = 36, Quantity = 10, Price = 8.50m }); headers.Add(new OrderHeader() { OrderId = 7, CustomerId = 51, OrderedAt = Convert.ToDateTime("1/2/2008") }); details.Add(new OrderDetail() { OrderId = 7, LineNumber = 1, ProductId = 23, Quantity = 2, Price = 79.50m }); details.Add(new OrderDetail() { OrderId = 7, LineNumber = 2, ProductId = 78, Quantity = 1, Price = 3.25m }); using (var conn = new SqlConnection("Data Source=.;Initial Catalog=MyDb;Integrated Security=True;")) { conn.Open(); using (var cmd = new SqlCommand("uspInsertOrders", conn)) { cmd.CommandType = CommandType.StoredProcedure; var headersParam = cmd.Parameters.AddWithValue("@OrderHeaders", headers); var detailsParam = cmd.Parameters.AddWithValue("@OrderDetails", details); headersParam.SqlDbType = SqlDbType.Structured; detailsParam.SqlDbType = SqlDbType.Structured; cmd.ExecuteNonQuery(); } conn.Close(); } }
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 static OrderDetailCollection ToDtoCollection(this EntityCollection <OrderDetailEntity> entities) { OnBeforeEntityCollectionToDtoCollection(entities); var seenObjects = new Hashtable(); var collection = new OrderDetailCollection(); foreach (var entity in entities) { collection.Add(entity.ToDto(seenObjects, new Hashtable())); } OnAfterEntityCollectionToDtoCollection(entities, collection); return(collection); }
private void _ordersCManager_PositionChanged(object sender, EventArgs e) { // a new orders details collection has been bound. OrderDetailCollection currentOrderDetails = _currentCustomer.Orders[_ordersCManager.Position].OrderDetails; if (!_visitedOrderDetails.Contains(currentOrderDetails)) { // add handler currentOrderDetails.ListChanged += new ListChangedEventHandler(CurrentOrderDetails_ListChanged); _visitedOrderDetails.Add(currentOrderDetails); } removeOrderButton.Enabled = !_currentCustomer.Orders[_ordersCManager.Position].IsNew; }
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); }
public Product() { ProductId = Guid.NewGuid(); OrderDetails = new OrderDetailCollection(); }
public OrderDetailCollection FetchByQuery(Query qry) { OrderDetailCollection coll = new OrderDetailCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public OrderDetailCollection FetchByID(object OrderID) { OrderDetailCollection coll = new OrderDetailCollection().Where("OrderID", OrderID).Load(); return coll; }
/// <summary> /// /// <summary> internal Order(CustomerCollection customers /*, EmployeeCollection employees*/, OrderDetailCollection details) { _Customers = customers; // _Employees = employees; _OrderDetails = details; }
//private EmployeeCollection _Employees; //public EmployeeCollection Employees //{ // get { return _Employees; } //} /// <summary> /// Default Contructor /// <summary> public Order() { _Customers = new CustomerCollection(); // _Employees = new EmployeeCollection(); _OrderDetails = new OrderDetailCollection(); }
static partial void OnAfterEntityCollectionToDtoCollection(EntityCollection <OrderDetailEntity> entities, OrderDetailCollection dtos);