private void OrderViewAndColumns(Dictionary <string, object> transformResult)
{
ArrayList tables = (ArrayList)transformResult["tables"];
Dictionary <string, object> tableColumns = (Dictionary <string, object>)transformResult["columns"];
ConfigAccess ca = new ConfigAccess();
Durados.View viewView = map.GetConfigDatabase().Views["View"];
Durados.View fieldView = map.GetConfigDatabase().Views["Field"];
for (int i = 0; i < tables.Count; i++)
{
string viewJsonName = tables[i].ToString();
Durados.View view = Map.Database.GetViewByJsonName(viewJsonName);
string viewName = view.Name;
string vpk = ca.GetViewPK(viewJsonName, Map.GetConfigDatabase().ConnectionString);
viewView.Edit(new Dictionary <string, object>()
{
{ "Order", 10000 + i * 10 }
}, vpk, view_BeforeEdit, view_BeforeEditInDatabase, view_AfterEditBeforeCommit, view_AfterEditAfterCommit);
ArrayList columns = (ArrayList)tableColumns[viewJsonName];
for (int j = 0; j < columns.Count; j++)
{
string columnName = columns[j].ToString();
Field field = view.GetFieldByColumnNames(columnName);
if (field != null)
{
string fieldName = field.Name;
string fpk = ca.GetFieldPK(viewName, fieldName, Map.GetConfigDatabase().ConnectionString);
fieldView.Edit(new Dictionary <string, object>()
{
{ "Order", 500 + j * 10 }
}, fpk, view_BeforeEdit, view_BeforeEditInDatabase, view_AfterEditBeforeCommit, view_AfterEditAfterCommit);
}
}
}
RefreshConfigCache();
}
protected override void HandleDataBeforeCache(string pk, System.Data.DataRow row)
{
IDictionary <string, object> values = Request.GetRouteData().Values;
string viewName = values["viewName"].ToString();
string fieldName = values["fieldName"].ToString();
Durados.DataAccess.ConfigAccess configAccess = new ConfigAccess();
Database configDatabase = map.GetConfigDatabase();
string fieldPk = configAccess.GetFieldPK(viewName, fieldName, configDatabase.ConnectionString);
View fieldView = (View)configDatabase.Views["Field"];
fieldView.Edit(new Dictionary <string, object>()
{
{ "FtpUpload_Parent", pk }
}, fieldPk, null, null, null, null);
}