public override void Destroy ()
{
this.sfGrid.QueryRowHeight -= HandleQueryRowHeightEventHandler;
sfGrid.Dispose ();
sfGrid = null;
viewModel = null;
}
public override void Destroy ()
{
sfGrid.Dispose ();
sfGrid = null;
this.viewmodel.Dispose ();
this.viewmodel = null;
}
public Styles()
{
this.SfGrid = new SfDataGrid ();
viewmodel = new GridGettingStartedViewModel ();
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = viewmodel.OrdersInfo;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.SelectionMode = SelectionMode.Multiple;
this.SfGrid.GridViewCreated += SfGrid_GridViewCreated;
this.SfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription(){ColumnName ="CustomerID"});
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (25, 25, 25);
segmentControl = new UISegmentedControl();
segmentControl.ControlStyle = UISegmentedControlStyle.Bezeled;
segmentControl.InsertSegment("Dark", 0,true);
segmentControl.InsertSegment("Blue", 1, true);
segmentControl.InsertSegment("Red", 2, true);
segmentControl.InsertSegment("Green", 3, true);
segmentControl.SelectedSegment = 0;
segmentControl.ValueChanged += SegmentControl_ValueChanged;
this.control = this;
this.AddSubview (segmentControl);
this.AddSubview (SfGrid);
}
public override void Destroy()
{
sfGrid.AutoGeneratingColumn -= GridAutoGenerateColumns;
sfGrid.Dispose();
sfGrid = null;
viewModel = null;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new IncrementalLoadingViewModel (context);
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
sfGrid.ItemsSource = viewModel.GridSource;
sfGrid.AutoGeneratingColumn += GridAutoGeneratingColumns;
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new GettingStartedViewModel ();
viewModel.SetRowstoGenerate (100);
sfGrid.AutoGeneratingColumn += GridGenerateColumns;
sfGrid.ItemsSource = (viewModel.OrdersInfo);
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumn;
sfGrid.ItemsSource = new DataVirtualizationViewModel ().ViewSource;
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new SelectionViewModel ();
sfGrid.ItemsSource = (viewModel.ProductDetails);
sfGrid.AutoGeneratingColumn += OnAutoGenerateColumn;
sfGrid.SelectedIndex = 1;
sfGrid.SelectionMode = SelectionMode.Multiple;
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new GroupingViewModel ();
sfGrid.ItemsSource = viewModel.ProductDetails;
sfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription (){ ColumnName = "Product" });
sfGrid.AutoGeneratingColumn += OnAutoGenerateColumn;
sfGrid.QueryRowHeight += SfGrid_QueryRowHeight;
return sfGrid;
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid(context);
viewModel = new FrozenViewViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.Products;
sfGrid.FrozenRowsCount = 2;
sfGrid.FrozenColumnsCount = 1;
return sfGrid;
}
public FrozenView ()
{
sfGrid = new SfDataGrid ();
viewModel = new FrozenViewViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.Products;
sfGrid.FrozenRowsCount = 2;
sfGrid.FrozenColumnsCount = 1;
this.control = this;
this.AddSubview (sfGrid);
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new SalesInfoViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.DailySalesDetails;
sfGrid.AllowSorting = true;
sfGrid.SortComparers.Add(new SortComparer() { Comparer = new CustomSortComparer(), PropertyName = "Total" });
sfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription () { ColumnName = "Total", Converter = new GroupDataTimeConverter() });
return sfGrid;
}
public Selection()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.ItemsSource = new SelectionViewModel ().ProductDetails;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.SelectedIndex = 1;
this.SfGrid.SelectionMode = SelectionMode.Multiple;
this.control = this;
this.AddSubview(SfGrid);
}
public Grouping ()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.ItemsSource = new GroupingViewModel ().ProductDetails;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription (){ ColumnName = "Product" });
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.QueryRowHeight += SfGrid_QueryRowHeight;
this.control = this;
this.AddSubview (SfGrid);
}
public GridGettingStarted ()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new GridGettingStartedViewModel().OrdersInfo;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.control = this;
this.AddSubview (this.SfGrid);
}
public DataVirtualization()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new DataVirtualizationViewModel ().ViewSource;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.control = this;
this.AddSubview (SfGrid);
}
public IncrementalLoading()
{
this.SfGrid = new SfDataGrid ();
viewmodel = new IncrementalLoadingViewModel ();
this.SfGrid.ItemsSource = viewmodel.GridSource;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 52;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.SfGrid.AutoGeneratingColumn += GridAutoGeneratingColumns;
this.control = this;
this.AddSubview (SfGrid);
this.AddSubview(viewmodel.border);
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new CustomerViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.CustomerInformation;
sfGrid.AllowSorting = true;
sfGrid.AllowTriStateSorting = true;
sfGrid.AlternatingRowColor = Color.Rgb(206, 206, 206);
sfGrid.SortComparers.Add(new SortComparer () { Comparer = new CustomerInfo (), PropertyName="FirstName" });
sfGrid.SortColumnDescriptions.Add(new SortColumnDescription () { ColumnName = "FirstName", SortDirection = ListSortDirection.Descending });
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new SortingViewModel ();
viewModel.SetRowstoGenerate (100);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.Products;
sfGrid.AllowSorting = true;
sfGrid.AllowTriStateSorting = true;
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
this.sfGrid.SortColumnDescriptions.Add (new SortColumnDescription (){ ColumnName ="ProductID", SortDirection = Syncfusion.Linq.ListSortDirection.Descending });
return sfGrid;
}
public AutoRowHeight ()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.AllowSorting = false;
this.SfGrid.AllowTriStateSorting = false;
this.SfGrid.AlternationCount = 2;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new AutoRowHeightViewModel ().EmployeeInformation;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.QueryRowHeight += GridQueryRowHeight;
this.control = this;
this.AddSubview (SfGrid);
}
public CustomGrouping ()
{
sfGrid = new SfDataGrid ();
viewModel = new SalesInfoViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.DailySalesDetails;
sfGrid.AllowSorting = true;
this.sfGrid.HeaderRowHeight = 45;
this.sfGrid.RowHeight = 45;
sfGrid.SortComparers.Add (new SortComparer() { Comparer = new CustomSortComparer (), PropertyName = "Total" });
sfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription() { ColumnName = "Total", Converter = new GroupDataTimeConverter() });
this.control = this;
this.AddSubview (sfGrid);
}
public Sorting ()
{
this.SfGrid = new SfDataGrid ();
this.SfGrid.AllowSorting = true;
this.SfGrid.AllowTriStateSorting = true;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new SortViewModel ().Products;
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.SfGrid.SortColumnDescriptions.Add (new SortColumnDescription (){ ColumnName ="ProductID",SortDirection = Syncfusion.Linq.ListSortDirection.Descending });
this.control = this;
this.AddSubview (SfGrid);
}
public CustomSorting()
{
sfGrid = new SfDataGrid();
viewModel = new CustomerViewModel();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.CustomerInformation;
sfGrid.AllowSorting = true;
sfGrid.AllowTriStateSorting = true;
this.sfGrid.HeaderRowHeight = 45;
this.sfGrid.RowHeight = 45;
sfGrid.AlternatingRowColor = UIColor.FromRGB(219, 219, 219);
sfGrid.SortComparers.Add(new SortComparer() { Comparer = new CustomerInfo(), PropertyName = "FirstName" });
sfGrid.SortColumnDescriptions.Add(new SortColumnDescription() { ColumnName = "FirstName" });
this.control = this;
this.AddSubview(sfGrid);
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
GridTextColumn stockColumn = new GridTextColumn ();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.LoadUIView = true;
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
sfGrid.Columns.Add (stockColumn);
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = new RenderingDynamicDataViewModel ().Stocks;
return sfGrid;
}
public RenderingDynamicData ()
{
this.SfGrid = new SfDataGrid ();
GridTextColumn stockColumn = new GridTextColumn ();
stockColumn.UserCellType = typeof(StockCell);
stockColumn.MappingName = "StockChange";
stockColumn.HeaderText = "Stock Change";
stockColumn.AllowSorting = false;
this.SfGrid.Columns.Add (stockColumn);
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.ItemsSource = new StocksViewModel ().Stocks;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AlternatingRowColor = UIColor.FromRGB (219, 219, 219);
this.control = this;
this.AddSubview (SfGrid);
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
viewModel = new StylesViewModel ();
sfGrid.ItemsSource = (viewModel.OrdersInfo);
sfGrid.AutoGeneratingColumn += GridGenerateColumns;
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.GroupColumnDescriptions.Add (new GroupColumnDescription (){ ColumnName = "CustomerID" });
sfGrid.GridViewCreated += SfGrid_GridViewCreated;
sfGrid.QueryRowHeight += SfGrid_QueryRowHeight;
defaultStyle = new DataGridStyle ();
darkStyle = new Dark ();
blueStyle = new Blue ();
redStyle = new Red ();
greenStyle = new Green ();
return sfGrid;
}
public GridSelectionControllerExt(SfDataGrid dataGrid) : base(dataGrid)
{
datagrid = dataGrid;
}
//CustomPrintManager class constructor
public CustomPrintManager(SfDataGrid grid)
: base(grid)
{
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
GridImageColumn customerImageColumn = new GridImageColumn();
customerImageColumn.MappingName = "CustomerImage";
customerImageColumn.HeaderText = "Image";
GridSwitchColumn isOpenColumn = new GridSwitchColumn();
isOpenColumn.MappingName = "IsOpen";
isOpenColumn.HeaderText = "Is Open";
GridTextColumn customerIdColumn = new GridTextColumn();
customerIdColumn.MappingName = "CustomerID";
customerIdColumn.HeaderText = "Customer ID";
customerIdColumn.TextAlignment = GravityFlags.Center;
GridTextColumn branchNoColumn = new GridTextColumn();
branchNoColumn.MappingName = "BranchNo";
branchNoColumn.HeaderText = "Branch No";
branchNoColumn.TextAlignment = GravityFlags.Center;
GridTextColumn currentColumn = new GridTextColumn();
currentColumn.MappingName = "Current";
currentColumn.Format = "C";
currentColumn.CultureInfo = new CultureInfo("en-US");
currentColumn.TextAlignment = GravityFlags.Center;
GridTextColumn customerNameColumn = new GridTextColumn();
customerNameColumn.MappingName = "CustomerName";
customerNameColumn.HeaderText = "Customer Name";
customerNameColumn.TextAlignment = GravityFlags.CenterVertical;
GridTextColumn savingsColumn = new GridTextColumn();
savingsColumn.MappingName = "Savings";
savingsColumn.Format = "C";
savingsColumn.CultureInfo = new CultureInfo("en-US");
savingsColumn.TextAlignment = GravityFlags.Center;
sfGrid = new SfDataGrid(context);
sfGrid.AutoGenerateColumns = false;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.RowHeight = 70;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
sfGrid.Columns.Add(customerImageColumn);
sfGrid.Columns.Add(customerIdColumn);
sfGrid.Columns.Add(branchNoColumn);
sfGrid.Columns.Add(currentColumn);
sfGrid.Columns.Add(customerNameColumn);
sfGrid.Columns.Add(savingsColumn);
sfGrid.Columns.Add(isOpenColumn);
viewmodel = new FormattingViewModel();
sfGrid.ItemsSource = viewmodel.BankInfo;
return(sfGrid);
}
/// <summary>
/// Sets the sample customization settings.
/// </summary>
private void SampleCustomization()
{
#region SfDataGrid settings
sfDataGrid1.ThemeName = "Office2016Colorful";
sfDataGrid1.ShowRowHeader = true;
sfDataGrid1.AllowFiltering = true;
this.sfDataGrid1.AllowGrouping = true;
this.sfDataGrid1.ShowGroupDropArea = true;
this.sfDataGrid1.AutoGenerateColumns = false;
this.sfDataGrid1.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
OrderInfoRepository orderInfo = new OrderInfoRepository();
this.sfDataGrid1.DataSource = orderInfo.GetOrdersDetails(30);
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship Country"
});
this.sfDataGrid1.Columns.Add(new GridDateTimeColumn()
{
MappingName = "ShippingDate", HeaderText = "Shipping Date"
});
this.sfDataGrid1.Columns.Add(new GridNumericColumn()
{
MappingName = "Freight", HeaderText = "Freight", FormatMode = FormatMode.Currency
});
this.sfDataGrid1.Columns.Add(new GridCheckBoxColumn()
{
MappingName = "IsClosed", HeaderText = "Is Closed"
});
sfDataGrid1.AllowResizingColumns = true;
#endregion
#region themComboBox settings
List <ThemeTypes> theme = new List <ThemeTypes>();
theme.Add(new ThemeTypes()
{
ThemeName = "Office2016Black", Value = 1
});
theme.Add(new ThemeTypes()
{
ThemeName = "Office2016White", Value = 2
});
theme.Add(new ThemeTypes()
{
ThemeName = "Office2016DarkGray", Value = 3
});
theme.Add(new ThemeTypes()
{
ThemeName = "Office2016Colorful", Value = 4
});
comboBox1.DataSource = theme;
comboBox1.DisplayMember = "ThemeName";
comboBox1.ValueMember = "ThemeName";
comboBox1.SelectedValueChanged += comboBox1_SelectedValueChanged;
comboBox1.SelectedValue = "Office2016Colorful";
#endregion
this.checkBox1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Office2016Colorful;
checkBox1.CheckedChanged += checkBox1_CheckedChanged;
#region TableSummaryRow
GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow();
tableSummaryRow1.Name = "TableSummary";
tableSummaryRow1.ShowSummaryInRow = true;
tableSummaryRow1.Title = " Total Count: {OrderID}";
tableSummaryRow1.Position = VerticalPosition.Bottom;
GridSummaryColumn summaryColumn1 = new GridSummaryColumn();
summaryColumn1.Name = "OrderID";
summaryColumn1.SummaryType = SummaryType.DoubleAggregate;
summaryColumn1.Format = "{Count}";
summaryColumn1.MappingName = "OrderID";
tableSummaryRow1.SummaryColumns.Add(summaryColumn1);
this.sfDataGrid1.TableSummaryRows.Add(tableSummaryRow1);
#endregion
#region GroupSummaryRow
// Creates the GridSummaryRow.
GridSummaryRow groupSummaryRow1 = new GridSummaryRow();
groupSummaryRow1.Name = "GroupSummary";
groupSummaryRow1.ShowSummaryInRow = false;
groupSummaryRow1.Title = "Total $: { OrderID }";
// Creates the GridSummaryColumn.
GridSummaryColumn summaryColumn3 = new GridSummaryColumn();
summaryColumn3.Name = "OrderID";
summaryColumn3.SummaryType = SummaryType.DoubleAggregate;
summaryColumn3.Format = "Total : {Sum:c}";
summaryColumn3.MappingName = "OrderID";
// Adds the GridSummaryColumn in SummaryColumns collection.
groupSummaryRow1.SummaryColumns.Add(summaryColumn3);
// Adds the summary row in the GroupSummaryRows collection.
this.sfDataGrid1.GroupSummaryRows.Add(groupSummaryRow1);
#endregion
#region Relation Creation
GridViewDefinition viewDefinition = new GridViewDefinition();
viewDefinition.RelationalColumn = "OrderDetails";
firstLevelSourceDataGrid = new SfDataGrid();
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
});
firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn()
{
MappingName = "OrderDate", HeaderText = "Order Date"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerCity", HeaderText = "Customer City"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "ProductID", HeaderText = "Product ID", FormatMode = FormatMode.Numeric
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "UnitPrice", HeaderText = "Unit Price", FormatMode = FormatMode.Currency
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Quantity", HeaderText = "Quantity", FormatMode = FormatMode.Numeric
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Discount", HeaderText = "Discount", FormatMode = FormatMode.Percent
});
StackedHeaderRow stackedHeaderRow = new StackedHeaderRow();
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "OrderID,OrderDate", HeaderText = "Order Details"
});
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "CustomerID,CustomerCity", HeaderText = "Customer Details"
});
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "ProductID,UnitPrice,Quantity,Discount", HeaderText = "Product Details"
});
firstLevelSourceDataGrid.AllowResizingColumns = true;
firstLevelSourceDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
viewDefinition.DataGrid = firstLevelSourceDataGrid;
this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition);
#endregion
this.sfDataGrid1.HideEmptyGridViewDefinition = true;
}
private void CreateDataGrid()
{
_dataGrid = new SfDataGrid
{
EnableDataVirtualization = true,
AutoGenerateColumns = false,
AutoExpandGroups = false,
AllowGroupExpandCollapse = true,
LiveDataUpdateMode = LiveDataUpdateMode.AllowSummaryUpdate,
SelectionMode = Syncfusion.SfDataGrid.XForms.SelectionMode.SingleDeselect,
NavigationMode = NavigationMode.Cell,
FrozenColumnsCount = 2,
EditTapAction = TapAction.OnTap,
GridStyle = new BudgetDataGridStyle()
};
_dataGrid.SortComparers.Add(new SortComparer
{
PropertyName = "Category.Name",
Comparer = new BudgetCategorySortComparer()
});
_dataGrid.CurrentCellEndEdit += DataGrid_CurrentCellEndEdit;
_dataGrid.GroupColumnDescriptions.Add(new GroupColumnDescription
{
ColumnName = "Category.Name",
});
var gridSummaryRow = new GridGroupSummaryRow
{
ShowSummaryInRow = true,
Title = "{Key}: {Total}",
SummaryColumns = new ObservableCollection <ISummaryColumn>
{
new GridSummaryColumn
{
Name = "Total",
MappingName = "Subcat.Value",
SummaryType = SummaryType.Custom,
CustomAggregate = new CurrencyDataGridHeader(),
Format = "{Currency}",
}
},
};
_dataGrid.CaptionSummaryRow = gridSummaryRow;
_dataGrid.CaptionSummaryTemplate = new DataTemplate(() =>
{
var stackLayout = new StackLayout {
Orientation = StackOrientation.Horizontal, Margin = new Thickness(5, 0)
};
var label = new Label {
FontFamily = "FiraSans-Regular.otf#Fira Sans Regular", VerticalTextAlignment = TextAlignment.Center, FontSize = 16, TextColor = Color.Black
};
var icon = new Image {
HeightRequest = 25
};
icon.SetBinding(Image.SourceProperty, new Binding(".", BindingMode.Default, new BudgetGridIconConverter(), _dataGrid));
var converter = new BudgetDataGridSummaryConverter();
var binding = new Binding(".", BindingMode.Default, converter, _dataGrid);
label.SetBinding(Label.TextProperty, binding);
stackLayout.Children.Add(icon);
stackLayout.Children.Add(label);
return(new ViewCell {
View = stackLayout
});
});
_dataGrid.Columns.Add(new GridTextColumn
{
MappingName = "Subcat.Name",
HeaderText = "Kategoria",
Width = 100,
HeaderFont = "FiraSans-Bold.otf#Fira Sans Bold",
RecordFont = "FiraSans-Regular.otf#Fira Sans Regular",
HeaderCellTextSize = 16,
LoadUIView = true
});
_dataGrid.Columns.Add(new GridNumericColumn
{
MappingName = "SubcatReal.Value",
HeaderText = "Suma",
HeaderFont = "FiraSans-Bold.otf#Fira Sans Bold",
RecordFont = "FiraSans-Bold.otf#Fira Sans Bold",
LoadUIView = true,
CellTextSize = 10,
HeaderCellTextSize = 16,
DisplayBinding = new Binding()
{
Path = "SubcatReal.Value", Converter = new CurrencyValueConverter()
}
});
for (int i = 0; i < 31; i++)
{
_dataGrid.Columns.Add(new GridNumericColumn
{
MappingName = $"SubcatReal.Values[{i}].Value",
HeaderText = (i + 1).ToString(),
AllowEditing = true,
//LoadUIView = true,
HeaderFont = "FiraSans-Bold.otf#Fira Sans Bold",
RecordFont = "FiraSans-Regular.otf#Fira Sans Regular",
CellTextSize = 10,
HeaderCellTextSize = 16,
HeaderFontAttribute = FontAttributes.Bold,
DisplayBinding = new Binding()
{
Path = $"SubcatReal.Values[{i}].Value", Converter = new CurrencyValueConverter()
}
});
}
_dataGrid.SetBinding(SfDataGrid.ItemsSourceProperty, nameof(BudgetData));
mainLayout.Children.Add(_dataGrid);
}
public GridColumnAutoSizerExt(SfDataGrid grid) : base(grid)
{
}
/// <summary>
/// Sets the sample customization settings.
/// </summary>
private void SampleCustomization()
{
this.sfDataGrid1.AllowEditing = true;
this.sfDataGrid1.AllowGrouping = true;
this.sfDataGrid1.AutoGenerateColumns = false;
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 = "رقم التعريف الخاص بالطلب", NumberFormatInfo = nfi
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "مدينة السفن"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCountry", HeaderText = "السفينة البلد"
});
this.sfDataGrid1.Columns.Add(new GridDateTimeColumn()
{
MappingName = "ShippingDate", HeaderText = "السفينة البلد"
});
this.sfDataGrid1.Columns.Add(new GridNumericColumn()
{
MappingName = "Freight", HeaderText = "شحن", FormatMode = FormatMode.Currency
});
this.sfDataGrid1.Columns.Add(new GridCheckBoxColumn()
{
MappingName = "IsClosed", HeaderText = "مغلق", 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.Columns.Add(new GridNumericColumn()
{
MappingName = "OrderID", HeaderText = "رقم التعريف الخاص بالطلب", NumberFormatInfo = nfi
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "Product", HeaderText = "المنتج"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerCity", HeaderText = "مدينة العملاء"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "ProductID", HeaderText = "معرف المنتج", FormatMode = FormatMode.Numeric, NumberFormatInfo = nfi
});
//firstLevelSourceDataGrid.Columns.Add(new GridHyperlinkColumn() { MappingName = "HyperLink", HeaderText = "الارتباط التشعبي" });
firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn()
{
MappingName = "OrderDate", HeaderText = "تاريخ الطلب"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "UnitPrice", HeaderText = "سعر الوحدة", FormatMode = FormatMode.Currency
});
CellStyleInfo cellStyle = new CellStyleInfo();
cellStyle.HorizontalAlignment = HorizontalAlignment.Right;
firstLevelSourceDataGrid.Columns.Add(new GridUnboundColumn()
{
MappingName = "QuantitiesPrice", HeaderText = "المجموع الكلي", Expression = "UnitPrice * Quantity", CellStyle = cellStyle
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Discount", HeaderText = "خصم", FormatMode = FormatMode.Percent
});
firstLevelSourceDataGrid.Columns.Add(new GridImageColumn()
{
MappingName = "ImageLink", HeaderText = "بلد", ImageLayout = ImageLayout.Center
});
(firstLevelSourceDataGrid.Columns["ImageLink"] as GridImageColumn).CellStyle.VerticalAlignment = System.Windows.Forms.VisualStyles.VerticalAlignment.Center;
(firstLevelSourceDataGrid.Columns["ImageLink"] as GridImageColumn).CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
viewDefinition.DataGrid = firstLevelSourceDataGrid;
this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition);
firstLevelSourceDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
this.sfDataGrid1.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
#endregion
this.sfDataGrid1.HideEmptyGridViewDefinition = true;
}
/// <summary>
/// Sets the sample customization settings.
/// </summary>
private void SampleCustomization()
{
this.sfDataGrid1.AllowEditing = true;
this.sfDataGrid1.AllowGrouping = true;
this.sfDataGrid1.AutoGenerateColumns = false;
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 GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCountry", HeaderText = "Ship Country"
});
this.sfDataGrid1.Columns.Add(new GridDateTimeColumn()
{
MappingName = "ShippingDate", HeaderText = "Shipping Date"
});
this.sfDataGrid1.Columns.Add(new GridNumericColumn()
{
MappingName = "Freight", HeaderText = "Freight", FormatMode = FormatMode.Currency
});
this.sfDataGrid1.Columns.Add(new GridCheckBoxColumn()
{
MappingName = "IsClosed", HeaderText = "Is Closed"
});
#region Relation Creation
GridViewDefinition viewDefinition = new GridViewDefinition();
viewDefinition.RelationalColumn = "OrderDetails";
SfDataGrid firstLevelSourceDataGrid = new SfDataGrid();
firstLevelSourceDataGrid.AutoGenerateColumns = false;
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerCity", HeaderText = "Customer City"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "ProductID", HeaderText = "Product ID", FormatMode = FormatMode.Numeric, NumberFormatInfo = nfi
});
firstLevelSourceDataGrid.Columns.Add(new GridHyperlinkColumn()
{
MappingName = "HyperLink", HeaderText = "HyperLink"
});
firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn()
{
MappingName = "OrderDate", HeaderText = "Order Date"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "UnitPrice", HeaderText = "Unit Price", FormatMode = FormatMode.Currency
});
CellStyleInfo cellStyle = new CellStyleInfo();
cellStyle.HorizontalAlignment = HorizontalAlignment.Right;
firstLevelSourceDataGrid.Columns.Add(new GridUnboundColumn()
{
MappingName = "QuantitiesPrice", HeaderText = "Grand Total", Expression = "UnitPrice * Quantity", CellStyle = cellStyle
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Discount", HeaderText = "Discount", FormatMode = FormatMode.Percent
});
firstLevelSourceDataGrid.Columns.Add(new GridImageColumn()
{
MappingName = "ImageLink", HeaderText = "Country", ImageLayout = ImageLayout.Center
});
(firstLevelSourceDataGrid.Columns["ImageLink"] as GridImageColumn).CellStyle.VerticalAlignment = VerticalAlignment.Center;
(firstLevelSourceDataGrid.Columns["ImageLink"] as GridImageColumn).CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
viewDefinition.DataGrid = firstLevelSourceDataGrid;
this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition);
#endregion
this.sfDataGrid1.HideEmptyGridViewDefinition = true;
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
FrameLayout frame = new FrameLayout(context);
linear = new LinearLayout(context);
linear.LayoutParameters = new ViewGroup.LayoutParams(ViewGroup.LayoutParams.MatchParent, ViewGroup.LayoutParams.MatchParent);
linear.Orientation = Orientation.Horizontal;
TextView swipeViewUndo = new TextView(context);
swipeViewUndo.Text = "UNDO";
swipeViewUndo.SetTypeface(swipeViewUndo.Typeface, TypefaceStyle.Bold);
swipeViewUndo.Gravity = GravityFlags.Center;
swipeViewUndo.SetTextColor(Color.White);
swipeViewUndo.SetBackgroundColor(Color.ParseColor("#1AAA87"));
swipeViewUndo.Click += swipeViewUndo_Click;
TextView swipeViewText = new TextView(context);
swipeViewText.SetPadding((int)(25 * context.Resources.DisplayMetrics.Density), 0, 0, 0);
swipeViewText.Text = "Deleted";
swipeViewText.Gravity = GravityFlags.CenterVertical | GravityFlags.Left;
swipeViewText.SetTextColor(Color.White);
swipeViewText.SetBackgroundColor(Color.ParseColor("#1AAA87"));
linear.SetBackgroundColor(Color.ParseColor("#1AAA87"));
viewModel = new SwipingViewModel();
viewModel.SetRowstoGenerate(100);
sfGrid = new SfDataGrid(context);
sfGrid.AutoGenerateColumns = false;
sfGrid.ItemsSource = (viewModel.OrdersInfo);
sfGrid.AllowSwiping = true;
sfGrid.ColumnSizer = ColumnSizer.Star;
DisplayMetrics metrics = context.Resources.DisplayMetrics;
int width = metrics.WidthPixels;
sfGrid.MaxSwipeOffset = width;
swipe = new SwipeView(context);
var undoWidth = (int)(100 * context.Resources.DisplayMetrics.Density);
linear.AddView(swipeViewText, (sfGrid.MaxSwipeOffset - undoWidth), (int)sfGrid.RowHeight);
linear.AddView(swipeViewUndo, undoWidth, (int)sfGrid.RowHeight);
swipe.SetBackgroundColor(Color.ParseColor("#1AAA87"));
swipe.AddView(linear);
sfGrid.LeftSwipeView = swipe;
sfGrid.RightSwipeView = swipe;
sfGrid.SwipeEnded += sfGrid_SwipeEnded;
sfGrid.SwipeStarted += sfGrid_SwipeStarted;
GridTextColumn CustomerID = new GridTextColumn();
CustomerID.MappingName = "CustomerID";
CustomerID.HeaderText = "Customer ID";
GridTextColumn OrderID = new GridTextColumn();
OrderID.MappingName = "OrderID";
OrderID.HeaderText = "Order ID";
GridTextColumn EmployeeID = new GridTextColumn();
EmployeeID.MappingName = "EmployeeID";
EmployeeID.HeaderText = "Employee ID";
GridTextColumn Name = new GridTextColumn();
Name.MappingName = "FirstName";
Name.HeaderText = "Name";
sfGrid.Columns.Add(OrderID);
sfGrid.Columns.Add(CustomerID);
sfGrid.Columns.Add(EmployeeID);
sfGrid.Columns.Add(Name);
frame.AddView(sfGrid);
return(frame);
}
/// <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"
});
#region Relation Creation
GridViewDefinition viewDefinition = new GridViewDefinition();
viewDefinition.RelationalColumn = "OrderDetails";
SfDataGrid firstLevelSourceDataGrid = new SfDataGrid();
firstLevelSourceDataGrid.AutoGenerateColumns = false;
firstLevelSourceDataGrid.RowHeight = 21;
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.exportAllRecords.Checked = true;
}
public CustomRowSelectionController(SfDataGrid sfDataGrid)
: base(sfDataGrid)
{
this.DataGrid = sfDataGrid;
}
public UnboundColumn()
{
this.SfGrid = new SfDataGrid();
this.SfGrid.ColumnSizer = ColumnSizer.Auto;
this.SfGrid.SelectionMode = SelectionMode.Single;
this.SfGrid.AutoGenerateColumns = false;
this.SfGrid.ItemsSource = new UnboundViewModel().Products;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.GridStyle = new Blue();
this.SfGrid.AllowResizingColumn = true;
this.SfGrid.GridStyle = new CustomGridStyle();
SfGrid.CellRenderers.Remove("Unbound");
SfGrid.CellRenderers.Add("Unbound", new UnboundColumnRenderer());
SfGrid.CellRenderers.Remove("TextView");
SfGrid.CellRenderers.Add("TextView", new TextRenderer());
GridTextColumn ProductName = new GridTextColumn();
ProductName.HeaderText = "Product Name";
ProductName.LineBreakMode = UILineBreakMode.WordWrap;
ProductName.TextAlignment = UITextAlignment.Left;
ProductName.HeaderTextAlignment = UITextAlignment.Center;
//ProductName.HeaderCellTextSize = 12;
ProductName.MappingName = "ProductName";
SfGrid.Columns.Add(ProductName);
GridTextColumn UnitPrice = new GridTextColumn();
UnitPrice.HeaderText = "Price";
UnitPrice.Format = "C";
UnitPrice.HeaderTextAlignment = UITextAlignment.Center;
//UnitPrice.HeaderCellTextSize = 12;
UnitPrice.TextAlignment = UITextAlignment.Center;
UnitPrice.MappingName = "UnitPrice";
SfGrid.Columns.Add(UnitPrice);
GridTextColumn Quantity = new GridTextColumn();
Quantity.HeaderText = "Quantity";
Quantity.HeaderTextAlignment = UITextAlignment.Center;
//Quantity.HeaderCellTextSize = 12;
Quantity.MappingName = "Quantity";
Quantity.TextAlignment = UITextAlignment.Center;
SfGrid.Columns.Add(Quantity);
GridTextColumn Discount = new GridTextColumn();
Discount.TextAlignment = UITextAlignment.Center;
Discount.HeaderText = "Discount";
Discount.HeaderTextAlignment = UITextAlignment.Center;
Discount.HeaderCellTextSize = UIFont.SystemFontOfSize(12);
Discount.TextAlignment = UITextAlignment.Center;
Discount.MappingName = "Discount";
SfGrid.Columns.Add(Discount);
GridUnboundColumn Total = new GridUnboundColumn();
Total.TextAlignment = UITextAlignment.Center;
Total.Expression = "(Quantity * UnitPrice) - ((Quantity * UnitPrice)/100 * Quantity)";
Total.Format = "C";
Total.HeaderText = "Total";
Total.TextAlignment = UITextAlignment.Center;
Total.MappingName = "Total";
SfGrid.Columns.Add(Total);
foreach (GridColumn column in SfGrid.Columns)
{
if (UserInterfaceIdiomIsPhone)
{
SfGrid.ColumnSizer = ColumnSizer.None;
}
else
{
SfGrid.ColumnSizer = ColumnSizer.Star;
}
}
this.AddSubview(SfGrid);
}
public override View GetSampleContent(Context con)
{
LinearLayout linear = new LinearLayout(con);
linear.SetBackgroundColor(Color.White);
linear.Orientation = Orientation.Vertical;
linear.SetPadding(10, 10, 10, 10);
TextView text2 = new TextView(con);
text2.TextSize = 17;
text2.TextAlignment = TextAlignment.Center;
text2.Text = "This sample allows you to import/export data from/to Business Objects.";
text2.SetTextColor(Color.ParseColor("#262626"));
text2.SetPadding(5, 5, 5, 5);
linear.AddView(text2);
m_context = con;
Button btnInput = new Button(con);
btnInput.Text = "Input Template";
btnInput.Click += ButtonInputClicked;
linear.AddView(btnInput);
Button btnImport = new Button(con);
btnImport.Text = "Import From Excel";
btnImport.Click += ButtonImportClicked;
linear.AddView(btnImport);
btnExport = new Button(con);
btnExport.Text = "Export To Excel";
btnExport.Click += ButtonExportClicked;
btnExport.Enabled = false;
linear.AddView(btnExport);
sfGrid = new SfDataGrid(con);
viewmodel = new BusinessObjectViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.SelectionMode = SelectionMode.None;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.CustomersInfo;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
GridTextColumn salesPerson = new GridTextColumn();
salesPerson.MappingName = "SalesPerson";
salesPerson.HeaderText = "Name";
//salesPerson.ItemsSource = viewmodel.CustomersInfo;
salesPerson.HeaderTextAlignment = GravityFlags.Center;
GridTextColumn salesJanJune = new GridTextColumn();
salesJanJune.MappingName = "SalesJanJune";
salesJanJune.HeaderText = "Jan-June";
// salesJanJune.ItemsSource = viewmodel.CustomersInfo;
salesJanJune.HeaderTextAlignment = GravityFlags.Center;
GridTextColumn salesJulyDec = new GridTextColumn();
salesJulyDec.MappingName = "SalesJulyDec";
salesJulyDec.HeaderText = "July-Dec";
//salesJulyDec.ItemsSource = viewmodel.CustomersInfo;
salesJulyDec.HeaderTextAlignment = GravityFlags.Center;
GridTextColumn change = new GridTextColumn();
change.MappingName = "Change";
change.HeaderText = "Change";
//salesJulyDec.ItemsSource = viewmodel.CustomersInfo;
change.HeaderTextAlignment = GravityFlags.Center;
sfGrid.Columns.Add(salesPerson);
sfGrid.Columns.Add(salesJanJune);
sfGrid.Columns.Add(salesJulyDec);
sfGrid.Columns.Add(change);
linear.AddView(sfGrid);
return(linear);
}
/// <summary>
/// Method executes when dependency property changes
/// </summary>
/// <param name="obj">Specifies the dependency object.</param>
/// <param name="args">Specifies the event.</param>
public static void OnSfDataGridChanged(DependencyObject obj, DependencyPropertyChangedEventArgs args)
{
dataGrid = obj as SfDataGrid;
}
/// <summary>
/// Sets the data grid.
/// </summary>
/// <param name="obj">Specifies the dependency object.</param>
/// <param name="value">Specifies the window.</param>
public static void SetSfDataGrid(DependencyObject obj, SfDataGrid value)
{
obj.SetValue(SfDataGridProperty, value);
}
private void CreateDataGrid()
{
col1 = new UILabel();
col1.Text = "Order ID";
col2 = new UILabel();
col2.Text = "Customer ID";
col3 = new UILabel();
col3.Text = "Employee ID";
col4 = new UILabel();
col4.Text = "Name";
orderIDText = new UITextField();
orderIDText.AllowsEditingTextAttributes = true;
orderIDText.ShouldReturn += (textField) =>
{
orderIDText.ResignFirstResponder();
return(true);
};
customerIDText = new UITextField();
customerIDText.ShouldReturn += (textField) =>
{
customerIDText.ResignFirstResponder();
return(true);
};
employeeIDText = new UITextField();
employeeIDText.ShouldReturn += (textField) =>
{
employeeIDText.ResignFirstResponder();
return(true);
};
nameText = new UITextField();
nameText.ShouldReturn += (textField) =>
{
nameText.ResignFirstResponder();
return(true);
};
orderIDText.Hidden = true;
customerIDText.Hidden = true;
employeeIDText.Hidden = true;
nameText.Hidden = true;
col1.Hidden = true;
col2.Hidden = true;
col3.Hidden = true;
col4.Hidden = true;
this.detailView = new DetailView();
this.detailView.Hidden = true;
this.SfGrid = new SfDataGrid();
this.SfGrid.GridLoaded += SfGrid_GridLoaded;
this.SfGrid.AllowDraggingRow = true;
this.SfGrid.AllowEditing = true;
this.SfGrid.AllowResizingColumn = true;
this.viewModel = new SwipingViewModel();
this.SfGrid.ItemsSource = viewModel.OrdersInfo;
this.SfGrid.AutoGenerateColumns = false;
this.SfGrid.GridStyle = new CustomStyles();
this.SfGrid.ShowRowHeader = false;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.ColumnSizer = ColumnSizer.Star;
UIButton leftSwipeViewText = new UIButton();
leftSwipeViewText.SetTitle("Delete", UIControlState.Normal);
leftSwipeViewText.SetTitleColor(UIColor.White, UIControlState.Normal);
leftSwipeViewText.VerticalAlignment = UIControlContentVerticalAlignment.Center;
leftSwipeViewText.BackgroundColor = UIColor.FromRGB(220, 89, 95);
leftSwipeViewText.TouchDown += LeftSwipeViewButton_TouchDown;
leftSwipeViewText.Frame = new CGRect(56, 0, 60, 45);
UIButton leftSwipeViewButton = new UIButton();
leftSwipeViewButton.SetImage(UIImage.FromFile("Images/Popup_Delete.png"), UIControlState.Normal);
leftSwipeViewButton.BackgroundColor = UIColor.FromRGB(220, 89, 95);
leftSwipeViewButton.HorizontalAlignment = UIControlContentHorizontalAlignment.Center;
leftSwipeViewButton.TouchDown += LeftSwipeViewButton_TouchDown;
leftSwipeViewButton.Frame = new CGRect(16, 10, 24, 24);
CustomSwipeView leftSwipeView = new CustomSwipeView();
leftSwipeView.AddSubview(leftSwipeViewButton);
leftSwipeView.AddSubview(leftSwipeViewText);
leftSwipeView.Frame = new CGRect(0, 0, 120, 44);
leftSwipeView.BackgroundColor = UIColor.FromRGB(220, 89, 95);
this.SfGrid.AllowSwiping = true;
this.SfGrid.LeftSwipeView = leftSwipeView;
this.SfGrid.SwipeEnded += SfGrid_SwipeEnded;
this.SfGrid.SwipeStarted += SfGrid_SwipeStarted;
GridTextColumn CustomerID = new GridTextColumn();
CustomerID.MappingName = "CustomerID";
CustomerID.HeaderText = "Customer ID";
GridTextColumn OrderID = new GridTextColumn();
OrderID.MappingName = "OrderID";
OrderID.HeaderText = "Order ID";
GridTextColumn EmployeeID = new GridTextColumn();
EmployeeID.MappingName = "EmployeeID";
EmployeeID.HeaderText = "Employee ID";
GridTextColumn Name = new GridTextColumn();
Name.MappingName = "FirstName";
Name.HeaderText = "Name";
this.SfGrid.Columns.Add(OrderID);
this.SfGrid.Columns.Add(CustomerID);
this.SfGrid.Columns.Add(EmployeeID);
this.SfGrid.Columns.Add(Name);
}
public override void Destroy()
{
this.sfGrid.AutoGeneratingColumn -= GridAutoGenerateColumns;
sfGrid.Dispose();
sfGrid = null;
}
public DetailsViewGridManager(SfDataGrid dataGrid) : base(dataGrid)
{
}
public StockMovementReportVM(SfDataGrid _Report)
{
this.Report = _Report;
FDate = TDate = DateTime.Today;
GetAllList();
}
public GridSelectionControllerExt(SfDataGrid datagrid, Func <KeyEventArgs, bool> keyDown, Func <GridPointerEventArgs, RowColumnIndex, bool> pointerOperation = null) : base(datagrid)
{
_keyDown = keyDown;
_pointerOperation = pointerOperation;
}
public override void Destroy()
{
sfGrid.Dispose();
sfGrid = null;
viewModel = null;
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
parentLayout = new FrameLayout(context);
optionHeading = new TextView(context);
optionHeading.Gravity = GravityFlags.CenterHorizontal;
body = new LinearLayout(context);
optionView = new LinearLayout(context);
optionView.SetBackgroundColor(Color.Gray);
editor = new LinearLayout(context);
bottom = new LinearLayout(context);
bodyRow1 = new LinearLayout(context);
bodyRow1.Orientation = Android.Widget.Orientation.Horizontal;
bodyRow1.SetGravity(GravityFlags.CenterHorizontal);
bodyRow2 = new LinearLayout(context);
bodyRow2.Orientation = Android.Widget.Orientation.Horizontal;
bodyRow2.SetGravity(GravityFlags.CenterHorizontal);
bodyRow3 = new LinearLayout(context);
bodyRow3.Orientation = Android.Widget.Orientation.Horizontal;
bodyRow3.SetGravity(GravityFlags.CenterHorizontal);
bodyRow4 = new LinearLayout(context);
bodyRow4.Orientation = Android.Widget.Orientation.Horizontal;
bodyRow4.SetGravity(GravityFlags.CenterHorizontal);
col1 = new TextView(context);
col1.Text = "Order ID";
col2 = new TextView(context);
col2.Text = "Customer ID";
col3 = new TextView(context);
col3.Text = "Employee ID";
col4 = new TextView(context);
col4.Text = "Name";
orderIDText = new EditText(context);
orderIDText.Gravity = GravityFlags.Start;
customerIDText = new EditText(context);
employeeIDText = new EditText(context);
nameText = new EditText(context);
save = new Button(context);
save.Click += save_Click;
cancel = new Button(context);
cancel.Click += cancel_Click;
editView = new LinearLayout(context);
editView.TextAlignment = TextAlignment.Center;
editView.Orientation = Android.Widget.Orientation.Horizontal;
editView.Click += editView_Click;
deleteView = new LinearLayout(context);
deleteView.TextAlignment = TextAlignment.Center;
deleteView.Orientation = Android.Widget.Orientation.Horizontal;
deleteView.Click += swipeViewImage_Click;
ImageView editImage = new ImageView(context);
editImage.SetImageResource(Resource.Drawable.Edit);
editImage.SetBackgroundColor(Color.ParseColor("#42A5F5"));
editImage.SetPadding((int)(10 * Resources.System.DisplayMetrics.Density), 0, 0, 0);
TextView edit = new TextView(context);
edit.Text = "EDIT";
edit.TextAlignment = TextAlignment.Center;
edit.Gravity = GravityFlags.Center;
edit.SetTextColor(Color.White);
//edit.SetPadding((int)(16 * Resources.System.DisplayMetrics.Density), 0, (int)(16 * Resources.System.DisplayMetrics.Density), 0);
edit.SetBackgroundColor(Color.ParseColor("#42A5F5"));
ImageView deleteImage = new ImageView(context);
deleteImage.SetImageResource(Resource.Drawable.Delete);
deleteImage.SetBackgroundColor(Color.ParseColor("#EF5350"));
deleteImage.SetPadding((int)(5 * Resources.System.DisplayMetrics.Density), 0, 0, 0);
TextView delete = new TextView(context);
delete.Text = "DELETE";
delete.TextAlignment = TextAlignment.Center;
delete.Gravity = GravityFlags.Center;
//delete.SetPadding((int)(14 * Resources.System.DisplayMetrics.Density), 0, (int)(10 * Resources.System.DisplayMetrics.Density), (int)(14 * Resources.System.DisplayMetrics.Density));
delete.SetTextColor(Color.White);
delete.SetBackgroundColor(Color.ParseColor("#EF5350"));
viewModel = new SwipingViewModel();
viewModel.SetRowstoGenerate(100);
sfGrid = new SfDataGrid(context);
sfGrid.AutoGenerateColumns = false;
sfGrid.ItemsSource = (viewModel.OrdersInfo);
sfGrid.AllowSwiping = true;
sfGrid.RowHeight = 70;
sfGrid.ColumnSizer = ColumnSizer.Star;
DisplayMetrics metrics = context.Resources.DisplayMetrics;
int width = metrics.WidthPixels;
sfGrid.MaxSwipeOffset = (int)(100 * metrics.Density);
leftSwipeView = new SwipeView(context);
rightSwipeView = new SwipeView(context);
editView.AddView(editImage, (int)(30 * Resources.System.DisplayMetrics.Density), (int)sfGrid.RowHeight);
editView.AddView(edit, sfGrid.MaxSwipeOffset - 30, (int)sfGrid.RowHeight);
deleteView.AddView(deleteImage, (int)(30 * Resources.System.DisplayMetrics.Density), (int)sfGrid.RowHeight);
deleteView.AddView(delete, sfGrid.MaxSwipeOffset - 30, (int)sfGrid.RowHeight);
leftSwipeView.AddView(editView, sfGrid.MaxSwipeOffset, (int)sfGrid.RowHeight);
rightSwipeView.AddView(deleteView, sfGrid.MaxSwipeOffset, (int)sfGrid.RowHeight);
sfGrid.LeftSwipeView = leftSwipeView;
sfGrid.RightSwipeView = rightSwipeView;
sfGrid.SwipeEnded += sfGrid_SwipeEnded;
sfGrid.SwipeStarted += sfGrid_SwipeStarted;
GridTextColumn CustomerID = new GridTextColumn();
CustomerID.MappingName = "CustomerID";
CustomerID.HeaderText = "Customer ID";
GridTextColumn OrderID = new GridTextColumn();
OrderID.MappingName = "OrderID";
OrderID.HeaderText = "Order ID";
OrderID.TextMargin = new Thickness(16, 0, 0, 0);
OrderID.HeaderTextMargin = new Thickness(16, 0, 0, 0);
GridTextColumn EmployeeID = new GridTextColumn();
EmployeeID.MappingName = "EmployeeID";
EmployeeID.HeaderText = "Employee ID";
GridTextColumn Name = new GridTextColumn();
Name.MappingName = "FirstName";
Name.HeaderText = "Name";
sfGrid.Columns.Add(OrderID);
sfGrid.Columns.Add(CustomerID);
sfGrid.Columns.Add(EmployeeID);
sfGrid.Columns.Add(Name);
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
parentLayout.AddView(sfGrid);
editor.SetBackgroundColor(Color.White);
editor.Orientation = Android.Widget.Orientation.Vertical;
optionHeading.Text = "EDIT DETAILS";
optionHeading.SetTypeface(null, TypefaceStyle.Bold);
optionHeading.Gravity = GravityFlags.Center;
bodyRow1.AddView(col1, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), (int)(50 * sfGrid.Resources.DisplayMetrics.Density));
bodyRow1.AddView(orderIDText, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), ViewGroup.LayoutParams.WrapContent);
bodyRow2.AddView(col2, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), (int)(50 * sfGrid.Resources.DisplayMetrics.Density));
bodyRow2.AddView(customerIDText, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), ViewGroup.LayoutParams.WrapContent);
bodyRow3.AddView(col3, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), (int)(50 * sfGrid.Resources.DisplayMetrics.Density));
bodyRow3.AddView(employeeIDText, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), ViewGroup.LayoutParams.WrapContent);
bodyRow4.AddView(col4, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), (int)(50 * sfGrid.Resources.DisplayMetrics.Density));
bodyRow4.AddView(nameText, (int)(100 * sfGrid.Resources.DisplayMetrics.Density), ViewGroup.LayoutParams.WrapContent);
body.Orientation = Android.Widget.Orientation.Vertical;
body.SetGravity(GravityFlags.CenterHorizontal);
body.AddView(bodyRow1);
body.AddView(bodyRow2);
body.AddView(bodyRow3);
body.AddView(bodyRow4);
save.Text = "Save";
cancel.Text = "Cancel";
bottom.Orientation = Android.Widget.Orientation.Horizontal;
bottom.AddView(save);
bottom.AddView(cancel);
bottom.SetGravity(GravityFlags.Center);
editor.AddView(optionHeading);
editor.AddView(body);
editor.AddView(bottom);
optionView.AddView(editor, ViewGroup.LayoutParams.MatchParent, ViewGroup.LayoutParams.MatchParent);
if (parentLayout.ChildCount == 1)
{
parentLayout.AddView(optionView, 1);
}
parentLayout.GetChildAt(0).Visibility = ViewStates.Visible;
parentLayout.GetChildAt(1).Visibility = ViewStates.Invisible;
return(parentLayout);
}
public CellSelectionController(SfDataGrid dataGrid)
: base(dataGrid)
{
}
/// <summary>
/// Sets the sample customization settings.
/// </summary>
private void SampleCustomization()
{
this.sfDataGrid1.AllowGrouping = true;
this.sfDataGrid1.ShowGroupDropArea = true;
this.sfDataGrid1.AutoGenerateColumns = false;
this.sfDataGrid1.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
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 GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
});
this.sfDataGrid1.Columns.Add(new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship Country"
});
this.sfDataGrid1.Columns.Add(new GridDateTimeColumn()
{
MappingName = "ShippingDate", HeaderText = "Shipping Date"
});
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(14, 14)
});
#region Relation Creation
GridViewDefinition viewDefinition = new GridViewDefinition();
viewDefinition.RelationalColumn = "OrderDetails";
SfDataGrid firstLevelSourceDataGrid = new SfDataGrid();
firstLevelSourceDataGrid.RowHeight = 21;
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi
});
firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn()
{
MappingName = "OrderDate", HeaderText = "Order Date"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
});
firstLevelSourceDataGrid.Columns.Add(new GridTextColumn()
{
MappingName = "CustomerCity", HeaderText = "Customer City"
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "ProductID", HeaderText = "Product ID", FormatMode = FormatMode.Numeric, NumberFormatInfo = nfi
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "UnitPrice", HeaderText = "Unit Price", FormatMode = FormatMode.Currency
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Quantity", HeaderText = "Quantity", FormatMode = FormatMode.Numeric
});
firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn()
{
MappingName = "Discount", HeaderText = "Discount", FormatMode = FormatMode.Percent
});
StackedHeaderRow stackedHeaderRow = new StackedHeaderRow();
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "OrderID,OrderDate", HeaderText = "Order Details"
});
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "CustomerID,CustomerCity", HeaderText = "Customer Details"
});
stackedHeaderRow.StackedColumns.Add(new StackedColumn()
{
ChildColumns = "ProductID,UnitPrice,Quantity,Discount", HeaderText = "Product Details"
});
firstLevelSourceDataGrid.StackedHeaderRows.Add(stackedHeaderRow);
firstLevelSourceDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
viewDefinition.DataGrid = firstLevelSourceDataGrid;
this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition);
#endregion
this.sfDataGrid1.HideEmptyGridViewDefinition = true;
}
internal override void CollapseAllInsideRecord(RecordEntry record, int actualRowIndex, SfDataGrid dataGrid)
{
foreach (var viewDefinition in dataGrid.DetailsViewDefinition)
{
if (!(viewDefinition is GridViewDefinition))
{
continue;
}
var gridViewDefinition = viewDefinition as GridViewDefinition;
if (record.ChildViews != null && record.ChildViews.ContainsKey(viewDefinition.RelationalColumn))
{
record.ChildViews[viewDefinition.RelationalColumn].IsNestedLevelExpanded = false;
record.ChildViews[viewDefinition.RelationalColumn].ExpandedLevel = -1;
}
actualRowIndex++;
int repeatValueCount;
var isHidden = dataGrid.VisualContainer.RowHeights.GetHidden(actualRowIndex, out repeatValueCount);
if (isHidden)
{
continue;
}
var dr = dataGrid.RowGenerator.Items.OfType <DetailsViewDataRow>().FirstOrDefault(row => row.RowIndex == actualRowIndex);
if (dr != null)
{
dataGrid.DetailsViewManager.CollapeseNestedLines(dr.DetailsViewDataGrid, gridViewDefinition);
}
dataGrid.VisualContainer.RowHeights.SetHidden(actualRowIndex, actualRowIndex, true);
dataGrid.VisualContainer.RowHeights.SetNestedLines(actualRowIndex, null);
}
}
private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
SfDataGrid.ClearFilters();
}
public UnboundColumn()
{
this.SfGrid = new SfDataGrid();
this.viewModel = new SalesInfoViewModel();
this.SfGrid.ColumnSizer = ColumnSizer.Star;
this.SfGrid.AutoGenerateColumns = false;
this.SfGrid.ItemsSource = viewModel.DailySalesDetails;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.SelectionMode = SelectionMode.Multiple;
this.SfGrid.SelectedIndex = 3;
this.SfGrid.AllowResizingColumn = true;
this.SfGrid.GridStyle = new UnboundRowStyle();
SfGrid.CellRenderers.Remove("Unbound");
SfGrid.CellRenderers.Add("Unbound", new UnboundColumnRenderer());
SfGrid.UnboundRows.Add(new GridUnboundRow()
{
Position = UnboundRowsPosition.FixedBottom
});
SfGrid.QueryUnboundRow += SfGrid_QueryUnboundRow;
SfGrid.SelectionChanged += SfGrid_SelectionChanged;
SfGrid.QueryRowHeight += SfGrid_QueryRowHeight;
GridTextColumn EmployeeName = new GridTextColumn();
EmployeeName.HeaderText = "Employee";
EmployeeName.TextAlignment = UITextAlignment.Left;
EmployeeName.HeaderTextAlignment = UITextAlignment.Center;
EmployeeName.HeaderCellTextSize = 12;
EmployeeName.MappingName = "Name";
SfGrid.Columns.Add(EmployeeName);
GridTextColumn QS1 = new GridTextColumn();
QS1.HeaderText = "2015";
QS1.Format = "C";
QS1.HeaderTextAlignment = UITextAlignment.Center;
QS1.HeaderCellTextSize = 12;
QS1.TextAlignment = UITextAlignment.Right;
QS1.MappingName = "QS1";
if (UIDevice.CurrentDevice.UserInterfaceIdiom == UIUserInterfaceIdiom.Pad)
{
this.SfGrid.UnboundRows.Insert(0, new GridUnboundRow()
{
Position = UnboundRowsPosition.FixedTop
});
this.SfGrid.UnboundRows.Insert(0, new GridUnboundRow()
{
Position = UnboundRowsPosition.Top
});
SfGrid.Columns.Add(QS1);
}
GridTextColumn QS2 = new GridTextColumn();
QS2.HeaderText = "2016";
QS2.Format = "C";
QS2.HeaderTextAlignment = UITextAlignment.Center;
QS2.HeaderCellTextSize = 12;
QS2.TextAlignment = UITextAlignment.Right;
QS2.MappingName = "QS2";
SfGrid.Columns.Add(QS2);
GridTextColumn QS3 = new GridTextColumn();
QS3.HeaderText = "2017";
QS3.Format = "C";
QS3.HeaderTextAlignment = UITextAlignment.Center;
QS3.HeaderCellTextSize = 12;
QS3.TextAlignment = UITextAlignment.Right;
QS3.MappingName = "QS3";
SfGrid.Columns.Add(QS3);
GridUnboundColumn Total = new GridUnboundColumn();
Total.TextAlignment = UITextAlignment.Center;
if (UserInterfaceIdiomIsPhone)
{
Total.Expression = "(QS2 + QS3)";
}
else
{
Total.Expression = "(QS1 + QS2 + QS3 )";
}
Total.Format = "C";
Total.HeaderText = "Total";
Total.HeaderTextAlignment = UITextAlignment.Center;
Total.HeaderCellTextSize = 12;
Total.TextAlignment = UITextAlignment.Center;
Total.MappingName = "Total";
SfGrid.Columns.Add(Total);
foreach (GridColumn column in SfGrid.Columns)
{
if (UserInterfaceIdiomIsPhone)
{
SfGrid.ColumnSizer = ColumnSizer.None;
}
else
{
SfGrid.ColumnSizer = ColumnSizer.Star;
}
}
this.AddSubview(SfGrid);
}
/// <summary>
/// Initializes a new instance of the <see cref="GridRatingCellRenderer"/> class.
/// </summary>
/// <param name="ratingControl">The rating control.</param>
/// <param name="dataGrid">The DataGrid.</param>
public GridRatingCellRenderer(GridRatingControl ratingControl, SfDataGrid dataGrid)
{
IsEditable = false;
RatingControl = ratingControl;
DataGrid = dataGrid;
}
public GoodsReceivedSummaryVM(SfDataGrid _Report)
{
this.Report = _Report;
FDate = TDate = DateTime.Today;
}
/// <summary>
/// Initializes a new instance of the <see cref="CustomSelectionController"/> class.
/// </summary>
/// <param name="dataGrid">The DataGrid.</param>
public CustomSelectionController(SfDataGrid dataGrid)
: base(dataGrid)
{
}
public override void Destroy ()
{
this.sfGrid.AutoGeneratingColumn -= GridAutoGeneratingColumns;
this.sfGrid.Dispose ();
this.sfGrid = null;
this.viewModel.Dispose();
this.viewModel = null;
}
public override void Destroy ()
{
this.sfGrid.AutoGeneratingColumn -= OnAutoGenerateColumn;
this.sfGrid.QueryRowHeight -= SfGrid_QueryRowHeight;
this.sfGrid.Dispose ();
this.sfGrid = null;
this.viewModel = null;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
sfGrid = new SfDataGrid (context);
sfGrid.QueryRowHeight += HandleQueryRowHeightEventHandler;
viewModel = new AutoRowHeightViewModel ();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = (viewModel.EmployeeInformation);
return sfGrid;
}
public override Android.Views.View GetSampleContent (Android.Content.Context context)
{
GridTextColumn customerImageColumn = new GridTextColumn ();
customerImageColumn.UserCellType = typeof(GridImageCell);
customerImageColumn.MappingName = "CustomerImage";
customerImageColumn.HeaderText = "Image";
GridTextColumn isOpenColumn = new GridTextColumn ();
isOpenColumn.UserCellType = typeof(BoolFormatCell);
isOpenColumn.MappingName = "IsOpen";
isOpenColumn.HeaderText = "Is Open";
GridTextColumn customerIdColumn = new GridTextColumn ();
customerIdColumn.MappingName = "CustomerID";
customerIdColumn.HeaderText = "Customer ID";
customerIdColumn.TextAlignment = GravityFlags.Center;
GridTextColumn branchNoColumn = new GridTextColumn ();
branchNoColumn.MappingName = "BranchNo";
branchNoColumn.HeaderText = "Branch No";
branchNoColumn.TextAlignment = GravityFlags.Center;
GridTextColumn currentColumn = new GridTextColumn ();
currentColumn.MappingName = "Current";
currentColumn.Format = "C";
currentColumn.CultureInfo = new CultureInfo ("en-US");
currentColumn.TextAlignment = GravityFlags.Center;
GridTextColumn customerNameColumn = new GridTextColumn ();
customerNameColumn.MappingName = "CustomerName";
customerNameColumn.HeaderText = "Customer Name";
customerNameColumn.TextAlignment = GravityFlags.CenterVertical;
GridTextColumn savingsColumn = new GridTextColumn ();
savingsColumn.MappingName = "Savings";
savingsColumn.Format = "C";
savingsColumn.CultureInfo = new CultureInfo ("en-US");
savingsColumn.TextAlignment = GravityFlags.Center;
sfGrid = new SfDataGrid (context);
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 80;
sfGrid.Columns.Add (customerImageColumn);
sfGrid.Columns.Add (customerIdColumn);
sfGrid.Columns.Add (branchNoColumn);
sfGrid.Columns.Add (currentColumn);
sfGrid.Columns.Add (customerNameColumn);
sfGrid.Columns.Add (savingsColumn);
sfGrid.Columns.Add (isOpenColumn);
viewmodel = new FormattingViewModel ();
sfGrid.ItemsSource = viewmodel.BankInfo;
sfGrid.AlternatingRowColor = Color.Rgb (206, 206, 206);
return sfGrid;
}
