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);
