protected override void OnLoad(EventArgs e)
{
EnsureChildControls();
if (!Page.IsPostBack)
{
DataTable dt = SqlHelper.ExecuteProcedure("sp_tables",
new SqlParameter("@table_type", "\"'TABLE'\""));
TreeNode node = new TreeNode("جداول", "Entity");
uxAccesses.ActionsTree.Nodes.Add(node);
foreach (DataRow row in dt.Rows)
{
string tn = row["TABLE_NAME"].ToString();
if (Array.IndexOf(aspnetTables, tn) >= 0)
{
continue;
}
TreeNode n = new TreeNode(SchemaUtility.GetSqlTableDescription(tn, row["TABLE_OWNER"].ToString()), tn);
n.ChildNodes.Add(new TreeNode("نمايش", "View"));
n.ChildNodes.Add(new TreeNode("ويرايش", "Edit"));
n.ChildNodes.Add(new TreeNode("حذف", "Delete"));
node.ChildNodes.Add(n);
}
}
base.OnLoad(e);
}
protected override void OnEdit(object sender, EventArgs args)
{
EditModelFrm frm = new EditModelFrm();
ColumnSetNode columnSetNode = (ColumnSetNode)this.Reslove(typeof(ColumnSetNode), this.ColumnSetName);
frm.UpdateModel(this, columnSetNode);
if (frm.ShowDialog() == DialogResult.OK)
{
this.Children.Clear();
//更新模型
IList <EditModelFrm.FieldItem> items = frm.FieldItems;
foreach (EditModelFrm.FieldItem item in items)
{
FieldNode node = NodeFactory.CreateNode <FieldNode>();// new FieldNode();
node.Name = item.Name;
node.ColumnName = item.ColumnName;
node.Description = item.Description;
node.NullAble = item.NullAble;
node.SystemType = SchemaUtility.GetSystemType(DBGlobalService.DbType, item.SystemType);
node.Parent = this;
}
}
base.OnEdit(sender, args);
}
private string GetViewSelectCommand()
{
List <string> columns = new List <string>();
//System.Data.Common.DbConnection con = ConnectionManager.Connection;
foreach (ColumnInfo ci in TableInfo.Columns)
{
if (ci.IsPrimaryKey)
{
uxGrid.MasterTableView.DataKeyNames = new string[] { ci.Title != "" ? ci.Title : ci.ColumnName };
}
ForeignKeyRelation fk = ci.ForeignKeyRelation;
if (fk != null)
{
TableInfo ti = SchemaUtility.GetTable(fk.PKTable);
string nameColumn = ti.GetNameColumn().ColumnName;
columns.Add("( Select [" + nameColumn + "] From " + fk.PKTable + " Where " + fk.PKTable + ".[" + fk.PKField + "] = " + TableName + ".[" + fk.FKField + "] ) ");
break;
}
else
{
columns.Add(ci.ColumnName + " as [" + ci.Title + "]");//+ " as [" + ci.Title + "]");
}
}
return("select " + string.Join(",", columns.ToArray()) + " from " + TableName);
}
public static XmlQualifiedName GetSchema(XmlSchemaSet schemaSet)
{
if (schemaSet == null)
{
throw FxTrace.Exception.ArgumentNull("schemaSet");
}
return(SchemaUtility.EnsureResolveSchema(DiscoveryVersion.WSDiscoveryCD1, schemaSet));
}
public void SchemaIsValid(string jsonPath, string schemaPath)
{
var schema = JSchema.Parse(File.ReadAllText(schemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(schemaPath))
});
var jContainer = JsonConvert.DeserializeObject <JContainer>(File.ReadAllText(jsonPath));
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public void ModelMatchesSchema(string jsonPath, string schemaPath, Type type)
{
var schema = JSchema.Parse(File.ReadAllText(schemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(schemaPath))
});
var requisitionPack = JsonConvert.DeserializeObject(File.ReadAllText(jsonPath), type);
var json = JsonConvert.SerializeObject(requisitionPack);
var jContainer = JsonConvert.DeserializeObject <JContainer>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public void TestGetCompletionItemsFromSchema()
{
var schema = JObject.Parse(@"
{
""$schema"": ""http://json-schema.org/draft-04/schema#"",
""title"": ""Build Schema"",
""definitions"": {
""build"": {
""type"": ""object"",
""properties"": {
""NoLogo"": {
""type"": ""boolean"",
""description"": ""Disables displaying the NUKE logo""
},
""Configuration"": {
""type"": ""string"",
""description"": ""Configuration to build - Default is 'Debug' (local) or 'Release' (server)"",
""enum"": [
""Debug"",
""Release""
]
},
""Target"": {
""type"": ""array"",
""description"": ""List of targets to be invoked. Default is '{default_target}'"",
""items"": {
""type"": ""string"",
""enum"": [
""Restore"",
""Compile""
]
}
}
}
}
}
}
");
var profileNames = new[] { "dev" };
var items = SchemaUtility.GetCompletionItems(schema, profileNames);
items.Should().BeEquivalentTo(
new Dictionary <string, string[]>
{
["NoLogo"] = null,
["Configuration"] = new[] { "Debug", "Release" },
["Target"] = new[] { "Restore", "Compile" },
[Constants.LoadedLocalProfilesParameterName] = profileNames
});
}
public async Task GetCampaignMatchDetails_SchemaIsValid(string guid)
{
var weaponsSchema = JSchema.Parse(File.ReadAllText(Halo5Config.CampaignMatchJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.CampaignMatchJsonSchemaPath))
});
var query = new GetCampaignMatchDetails(new Guid(guid))
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(weaponsSchema, jArray);
}
public async Task GetPlayerAppearance_SchemaIsValid(string gamertag)
{
var playerAppearanceSchema = JSchema.Parse(File.ReadAllText(Halo5Config.PlayerAppearancePath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.PlayerAppearanceSchemaPath))
});
var query = new GetPlayerAppearance(gamertag)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(playerAppearanceSchema, jArray);
}
public async Task GetCompetitiveSkillRankDesignations_SchemaIsValid()
{
var competitiveSkillRankDesignationsSchema = JSchema.Parse(File.ReadAllText(Halo5Config.CompetitiveSkillRankDesignationsJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.CompetitiveSkillRankDesignationsJsonSchemaPath))
});
var query = new GetCompetitiveSkillRankDesignations()
.SkipCache();
var jArray = await Global.Session.Get <JArray>(query.Uri);
SchemaUtility.AssertSchemaIsValid(competitiveSkillRankDesignationsSchema, jArray);
}
public async Task GetPlaylists_SchemaIsValid()
{
var playlistsSchema = JSchema.Parse(File.ReadAllText(Halo5Config.PlaylistJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.PlaylistJsonSchemaPath))
});
var query = new GetPlaylists()
.SkipCache();
var jArray = await Global.Session.Get <JArray>(query.Uri);
SchemaUtility.AssertSchemaIsValid(playlistsSchema, jArray);
}
public async Task GetMatchHistory_SchemaIsValid(string player)
{
var jSchema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var query = new GetMatchHistory(player)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(jSchema, jArray);
}
public async Task GetGameObjectCategories_SchemaIsValid()
{
var jSchema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var query = new HaloSharp.Query.HaloWars2.Metadata.GetGameObjectCategories()
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(jSchema, jArray);
}
public async Task GetSeasons_SchemaIsValid()
{
var seasonsSchema = JSchema.Parse(File.ReadAllText(Config.SeasonsJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.SeasonsJsonSchemaPath))
});
var query = new GetSeasons()
.SkipCache();
var jArray = await Global.Session.Get <JArray>(query.GetConstructedUri());
SchemaUtility.AssertSchemaIsValid(seasonsSchema, jArray);
}
[TestCase("5f96269a-58f8-473e-9897-42a4deb1bf09")] //Bronze
public async Task GetRequisitionPack_SchemaIsValid(string guid)
{
var schema = JSchema.Parse(File.ReadAllText(Halo5Config.RequisitionPackJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.RequisitionPackJsonSchemaPath))
});
var query = new GetRequisitionPack(new Guid(guid))
.SkipCache();
var jContainer = await Global.Session.Get <JContainer>(query.Uri);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task GetCampaignProgress_SchemaIsValid(string gamertag)
{
var jSchema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var query = new GetCampaignSummary(gamertag)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(jSchema, jArray);
}
public async Task GetArenaMatchDetails_SchemaIsValid(string guid)
{
var weaponsSchema = JSchema.Parse(File.ReadAllText(Config.ArenaMatchJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.ArenaMatchJsonSchemaPath))
});
var query = new GetArenaMatchDetails()
.ForMatchId(new Guid(guid));
var jArray = await Global.Session.Get <JObject>(query.GetConstructedUri());
SchemaUtility.AssertSchemaIsValid(weaponsSchema, jArray);
}
public async Task ListMapVariants_SchemaIsValid(string gamertag)
{
var weaponsSchema = JSchema.Parse(File.ReadAllText(Halo5Config.UserGeneratedContentMapVariantsJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.UserGeneratedContentMapVariantsJsonSchemaPath))
});
var query = new ListMapVariants(gamertag)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(weaponsSchema, jArray);
}
public async Task GetLeaderboard_SchemaIsValid(string seasonId, string playlistId)
{
var schema = JSchema.Parse(File.ReadAllText(Halo5Config.LeaderboardJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.LeaderboardJsonSchemaPath))
});
var query = new GetLeaderboard(new Guid(seasonId), new Guid(playlistId))
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(schema, jArray);
}
public async Task GetCustomServiceRecord_SchemaIsValid(string gamertag)
{
var weaponsSchema = JSchema.Parse(File.ReadAllText(Config.CustomServiceRecordJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.CustomServiceRecordJsonSchemaPath))
});
var query = new GetCustomServiceRecord()
.ForPlayer(gamertag);
var jArray = await Global.Session.Get <JObject>(query.GetConstructedUri());
SchemaUtility.AssertSchemaIsValid(weaponsSchema, jArray);
}
public async Task GetWarzoneServiceRecord_SchemaIsValid(string gamertag)
{
var weaponsSchema = JSchema.Parse(File.ReadAllText(Halo5Config.WarzoneServiceRecordJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.WarzoneServiceRecordJsonSchemaPath))
});
var query = new GetWarzoneServiceRecord(gamertag)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(weaponsSchema, jArray);
}
public async Task GetMapVariant_SchemaIsValid(string guid)
{
var mapVariantSchema = JSchema.Parse(File.ReadAllText(Config.MapVariantJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.MapVariantJsonSchemaPath))
});
var query = new GetMapVariant()
.ForMapVariantId(new Guid(guid))
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.GetConstructedUri());
SchemaUtility.AssertSchemaIsValid(mapVariantSchema, jArray);
}
public async Task GetSpartanCompany_SchemaIsValid(string companyID)
{
Guid companyId = new Guid(companyID);
var spartanCompanySchema = JSchema.Parse(File.ReadAllText(Halo5Config.SpartanCompanyPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.SpartanCompanySchemaPath))
});
var query = new GetSpartanCompany(companyId)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(spartanCompanySchema, jArray);
}
public async Task GetPlaylistRatings_SchemaIsValid(string guid, string gamertag)
{
var jSchema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var playlistId = new Guid(guid);
var query = new GetPlaylistRatings(gamertag, playlistId)
.SkipCache();
var jArray = await Global.Session.Get <JObject>(query.Uri);
SchemaUtility.AssertSchemaIsValid(jSchema, jArray);
}
public async Task GetWarzoneServiceRecord_ModelMatchesSchema(string gamertag)
{
var schema = JSchema.Parse(File.ReadAllText(Halo5Config.WarzoneServiceRecordJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Halo5Config.WarzoneServiceRecordJsonSchemaPath))
});
var query = new GetWarzoneServiceRecord(gamertag)
.SkipCache();
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JObject>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task GetSeasons_ModelMatchesSchema()
{
var schema = JSchema.Parse(File.ReadAllText(Config.SeasonsJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.SeasonsJsonSchemaPath))
});
var query = new GetSeasons()
.SkipCache();
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JContainer>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task GetGameObjectCategories_ModelMatchesSchema()
{
var schema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var query = new HaloSharp.Query.HaloWars2.Metadata.GetGameObjectCategories()
.SkipCache();
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JObject>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task GetWarzoneMatchDetails_ModelMatchesSchema(string guid)
{
var schema = JSchema.Parse(File.ReadAllText(Config.WarzoneMatchJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.WarzoneMatchJsonSchemaPath))
});
var query = new GetWarzoneMatchDetails()
.ForMatchId(new Guid(guid));
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JContainer>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task GetCampaignProgress_ModelMatchesSchema(string gamertag)
{
var schema = JSchema.Parse(File.ReadAllText(Schema), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Schema))
});
var query = new GetCampaignSummary(gamertag)
.SkipCache();
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JObject>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
public async Task ListGameVariants_ModelMatchesSchema(string gamertag)
{
var schema = JSchema.Parse(File.ReadAllText(Config.UserGeneratedContentGameVariantsJsonSchemaPath), new JSchemaReaderSettings
{
Resolver = new JSchemaUrlResolver(),
BaseUri = new Uri(Path.GetFullPath(Config.UserGeneratedContentGameVariantsJsonSchemaPath))
});
var query = new ListGameVariants()
.ForPlayer(gamertag)
.SkipCache();
var result = await Global.Session.Query(query);
var json = JsonConvert.SerializeObject(result);
var jContainer = JsonConvert.DeserializeObject <JObject>(json);
SchemaUtility.AssertSchemaIsValid(schema, jContainer);
}
