/// <summary> /// Sets the sample customization settings. /// </summary> private void SampleCustomization() { this.sfDataGrid1.AllowEditing = true; this.sfDataGrid1.AllowGrouping = true; this.sfDataGrid1.ShowGroupDropArea = true; this.sfDataGrid1.AutoGenerateColumns = false; this.sfDataGrid1.AllowResizingColumns = true; this.sfDataGrid1.SelectionMode = GridSelectionMode.Multiple; NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalDigits = 0; nfi.NumberGroupSizes = new int[] { }; OrderInfoRepository orderInfo = new OrderInfoRepository(); this.sfDataGrid1.DataSource = orderInfo.GetOrdersDetails(30); this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerID", HeaderText = "Customer ID" }); this.sfDataGrid1.Columns.Add(new GridDateTimeColumn() { MappingName = "ShippingDate", HeaderText = "Shipping Date" }); this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "EmployeeID", HeaderText = "Employee ID", NumberFormatInfo = nfi }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity", HeaderText = "Ship City" }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCountry", HeaderText = "Ship Country" }); this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "Freight", HeaderText = "Freight", FormatMode = FormatMode.Currency }); this.sfDataGrid1.Columns.Add(new GridCheckBoxColumn() { MappingName = "IsClosed", HeaderText = "Is Closed", CheckBoxSize = new Size((int)DpiAware.LogicalToDeviceUnits(14.0f), (int)DpiAware.LogicalToDeviceUnits(14.0f)) }); #region Relation Creation GridViewDefinition viewDefinition = new GridViewDefinition(); viewDefinition.RelationalColumn = "OrderDetails"; SfDataGrid firstLevelSourceDataGrid = new SfDataGrid(); firstLevelSourceDataGrid.AutoGenerateColumns = false; firstLevelSourceDataGrid.RowHeight = (int)DpiAware.LogicalToDeviceUnits(21.0f); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "ProductID", HeaderText = "Product ID", NumberFormatInfo = nfi }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "UnitPrice", HeaderText = "Unit Price", FormatMode = FormatMode.Currency }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "Quantity", HeaderText = "Quantity", NumberFormatInfo = nfi }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "Discount", HeaderText = "Discount", NumberFormatInfo = nfi }); firstLevelSourceDataGrid.Columns.Add(new GridTextColumn() { MappingName = "CustomerID", HeaderText = "Customer ID" }); firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn() { MappingName = "OrderDate", HeaderText = "Order Date" }); viewDefinition.DataGrid = firstLevelSourceDataGrid; this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition); #endregion this.sfDataGrid1.HideEmptyGridViewDefinition = true; this.exportWholeGrid.Checked = true; }
/// <summary> /// Initializes a new instance of the <see cref="OrderInfoCollection"/> class. /// </summary> public OrderInfoCollection() { OrderInfoRepository order = new OrderInfoRepository(); OrdersDetails = order.GetOrdersDetails(100); }
/// <summary> /// Initializes a new instance of the <see cref="ShipCountries"/> class. /// </summary> public ShipCountries() { var model = new OrderInfoRepository(); this.AddRange(model.ShipCountries); }