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