public static GridViewSettings GetExportSettings(string itemsNames)
{
GridViewSettings gridVieewSettings = GetExportSettings();
if (!string.IsNullOrEmpty(itemsNames))
{
string[] names = itemsNames.Split(';');
gridVieewSettings.SettingsExport.BeforeExport = (sender, e) => {
MVCxGridView gridView = sender as MVCxGridView;
if (sender == null)
{
return;
}
gridView.Columns.Clear();
foreach (var name in names)
{
if (string.IsNullOrEmpty(name))
{
continue;
}
gridView.Columns.Add(new MVCxGridViewColumn(name));
}
};
}
return(gridVieewSettings);
}
public GridViewSettings CreateAirGridViewSettings()
{
GridViewSettings settings = new GridViewSettings();
settings.Name = "All";
settings.Columns.Add("Master");
settings.Columns.Add("FileNo");
settings.Columns.Add("House");
settings.Columns.Add("Shipper");
settings.Columns.Add("Consignee");
settings.Columns.Add("Agent");
settings.Columns.Add("Carrier");
settings.Columns.Add("Origin");
settings.Columns.Add("Destination");
settings.Columns.Add("Quantity").PropertiesEdit.DisplayFormatString = "n";
settings.Columns.Add("Date").PropertiesEdit.DisplayFormatString = "d";
settings.Columns.Add(column =>
{
column.FieldName = "Gros_Wt";
column.SetHeaderCaptionTemplateContent("Gros WT.");
});
settings.Columns.Add("ChargeableWeight");
settings.Columns.Add(column =>
{
column.FieldName = "ChargeableWeight";
column.SetHeaderCaptionTemplateContent("Chargeable WT.");
});
settings.Columns.Add(column =>
{
column.FieldName = "Freight_Charge";
column.SetHeaderCaptionTemplateContent("Freight Charge");
column.PropertiesEdit.DisplayFormatString = "c";
});
settings.Columns.Add(column =>
{
column.FieldName = "Other_Charge";
column.SetHeaderCaptionTemplateContent("Other Charge");
column.PropertiesEdit.DisplayFormatString = "c";
});
settings.Settings.ShowFooter = true;
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Gros_Wt");
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "ChargeableWeight");
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Freight_Charge");
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Other_Charge");
settings.DataBound = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
string KeyFieldName = (string)Session["KeyFieldName"];
grid.GroupBy(grid.Columns[KeyFieldName]);
};
return(settings);
}
public static void SetHeaderColumnData(object sender, EventArgs e, string controller)
{
MVCxGridView gv = sender as MVCxGridView;
gv.Visible = (gv.VisibleRowCount > 0);
//CRM.Business.DAL.ListadoRepository listadoRepository = new CRM.Business.DAL.ListadoRepository();
//CRM.Business.DAL.PropiedadNavegacionListadoRepository propiedadNavegacionRepository = new CRM.Business.DAL.PropiedadNavegacionListadoRepository();
CRM.Business.Entities.Listado listado = AppSession.Listados.Where(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault();
//listadoRepository.GetFiltered(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault();
foreach (GridViewColumn column in gv.Columns)
{
var dataColumn = column as GridViewDataColumn;
if (dataColumn != null && listado != null)
{
dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
//if (propiedadNavegacionRepository.GetFiltered(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(dataColumn.FieldName.ToUpper())).Any())
if (AppSession.PropiedadesNavegacion.Where(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(dataColumn.FieldName.ToUpper())).Any())
{
if (dataColumn.FieldName.ToUpper() == "CODIGOCLIENTE")
{
column.Caption = "Cliente";
}
if (dataColumn.FieldName.ToUpper() == "PRO_COD")
{
column.Caption = "Producto";
}
}
}
}
}
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext)
{
InitializeGridData(html, viewContext, AuditGridData, "CreateAudit", "UpdateAudits", "DeleteAudits");
// Popup form customization
settings.SettingsPopup.EditForm.Modal = true;
settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center;
settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter;
settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True;
settings.SettingsText.PopupEditFormCaption = "Add " + AuditName;
//Master Grid Specific configurations
settings.KeyFieldName = AuditGridData.Key;
settings.Name = $"{AuditGridData.Name}";
settings.SettingsDetail.ShowDetailRow = false;
settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false;
settings.ClientSideEvents.BeginCallback = "function(s,e) {OnBeginCallback(s,e);}";
settings.ClientSideEvents.EndCallback = "function(s,e) {OnEndCallback(s,e);}";
//settings.ClientSideEvents.ToolbarItemClick = "function(s,e){e.processOnServer = false;}";
//Generic configurations
AuditGridData.Title = Translate(AuditGridData.Title);
settings.Styles.AlternatingRow.BackColor = System.Drawing.Color.Red;
settings.Configure(AuditGridData, html, viewContext);
var column = settings.Columns["Description"] as MVCxGridViewColumn;
if (column != null)
{
column.EditorProperties().Memo(m =>
{
m.Width = Unit.Percentage(100);
m.Rows = 5;
});
}
settings.SettingsExport.BeforeExport = (sender, e) => {
MVCxGridView gridView = sender as MVCxGridView;
if (sender == null)
{
return;
}
gridView.Columns["OwnerId"].Visible = false;
};
settings.CellEditorInitialize = (s, e) =>
{
e.Editor.ReadOnly = false;
};
settings.CommandColumn.Visible = false;
SelectRow((int)(ViewData[AuditId] ?? 0), (string)(ViewData[AuditName] ?? string.Empty), ref settings);
}
public static void SetCellData(object sender, ASPxGridViewTableDataCellEventArgs e, string controller)
{
MVCxGridView gv = sender as MVCxGridView;
gv.Visible = (gv.VisibleRowCount > 0);
//ListadoRepository listadoRepository = new ListadoRepository();
//PropiedadNavegacionListadoRepository propiedadNavegacionRepository = new PropiedadNavegacionListadoRepository();
Listado listado = AppSession.Listados.Where(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault();//listadoRepository.GetFiltered(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault();
vClientes vClientes = new Business.Views.vClientes();
foreach (GridViewColumn column in gv.Columns)
{
var dataColumn = column as GridViewDataColumn;
if (dataColumn != null && listado != null)
{
//if (propiedadNavegacionRepository.GetFiltered(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(e.DataColumn.FieldName.ToUpper())).Any())
if (AppSession.PropiedadesNavegacion.Where(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(e.DataColumn.FieldName.ToUpper())).Any())
{
if (e.DataColumn.FieldName.ToUpper() == "CODIGOCLIENTE")
{
int idCliente = Convert.ToInt32(e.CellValue);
DataTable data = vClientes.GetByID(idCliente);
if (data.Rows.Count > 0)
{
e.Cell.Text = "<a href='/Cliente/View/" + idCliente + "' title='Ver Cliente'>" + data.Rows[0]["Descripcion"].ToString() + "</a>";
}
else
{
e.Cell.Text = "Cliente Inexistente";
}
}
if (e.DataColumn.FieldName.ToUpper() == "PRO_COD")
{
vProductos vProductos = new Business.Views.vProductos();
vProductos.Datos = vProductos.GetEmpyViewModel();
string idProducto = e.CellValue.ToString();
DataTable data = vProductos.GetByID(idProducto);
if (data.Rows.Count > 0)
{
e.Cell.Text = "<a href='/Producto/View/" + idProducto + "' title='Ver Producto'>" + data.Rows[0]["Descripcion"].ToString() + "</a>";
}
else
{
e.Cell.Text = "Producto Inexistente";
}
}
}
}
}
}
public MVCxGridViewState(MVCxGridView gridView)
{
Columns = new GridViewDataColumnStateCollection(gridView.VisibleColumns);
GroupedColumns = new GridViewDataColumnStateCollection(gridView.GetGroupedColumns());
TotalSummary = new System.Collections.ObjectModel.Collection <MVCxSummaryItemState>();
foreach (ASPxSummaryItem item in gridView.TotalSummary)
{
TotalSummary.Add(new MVCxSummaryItemState(item));
}
FilterExpression = gridView.FilterExpression;
}
public static void Grid_ClientLayout(object s, ASPxClientLayoutArgs e)
{
MVCxGridView grid = (MVCxGridView)s;
var viewModel = GetModelFromSession(grid);
if (e.LayoutMode == ClientLayoutMode.Saving && viewModel != null)
{
bool bSortChanged = false;
foreach (GridViewColumn column in grid.AllColumns)
{
if (column is MVCxGridViewColumn)
{
MVCxGridViewColumn MVCcolumn = (MVCxGridViewColumn)column;
var col = viewModel.ViewHeader.GetColumnByOriginalName(MVCcolumn.FieldName);
if (col != null)
{
col.IsVisible = MVCcolumn.Visible;
if ((!col.SortOrder.HasValue && MVCcolumn.SortIndex != -1) ||
(col.SortOrder.HasValue && col.SortOrder.Value != MVCcolumn.SortIndex) ||
(col.SortOrder.HasValue && col.IsSortAscending == (MVCcolumn.SortOrder == ColumnSortOrder.Descending))
)
{
bSortChanged = true;
}
col.SortOrder = MVCcolumn.SortIndex;
col.IsSortAscending = !(MVCcolumn.SortOrder == ColumnSortOrder.Descending);
col.ColumnFilter = ((GridViewDataColumn)MVCcolumn).FilterExpression;
col.ColumnWidth = MVCcolumn.Width.IsEmpty ? AvrView.DefaultFieldWidth : (int)MVCcolumn.Width.Value;
}
}
else if (column is MVCxGridViewBandColumn)
{
MVCxGridViewBandColumn MVCband = (MVCxGridViewBandColumn)column;
var band = viewModel.ViewHeader.GetBandByOriginalName(MVCband.Name);
if (band != null)
{
band.IsVisible = MVCband.Visible;
}
}
}
if (bSortChanged)
{
viewModel.ViewHeader.GetAggregateColumnsList().ForEach(c => AggregateCasheWeb.FillAggregateColumn(viewModel.ViewData, c, viewModel.ViewHeader.GetSortExpression()));
}
}
else
{
}
}
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext)
{
InitializeRigChecklistGridData(html, viewContext, GridDataChecklist, "CreateRigChecklist", "UpdateRigChecklist", "DeleteRigChecklist");
// Popup form customization
settings.SettingsPopup.EditForm.Modal = true;
settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center;
settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter;
settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True;
settings.SettingsText.PopupEditFormCaption = "Add " + RigChecklistName;
//Master Grid Specific configurations
settings.KeyFieldName = GridDataChecklist.Key;
settings.Name = $"{GridDataChecklist.Name}";
settings.SettingsDetail.ShowDetailRow = false;
settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false;
//Generic configurations
GridDataChecklist.Title = Translate(GridDataChecklist.Title);
settings.Configure(GridDataChecklist, html, viewContext);
var column = settings.Columns["Description"] as MVCxGridViewColumn;
if (column != null)
{
column.EditorProperties().Memo(m =>
{
m.Width = Unit.Percentage(100);
m.Rows = 5;
});
}
settings.SettingsExport.BeforeExport = (sender, e) => {
MVCxGridView gridView = sender as MVCxGridView;
if (sender == null)
{
return;
}
gridView.Columns["OwnerId"].Visible = false;
};
settings.CellEditorInitialize = (s, e) =>
{
e.Editor.ReadOnly = false;
};
settings.CommandColumn.Visible = false;
SelectRow((int)(ViewData[RigChecklistId] ?? 0), (string)(ViewData[RigChecklistName] ?? string.Empty), ref settings);
}
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext)
{
InitializeRigChecklistGridData(html, viewContext, GridDataChecklist, "CreateProtocol", "UpdateProtocol", "DeleteProtocol");
//Master Grid Specific configurations
settings.KeyFieldName = GridDataChecklist.Key;
settings.Name = $"{GridDataChecklist.Name}";
settings.SettingsDetail.ShowDetailRow = false;
settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false;
if (!(bool)Session["isAuditIdClick"])
{
GridDataChecklist.CallBackRoute = new { Area = "cOap", Controller = "OapProtocolsToAudit", Action = "DisplayProtocols", aId = ViewData["SelectedAuditId"] }
}
;
if ((bool)Session["isAuditIdClick"])
{
settings.ClientSideEvents.EndCallback = "function (s,e){ refreshProtocolAssessorGrid(s,e);}";
}
//Generic configurations
GridDataChecklist.Title = Translate(GridDataChecklist.Title);
settings.Configure(GridDataChecklist, html, viewContext);
settings.CommandColumn.Visible = false;
// Popup form customization
settings.SettingsPopup.EditForm.Modal = true;
settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center;
settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter;
settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True;
settings.SettingsText.PopupEditFormCaption = "Add Protocols To Audit";
settings.CellEditorInitialize = (s, e) =>
{
e.Editor.ReadOnly = false;
};
settings.SettingsExport.BeforeExport = (sender, e) =>
{
MVCxGridView gridView = sender as MVCxGridView;
if (sender == null)
{
return;
}
gridView.Columns["OwnerId"].Visible = false;
};
}
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext)
{
base.Configure(settings, html, viewContext);
settings.CommandButtonInitialize = (sender, e) =>
{
MVCxGridView gridView = (MVCxGridView)sender;
bool.TryParse(gridView.GetRowValues(e.VisibleIndex, "IsAutoScheduled")?.ToString(), out bool isAutoScheduled);
if (e.ButtonType == ColumnCommandButtonType.Delete && isAutoScheduled)
{
e.Visible = false;
}
};
}
public static void MakeColumnReadOnlyWhileEditing(object sender, ASPxGridViewEditorEventArgs e, string fieldName)
{
MVCxGridView grid = sender as MVCxGridView;
if (grid.IsNewRowEditing)
{
return;
}
if (grid.IsEditing)
{
if (e.Column.FieldName.Equals(fieldName, StringComparison.OrdinalIgnoreCase) && (long)e.KeyValue > 0)
{
e.Editor.ClientEnabled = false;
}
}
}
public GridViewSettings CreatePNLGridViewSettings()
{
GridViewSettings settings = new GridViewSettings();
settings.Name = "grid";
settings.SettingsPager.PageSize = 30;
settings.Columns.Add("Customer_Name", "Customer").GroupIndex = GetGroupIndex("Customer_Name");
settings.Columns.Add("ImportExport", "Import/Export").GroupIndex = GetGroupIndex("ImportExport");
settings.Columns.Add("AirOcean", "Air/Ocean").GroupIndex = GetGroupIndex("AirOcean");
settings.Columns.Add("MBL_NUM", "MAWB/MBOL").GroupIndex = GetGroupIndex("MBL_NUM");
settings.Columns.Add("HBL_NUM", "HAWB/HBOL").GroupIndex = GetGroupIndex("HBL_NUM");
settings.Columns.Add("Date").GroupIndex = GetGroupIndex("Date");
settings.Columns.Add("Description", "Item").GroupIndex = GetGroupIndex("Description");
settings.Columns.Add("ORIGIN", "Origination").GroupIndex = GetGroupIndex("ORIGIN");
settings.Columns.Add("DEST", "Destination").GroupIndex = GetGroupIndex("DEST");
settings.Columns.Add("Revenue");
settings.Columns.Add("Expense");
settings.Columns.Add("Profit");
settings.Settings.ShowFooter = true;
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Revenue");
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Expense");
settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Profit");
settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Revenue");
settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Expense");
settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Profit");
settings.Settings.ShowGroupPanel = true;
settings.DataBound = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
ArrayList PNLGropuing = GetPNLGrouping();
for (int i = 0; i < PNLGropuing.Count; i++)
{
grid.GroupBy(grid.Columns[PNLGropuing[i].ToString()]);
}
grid.ExpandAll();
};
return(settings);
}
public ActionResult GVFilterItemsCustomPartial(string Action, string FieldID)
{
var settings = GetGVFilterItemsSettings();
CustomFilterItem[] model = null;
if (Action == "Close")
{
Session["GridDataSource"] = null;
}
else if (Action == "Show" && !string.IsNullOrEmpty(FieldID))
{
model = ((Dictionary <string, CustomFilterItem[]>)Session["pivotFilterValues"])[FieldID];
Session["GridDataSource"] = model;
settings.BeforeGetCallbackResult = (s, e) => {
MVCxGridView gv = (MVCxGridView)s;
gv.Selection.BeginSelection();
foreach (var item in model)
{
gv.Selection.SetSelectionByKey(item.Value, item.Selected);
}
gv.Selection.EndSelection();
gv.JSProperties["cpFieldID"] = FieldID;
};
}
else if (Action == "Invert")
{
model = (CustomFilterItem[])Session["GridDataSource"];
settings.BeforeGetCallbackResult = (s, e) => {
MVCxGridView gv = (MVCxGridView)s;
List <object> selectedValues = gv.GetSelectedFieldValues(new string[] { "Value" });
gv.Selection.SelectAll();
foreach (object val in selectedValues)
{
gv.Selection.UnselectRowByKey(val);
}
};
}
ViewBag.GVFilterItemsSettings = settings;
return(PartialView("_GridViewPartial", model));
}
public override void ConfigureExecution(GridViewSettings settings, HtmlHelper html, ViewContext viewContext)
{
base.ConfigureExecution(settings, html, viewContext);
settings.SettingsBehavior.AllowSelectSingleRowOnly = true;
settings.Settings.ShowGroupFooter = DevExpress.Web.GridViewGroupFooterMode.VisibleAlways;
settings.SetGroupFooterRowTemplateContent(c => {
var isPlanMonitoring = (bool)DataBinder.Eval(c.DataItem, "IsPlantMonitoring");
var subGroupText = (string)DataBinder.Eval(c.DataItem, "SubGroup");
var content = string.Empty;
if (isPlanMonitoring)
{
var groupId = (int)DataBinder.Eval(c.DataItem, "GroupId");
html.RenderPartial("BarrierAuthorityRenderAssetsPartial", RigChecklist.Assets.ToGroupAssetModels(groupId, GetClient <OapChecklistAssetDataManagementClient>()));
}
});
settings.HtmlRowCreated = (sender, e) =>
{
var isPlantMonitoringRow = (bool)(e.GetValue("IsPlantMonitoring") ?? false);
if (e.RowType == DevExpress.Web.GridViewRowType.GroupFooter)
{
e.Row.Visible = isPlantMonitoringRow;
}
};
settings.BeforeGetCallbackResult = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
grid.ClearSort();
var i = grid.GroupCount;
grid.GroupBy(grid.Columns["Group"]);
grid.GroupBy(grid.Columns["SubGroup"]);
};
}
public static GridViewSettings GetSettingExportWithoutId(IEnumerable <CRM.Business.Views.BaseViews.BaseViewString.DynObject> model, string controllerName)
{
GridViewSettings settings = new GridViewSettings();
settings.Name = "grid_" + controllerName;
settings.CallbackRouteValues = new { Controller = controllerName, Action = "GridViewAllPartial" };
settings.Width = System.Web.UI.WebControls.Unit.Percentage(100);
settings.SettingsSearchPanel.Visible = true;
settings.SettingsBehavior.AllowFixedGroups = true;
settings.SettingsBehavior.AllowDragDrop = true;
settings.SettingsBehavior.AllowSort = true;
settings.SettingsCookies.StoreFiltering = true;
settings.SettingsCookies.StoreGroupingAndSorting = true;
settings.SettingsCookies.StorePaging = true;
settings.SettingsCookies.Enabled = true;
settings.CustomJSProperties = (s, e) =>
{
MVCxGridView gridView = (MVCxGridView)s;
e.Properties["cpClientLayout"] = gridView.SaveClientLayout();
};
settings.CommandColumn.Visible = true;
settings.Settings.UseFixedTableLayout = true;
settings.CommandColumn.Width = 50;
settings.CommandColumn.ShowClearFilterButton = true;
//CheckBox en cada fila y checkbox general
settings.CommandColumn.ShowSelectCheckbox = true;
settings.CommandColumn.SelectAllCheckboxMode = GridViewSelectAllCheckBoxMode.Page;
settings.CommandColumn.HeaderStyle.BackColor = System.Drawing.Color.Orange;
settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
settings.Settings.ShowGroupPanel = true;
settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
settings.Settings.VerticalScrollableHeight = 300;
settings.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords;
settings.SettingsPager.FirstPageButton.Visible = true;
settings.SettingsPager.LastPageButton.Visible = true;
settings.SettingsPager.PageSizeItemSettings.Visible = true;
settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" };
AddColumnsSettingViewData(settings.Columns, model);
//AddColumnsSettingViewData(settings.Columns, model, null);
settings.Settings.ShowFilterRow = true;
settings.Settings.ShowFilterRowMenu = false;
settings.DataBound = (sender, e) =>
{
MVCxGridView gv = sender as MVCxGridView;
gv.Visible = (gv.VisibleRowCount > 0);
foreach (GridViewColumn column in gv.Columns)
{
var dataColumn = column as GridViewDataColumn;
if (dataColumn != null)
{
dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
}
}
};
settings.PreRender = (s, e) =>
{
MVCxGridView grid = s as MVCxGridView;
if (grid != null)
{
grid.ExpandAll();
}
};
settings.SettingsDetail.ExportMode = GridViewDetailExportMode.Expanded;
return(settings);
}
public static void SetFilterRowVisibility(MVCxGridView grid, bool visible)
{
grid.Settings.ShowFilterRow = visible;
}
public GridViewSettings CreateOceanGridViewSettings()
{
GridViewSettings settings = new GridViewSettings();
settings.Name = "All";
settings.Columns.Add("FileNo", "File#");
settings.Columns.Add("Master", "MBOL#");
settings.Columns.Add("House", "HBOL#");
settings.Columns.Add("Shipper");
settings.Columns.Add("Consignee");
settings.Columns.Add("Agent");
settings.Columns.Add("Carrier");
settings.Columns.Add("Origin");
settings.Columns.Add("Destination");
settings.Columns.Add("Date", "ETD");
settings.Columns.Add("Sale_Rep", "Sales Rep.");
settings.Columns.Add("Processed_By", "Processed By");
settings.Columns.Add("Processed_By", "Processed By");
settings.Columns.Add(c =>
{
c.FieldName = "Quantity";
c.Caption = "";
((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric";
});
settings.Columns.Add(c =>
{
c.FieldName = "Gros_Wt";
c.Caption = "Gros Wt.";
((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric";
});
settings.Columns.Add(c =>
{
c.FieldName = "Measurement";
c.Caption = "Measurement (CBM)";
((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric";
});
settings.Columns.Add(c =>
{
c.FieldName = "Freight_Charge";
c.Caption = "Freight Charge";
((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric";
});
settings.Columns.Add(c =>
{
c.FieldName = "Other_Charge";
c.Caption = "Other Charge";
((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric";
});
settings.DataBound = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
string KeyFieldName = (string)Session["KeyFieldName"];
grid.GroupBy(grid.Columns[KeyFieldName]);
};
return(settings);
}
private static GridViewSettings GetSettingExport()
{
GridViewSettings settings = new GridViewSettings();
settings.Name = "grid_acontecimientos";
settings.CallbackRouteValues = new { Controller = "Acontecimientos", Action = "GridViewAllPartial" };
settings.Width = System.Web.UI.WebControls.Unit.Percentage(100);
settings.SettingsSearchPanel.Visible = true;
settings.SettingsBehavior.AllowFixedGroups = true;
settings.SettingsBehavior.AllowDragDrop = true;
settings.SettingsBehavior.AllowSort = true;
settings.SettingsCookies.StoreFiltering = true;
settings.SettingsCookies.StoreGroupingAndSorting = true;
settings.SettingsCookies.StorePaging = true;
settings.SettingsCookies.Enabled = true;
settings.CustomJSProperties = (s, e) =>
{
MVCxGridView gridView = (MVCxGridView)s;
e.Properties["cpClientLayout"] = gridView.SaveClientLayout();
};
settings.CommandColumn.Visible = true;
settings.Settings.UseFixedTableLayout = true;
settings.CommandColumn.Width = 50;
settings.CommandColumn.ShowClearFilterButton = true;
//CheckBox en cada fila y checkbox general
settings.CommandColumn.ShowSelectCheckbox = true;
settings.CommandColumn.SelectAllCheckboxMode = GridViewSelectAllCheckBoxMode.Page;
settings.CommandColumn.HeaderStyle.BackColor = System.Drawing.Color.Orange;
//settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
settings.SettingsResizing.ColumnResizeMode = ColumnResizeMode.Control;
settings.Settings.ShowGroupPanel = true;
settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
settings.Settings.VerticalScrollableHeight = 300;
settings.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords;
settings.SettingsPager.FirstPageButton.Visible = true;
settings.SettingsPager.LastPageButton.Visible = true;
settings.SettingsPager.PageSizeItemSettings.Visible = true;
settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" };
settings.KeyFieldName = "Id";
settings.Columns.Add("Id");
settings.Columns.Add("Fecha Acont.");
settings.Columns.Add("Descripcion");
settings.Columns.Add("TipoAcontecimiento");
settings.Columns.Add("Fecha Apertura ");
settings.Columns.Add("Fecha Ocurrencia ");
settings.Columns.Add("Fecha Implementacion ");
settings.Columns.Add("Estado");;
//Fila de filtros
settings.Settings.ShowFilterRow = true;
//Icono del menu del filtrado
settings.Settings.ShowFilterRowMenu = false;
//Setear por defecto la condicion de filtrado
//de todas las columnas a Contains
settings.DataBound = (sender, e) =>
{
MVCxGridView gv = sender as MVCxGridView;
gv.Visible = (gv.VisibleRowCount > 0);
foreach (GridViewColumn column in gv.Columns)
{
var dataColumn = column as GridViewDataColumn;
if (dataColumn != null)
{
dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
}
}
};
settings.PreRender = (s, e) =>
{
MVCxGridView grid = s as MVCxGridView;
if (grid != null)
{
grid.ExpandAll();
}
};
settings.SettingsDetail.ExportMode = GridViewDetailExportMode.Expanded;
return(settings);
}
public static GridViewSettings <TModel> GetGridViewReportSetting <TModel>(ECOM.Models.GridViewConfig gridConfig, bool IsExportData = true)
{
var gridViewSettings = new GridViewSettings <TModel>();
gridViewSettings.Name = gridConfig.GridViewName;
gridViewSettings.KeyFieldName = gridConfig.KeyFieldName;
gridViewSettings.SettingsPager.PageSize = gridConfig.PageSize;
gridViewSettings.CallbackRouteValues = gridConfig.CallbackRouteValues;
gridViewSettings.CustomActionRouteValues = gridConfig.CustomActionRouteValues;
gridViewSettings.SettingsPager.Position = System.Web.UI.WebControls.PagerPosition.TopAndBottom;
gridViewSettings.SettingsPager.FirstPageButton.Visible = true;
gridViewSettings.SettingsPager.LastPageButton.Visible = true;
gridViewSettings.SettingsPager.PageSizeItemSettings.Visible = true;
gridViewSettings.Width = System.Web.UI.WebControls.Unit.Percentage(100);
gridViewSettings.Height = System.Web.UI.WebControls.Unit.Percentage(100);
gridViewSettings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
gridViewSettings.CommandColumn.ShowClearFilterButton = true;
gridViewSettings.Settings.ShowFilterRow = true;
gridViewSettings.Settings.ShowFilterRowMenu = true;
gridViewSettings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "25", "50", "100" };
gridViewSettings.SettingsBehavior.AllowFocusedRow = true; //Selected Row
gridViewSettings.Settings.HorizontalScrollBarMode = ScrollBarMode.Visible;
gridViewSettings.ControlStyle.CssClass = "grid-view-custom";
//Menu Context Setting
gridViewSettings.SettingsContextMenu.Enabled = true;
gridViewSettings.SettingsBehavior.EnableCustomizationWindow = true;
gridViewSettings.SettingsContextMenu.EnableRowMenu = DefaultBoolean.False;
gridViewSettings.SettingsContextMenu.EnableFooterMenu = DefaultBoolean.False;
gridViewSettings.SettingsContextMenu.EnableGroupPanelMenu = DefaultBoolean.False;
gridViewSettings.SettingsPopup.CustomizationWindow.HorizontalAlign = PopupHorizontalAlign.LeftSides;
gridViewSettings.SettingsPopup.CustomizationWindow.VerticalAlign = PopupVerticalAlign.Below;
gridViewSettings.ContextMenuItemVisibility = (sender, e) =>
{
// Custom menu context Item
if (e.MenuType == GridViewContextMenuType.Columns)
{
foreach (var item in e.Items)
{
GridViewContextMenuItem menuItemDelete = item as GridViewContextMenuItem;
if (menuItemDelete.Name == "GroupByColumn" ||
menuItemDelete.Name == "ShowGroupPanel" ||
menuItemDelete.Name == "ShowSearchPanel" ||
menuItemDelete.Name == "ShowFilterRow" ||
menuItemDelete.Name == "ShowFilterRowMenu" ||
menuItemDelete.Name == "ShowFooter"
)
{
e.SetVisible(menuItemDelete, false);
}
}
}
};
gridViewSettings.SettingsBehavior.EnableCustomizationWindow = true;
gridViewSettings.CustomJSProperties = (sender, e) =>
{
string separator = ",";
string fieldNames = string.Empty;
MVCxGridView grid = (MVCxGridView)sender;
foreach (DevExpress.Web.GridViewColumn column in grid.VisibleColumns)
{
if (column is GridViewDataColumn)
{
GridViewDataColumn dataColumn = (GridViewDataColumn)column;
if (!string.IsNullOrEmpty(dataColumn.FieldName) && dataColumn.Visible)
{
fieldNames += dataColumn.FieldName + ",";
}
}
}
fieldNames = fieldNames.TrimEnd(separator.ToCharArray());
e.Properties["cpFieldNames"] = fieldNames;
};
//End menu context setting
if (IsExportData == false)
{
gridViewSettings.Columns.Add(c =>
{
c.UnboundType = DevExpress.Data.UnboundColumnType.String;
c.Caption = ECOM.Resources.ECOMResource.Number;
c.Settings.AllowAutoFilter = DefaultBoolean.False;
c.Settings.AllowDragDrop = DefaultBoolean.False;
c.Settings.AllowSort = DefaultBoolean.False;
c.Width = 30;
});
gridViewSettings.CustomColumnDisplayText = (s, e) =>
{
if (e.Column.Caption == ECOM.Resources.ECOMResource.Number)
{
e.DisplayText = (e.VisibleRowIndex + 1).ToString();
}
};
}
foreach (var item in gridConfig.Columns.Where(x => x.Enable == true))
{
MVCxGridViewColumn column = gridViewSettings.Columns.Add();
column.FieldName = item.ColumnName;
column.Caption = item.DisplayText;
//column.Visible = item.Enable;
column.Visible = true;
if (item.ColumnType == "System.DateTime" || item.ColumnType == "System.Date" || item.ColumnType.Contains("System.DateTime"))
{
if (!string.IsNullOrEmpty(item.ColumnFormat))
{
column.PropertiesEdit.DisplayFormatString = item.ColumnFormat;
}
else
{
//Default is DateTime format
column.PropertiesEdit.DisplayFormatString = ECOM.Resources.ECOMResource.ResourceManager.GetString("DefaultDateFormat");
}
}
if (item.ColumnType == "System.Decimal")
{
column.PropertiesEdit.DisplayFormatString = "N2";
}
}
return(gridViewSettings);
}
static GridViewSettings CreateStationGridSettings()
{
EssoEntities DB2 = new EssoEntities();
GridViewSettings settings = new GridViewSettings();
settings.Name = "gvStation";
settings.KeyFieldName = "ID";
settings.CallbackRouteValues = new { Controller = "Station", Action = "GridStationPartial" };
settings.Width = Unit.Percentage(100);
settings.InitNewRow += grid_InitNewRow;
settings.SettingsEditing.Mode = GridViewEditingMode.EditForm;
settings.SettingsEditing.AddNewRowRouteValues = new { Controller = "Station", Action = "SaveStation" };
settings.SettingsEditing.UpdateRowRouteValues = new { Controller = "Station", Action = "UpdateStation" };
settings.SettingsEditing.DeleteRowRouteValues = new { Controller = "Station", Action = "DeleteStation" };
settings.SettingsBehavior.ConfirmDelete = true;
settings.SettingsBehavior.AllowGroup = true;
settings.SettingsBehavior.AllowSort = true;
settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
settings.Settings.VerticalScrollableHeight = 500;
settings.SettingsPager.PageSize = 20;
settings.SettingsPager.Position = PagerPosition.Bottom;
//settings.SettingsPager.FirstPageButton.Visible = true;
//settings.SettingsPager.LastPageButton.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" };
settings.Settings.ShowFilterRow = true;
settings.Settings.ShowFilterRowMenu = true;
settings.ClientSideEvents.BeginCallback = "OnStationBeginCallback";
//settings.Columns.Add(c =>
//{
// c.FieldName = "PHOTO";
// c.EditorProperties().BinaryImage(p =>
// {
// p.ImageHeight = 170;
// p.ImageWidth = 160;
// p.EnableServerResize = true;
// p.ImageSizeMode = ImageSizeMode.FitProportional;
// p.CallbackRouteValues = new { Action = "BinaryImageColumnPhotoUpdate", Controller = "Station" };
// p.EditingSettings.Enabled = true;
// p.EditingSettings.UploadSettings.UploadValidationSettings.MaxFileSize = 4194304;
// });
//});
settings.Columns.Add(c =>
{
c.FieldName = "NAME";
c.Caption = "Plant Name";
});
settings.Columns.Add(c =>
{ c.FieldName = "SIZE";
c.Caption = "Size"; c.Width = Unit.Pixel(150); });
//settings.Columns.Add(c =>
//{
// c.FieldName = "NAME";
// c.Caption = "Group Name";
// c.Visible = false;
// c.GroupIndex = 0;
// c.EditFormSettings.Visible = DefaultBoolean.False;
// c.EditorProperties().ComboBox(p =>
// {
// p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// });
//});
settings.Columns.Add(column => {
column.FieldName = "GROUP_ID";
column.Caption = "Grup";
column.EditorProperties().ComboBox(p =>
{
p.TextField = "NAME";
p.ValueField = "ID";
p.ValueType = typeof(int);
p.DataSource = DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => new { x.NAME, x.ID }).ToList();
});
});
//settings.Columns.Add(column =>
//{
// column.FieldName = "GROUP_ID";
// column.Caption = "Group";
// //column.GroupIndex = 0;
// //column.EditFormSettings.Visible = DefaultBoolean.False;
// //column.EditorProperties().ComboBox(p =>
// //{
// // p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// //});
//});
settings.Columns.Add(column =>
{
column.FieldName = "USERS";
column.Caption = "Users";
column.EditFormSettings.Visible = DefaultBoolean.False;
});
settings.Columns.Add(column =>
{
column.FieldName = "IP_ADDRESS";
column.Caption = "Ip Address";
});
settings.Columns.Add(column =>
{
column.FieldName = "PORT";
column.Caption = "PORT";
});
settings.Columns.Add(column =>
{
column.FieldName = "ALARM_TEMP_ID";
column.Caption = "Alarm Tipi";
column.Visible = false;
column.EditFormSettings.Visible = DefaultBoolean.True;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_ACTIVE";
column.Caption = "Active";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_LOCKED";
column.Caption = "Locked";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(c => { c.FieldName = "INSTALL_DATE"; c.Caption = "Installation Date"; c.Width = Unit.Pixel(200); });
settings.Columns.Add(c => { c.FieldName = "CREATED_DATE"; c.Caption = "Inserted Date"; c.Width = Unit.Pixel(200); }); //"CREATED_DATE").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
settings.Columns.Add(column =>
{
column.FieldName = "ADDRESS";
column.Caption = "Address";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "DESCRIPTION";
column.Caption = "Desription";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "PLC_INTERFACE";
column.Caption = "PLC INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "EKK_INTERFACE";
column.Caption = "EKK INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "IRRADIATION_SCALE";
column.Caption = "Irradiation Scale(%)";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.BeforeGetCallbackResult = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
grid.GroupBy(grid.Columns["GROUP_ID"]);
};
settings.PreRender = (sender, e) =>
{
ASPxGridView grid = (ASPxGridView)sender;
grid.ExpandRow(0);
};
return(settings);
}
