public static string DisplayValue(SiteSettings ss, DataRow dataRow)
{
switch (ss.ReferenceType)
{
case "Issues": return(IssueUtilities.TitleDisplayValue(ss, dataRow));
case "Results": return(ResultUtilities.TitleDisplayValue(ss, dataRow));
case "Wikis": return(WikiUtilities.TitleDisplayValue(ss, dataRow));
default: return(string.Empty);
}
}
public static void Initialize()
{
if (ItemsIsEmpty())
{
new SiteCollection().ForEach(siteModel =>
{
if (siteModel.SiteSettings != null)
{
Rds.ExecuteNonQuery(
connectionString: Parameters.Rds.OwnerConnectionString,
statements: new SqlStatement[]
{
Rds.IdentityInsertItems(on: true),
Rds.InsertItems(
param: Rds.ItemsParam()
.ReferenceId(siteModel.SiteId)
.ReferenceType("Sites")
.SiteId(siteModel.SiteId)
.Title(siteModel.Title.Value)),
Rds.IdentityInsertItems(on: false)
});
}
});
new SiteCollection(tableType: Sqls.TableTypes.Deleted).ForEach(siteModel =>
{
if (siteModel.SiteSettings != null)
{
Rds.ExecuteNonQuery(
statements: new SqlStatement[]
{
Rds.InsertItems(
tableType: Sqls.TableTypes.Deleted,
param: Rds.ItemsParam()
.ReferenceId(siteModel.SiteId)
.Ver(siteModel.Ver)
.ReferenceType("Sites")
.SiteId(siteModel.SiteId)
.Title(siteModel.Title.Value))
});
}
});
new SiteCollection(tableType: Sqls.TableTypes.History).ForEach(siteModel =>
{
if (siteModel.SiteSettings != null)
{
Rds.ExecuteNonQuery(
statements: new SqlStatement[]
{
Rds.InsertItems(
tableType: Sqls.TableTypes.History,
param: Rds.ItemsParam()
.ReferenceId(siteModel.SiteId)
.Ver(siteModel.Ver)
.ReferenceType("Sites")
.SiteId(siteModel.SiteId)
.Title(siteModel.Title.Value))
});
}
});
Rds.ExecuteTable(statements: Rds.SelectIssues(
tableType: Sqls.TableTypes.Normal,
column: Rds.IssuesColumn()
.SiteId()
.IssueId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.IssuesSiteSettings(dataRow["IssueId"].ToLong());
var issueModel = new IssueModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Normal,
where : Rds.IssuesWhere()
.SiteId(dataRow["SiteId"].ToLong())
.IssueId(dataRow["IssueId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
issueModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
connectionString: Parameters.Rds.OwnerConnectionString,
statements: new SqlStatement[]
{
Rds.IdentityInsertItems(on: true),
Rds.InsertItems(
param: Rds.ItemsParam()
.ReferenceId(issueModel.IssueId)
.ReferenceType("Issues")
.SiteId(issueModel.SiteId)
.Title(IssueUtilities.TitleDisplayValue(
ss, issueModel))),
Rds.IdentityInsertItems(on: false)
});
}
});
Rds.ExecuteTable(statements: Rds.SelectIssues(
tableType: Sqls.TableTypes.Deleted,
column: Rds.IssuesColumn()
.SiteId()
.IssueId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.IssuesSiteSettings(dataRow["IssueId"].ToLong());
var issueModel = new IssueModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Deleted,
where : Rds.IssuesWhere()
.SiteId(dataRow["SiteId"].ToLong())
.IssueId(dataRow["IssueId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
issueModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
statements: new SqlStatement[]
{
Rds.InsertItems(
tableType: Sqls.TableTypes.Deleted,
param: Rds.ItemsParam()
.ReferenceId(issueModel.IssueId)
.Ver(issueModel.Ver)
.ReferenceType("Issues")
.SiteId(issueModel.SiteId)
.Title(IssueUtilities.TitleDisplayValue(
ss, issueModel)))
});
}
});
Rds.ExecuteTable(statements: Rds.SelectResults(
tableType: Sqls.TableTypes.Normal,
column: Rds.ResultsColumn()
.SiteId()
.ResultId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.ResultsSiteSettings(dataRow["ResultId"].ToLong());
var resultModel = new ResultModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Normal,
where : Rds.ResultsWhere()
.SiteId(dataRow["SiteId"].ToLong())
.ResultId(dataRow["ResultId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
resultModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
connectionString: Parameters.Rds.OwnerConnectionString,
statements: new SqlStatement[]
{
Rds.IdentityInsertItems(on: true),
Rds.InsertItems(
param: Rds.ItemsParam()
.ReferenceId(resultModel.ResultId)
.ReferenceType("Results")
.SiteId(resultModel.SiteId)
.Title(ResultUtilities.TitleDisplayValue(
ss, resultModel))),
Rds.IdentityInsertItems(on: false)
});
}
});
Rds.ExecuteTable(statements: Rds.SelectResults(
tableType: Sqls.TableTypes.Deleted,
column: Rds.ResultsColumn()
.SiteId()
.ResultId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.ResultsSiteSettings(dataRow["ResultId"].ToLong());
var resultModel = new ResultModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Deleted,
where : Rds.ResultsWhere()
.SiteId(dataRow["SiteId"].ToLong())
.ResultId(dataRow["ResultId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
resultModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
statements: new SqlStatement[]
{
Rds.InsertItems(
tableType: Sqls.TableTypes.Deleted,
param: Rds.ItemsParam()
.ReferenceId(resultModel.ResultId)
.Ver(resultModel.Ver)
.ReferenceType("Results")
.SiteId(resultModel.SiteId)
.Title(ResultUtilities.TitleDisplayValue(
ss, resultModel)))
});
}
});
Rds.ExecuteTable(statements: Rds.SelectWikis(
tableType: Sqls.TableTypes.Normal,
column: Rds.WikisColumn()
.SiteId()
.WikiId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.WikisSiteSettings(dataRow["WikiId"].ToLong());
var wikiModel = new WikiModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Normal,
where : Rds.WikisWhere()
.SiteId(dataRow["SiteId"].ToLong())
.WikiId(dataRow["WikiId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
wikiModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
connectionString: Parameters.Rds.OwnerConnectionString,
statements: new SqlStatement[]
{
Rds.IdentityInsertItems(on: true),
Rds.InsertItems(
param: Rds.ItemsParam()
.ReferenceId(wikiModel.WikiId)
.ReferenceType("Wikis")
.SiteId(wikiModel.SiteId)
.Title(WikiUtilities.TitleDisplayValue(
ss, wikiModel))),
Rds.IdentityInsertItems(on: false)
});
}
});
Rds.ExecuteTable(statements: Rds.SelectWikis(
tableType: Sqls.TableTypes.Deleted,
column: Rds.WikisColumn()
.SiteId()
.WikiId()
.Ver())).AsEnumerable().ForEach(dataRow =>
{
var siteId = dataRow["SiteId"].ToLong();
var ss = new SiteModel().Get(where :
Rds.SitesWhere().SiteId(siteId))?
.WikisSiteSettings(dataRow["WikiId"].ToLong());
var wikiModel = new WikiModel(ss).Get(
ss: ss,
tableType: Sqls.TableTypes.Deleted,
where : Rds.WikisWhere()
.SiteId(dataRow["SiteId"].ToLong())
.WikiId(dataRow["WikiId"].ToLong())
.Ver(dataRow["Ver"].ToInt()));
if (ss != null &&
wikiModel.AccessStatus == Databases.AccessStatuses.Selected)
{
Rds.ExecuteNonQuery(
statements: new SqlStatement[]
{
Rds.InsertItems(
tableType: Sqls.TableTypes.Deleted,
param: Rds.ItemsParam()
.ReferenceId(wikiModel.WikiId)
.Ver(wikiModel.Ver)
.ReferenceType("Wikis")
.SiteId(wikiModel.SiteId)
.Title(WikiUtilities.TitleDisplayValue(
ss, wikiModel)))
});
}
});
}
}
