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