/// <summary> /// Save to db /// </summary> /// <param name="model"></param> /// <returns></returns> public static CommandResult saveToDB(this GridColumnCollectionModel model, string name) { CommandResult result; CommandResult opResult; // Check for empty model model = model ?? new GridColumnCollectionModel(); #region Load data Common.BLL.Logic.GasStation.Base__GridHeader lGridHeader = new Common.BLL.Logic.GasStation.Base__GridHeader(Common.Enum.EDatabase.GasStation); Common.BLL.Entity.GasStation.Base__GridHeader gridHeader = new Common.BLL.Entity.GasStation.Base__GridHeader() { name = name }; opResult = lGridHeader.read(gridHeader, "name"); if (gridHeader.id > 0) { gridHeader.data = model.toJson(); result = lGridHeader.update(gridHeader); } else { gridHeader.name = name; gridHeader.data = model.toJson(); result = lGridHeader.create(gridHeader); } #endregion return(result); }
/// <summary> /// To Json /// </summary> /// <param name="grid"></param> /// <returns></returns> public static void loadHeader(this DataGridView grid, string name) { CommandResult opResult; if (null != grid) { #region Load data Common.BLL.Logic.GasStation.Base__GridHeader lGridHeader = new Common.BLL.Logic.GasStation.Base__GridHeader(Common.Enum.EDatabase.GasStation); Common.BLL.Entity.GasStation.Base__GridHeader gridHeader = new Common.BLL.Entity.GasStation.Base__GridHeader() { name = name }; opResult = lGridHeader.read(gridHeader, "name"); #endregion #region Apply changes on grid if (opResult.status == BaseDAL.Base.EnumCommandStatus.success) { GridColumnCollectionModel cols = gridHeader.data.toModel <GridColumnCollectionModel> (typeof(GridColumnCollectionModel)) as GridColumnCollectionModel; if (cols is GridColumnCollectionModel) { foreach (GridColumnModel col in cols.columns) { if (grid.Columns.Contains(col.field)) { DataGridViewColumn gridCol = grid.Columns[col.field]; gridCol.HeaderText = col.caption; gridCol.Visible = col.visible; gridCol.ReadOnly = col.readOnly; gridCol.DisplayIndex = col.position; gridCol.Width = col.width; } } } } #endregion } }