public static int CreateGameWithGameConfigurationEntry(string connectionString) { var idSelect = new SqlSelectStatement(connectionString); idSelect.Top(1) .Select("G.Id") .From("dbo.BZ_Game", "G") .Join("dbo.BZ_Game_Configuration", "GC", "GC.GameId = G.Id"); var id = idSelect.ExecuteScalar<int?>(); if (!id.HasValue) { var name = Utilities.GetRandomString(16); var gameInsert = new SqlInsertStatement(connectionString); gameInsert.InsertInto("dbo.BZ_Game") .Column("CreatedBy", 1) .Column("CreatedDate", DateTime.Now) .Column("Name") .Column("IndustryId", 1) .Values() .Value("Name", name); gameInsert.Execute(); idSelect = new SqlSelectStatement(connectionString); idSelect.Top(1) .Select("Id") .From("dbo.BZ_Game") .WhereEquals("Name", name); id = idSelect.ExecuteScalar<int?>(); var entryInsert = new SqlInsertStatement(connectionString); entryInsert.InsertInto("dbo.BZ_Game_Configuration") .Column("GameId", id.Value) .Column("ConfigurationKeyId", 1) .Column("Value") .Values() .Value("Value", "Test Value"); entryInsert.Execute(); } return id.Value; }
public static IEnumerable<Company> GenerateCompanies(string connectionString, int gameId, int numCompanies = -1) { var insert = new SqlInsertStatement(connectionString); insert.InsertInto("dbo.BZ_Company") .Column("GameId", gameId) .Column("Name") .Column("Money") .Column("InitialAccuracy"); if(numCompanies < 0) { numCompanies = Utilities.GetRandomInt(1, 5); } for (var index = 0; index < numCompanies; index++) { insert.Values() .Value("Name", Utilities.GetRandomString(16).Replace("'", "''")) .Value("Money", Utilities.GetRandomDecimal()) .Value("InitialAccuracy", Utilities.GetRandomDecimal()); } insert.Execute(); var sql = new SqlSelectStatement(connectionString); sql.Select("Id") .Select("Name") .Select("Money") .Select("InitialAccuracy") .Select("UserId") .From("dbo.BZ_Company") .WhereEquals("GameId", gameId); return sql.ExecuteComplex<Company>(); }
public SqlValues(SqlInsertStatement parent, IDictionary<string, object> values) { _parent = parent; _values = values; }
public static int GetGameId(string connectionString, string name) { var sql = new SqlInsertStatement(connectionString); sql.InsertInto("dbo.BZ_Game") .Column("CreatedBy", 1) .Column("CreatedDate", DateTime.Now) .Column("Name") .Column("IndustryId", 1) .Values() .Value("Name", name); sql.Execute(); var select = new SqlSelectStatement(connectionString); select.Top(1) .From("dbo.BZ_Game") .Select("Id") .WhereEquals("Name", name); return select.ExecuteScalar<int>(); }
public static IEnumerable<Project> GenerateProjects(string connectionString, int gameId, int count = 1) { var definitions = GetDBProjectDefinitions(connectionString); var insert = new SqlInsertStatement(connectionString); insert.InsertInto("dbo.BZ_Project") .Column("GameId", gameId) .Column("ProjectDefinitionId") .Column("Value") .Column("Deadline") .Column("ReputationRequired"); while (count-- > 0) { var deadline = Utilities.GetRandomDate(DateTime.Today, DateTime.Today.AddYears(1)); var requiredReputation = (int)Utilities.GetValues<StarCategory>().Random(); var value = Utilities.GetRandomDecimal(10, 1000); insert.Values() .Value("ProjectDefinitionId", definitions.Random().Id) .Value("Value", value) .Value("Deadline", deadline) .Value("ReputationRequired", requiredReputation); } insert.Execute(); var projectSelect = new SqlSelectStatement(connectionString); projectSelect.Select("Id") .Select("GameId") .Select("ProjectDefinitionId") .Select("Value") .Select("Deadline") .Select("ReputationRequired") .From("dbo.BZ_Project") .WhereEquals("GameId", gameId); var pData = projectSelect.ExecuteData(); var skillIds = new SqlSelectStatement(connectionString) .Select("Id") .From("dbo.BZ_Skill_Definition") .Execute<int>(); var requirementInsert = new SqlInsertStatement(connectionString); requirementInsert.InsertInto("dbo.BZ_Project_Requirement") .Column("ProjectId") .Column("SkillDefinitionId") .Column("TargetValue") .Column("CurrentValue", 0.0m); var output = new List<Project>(); var anyHasRequirements = false; foreach (var item in pData) { var id = (int)item["Id"]; var definitionId = (short)item["ProjectDefinitionId"]; var definition = definitions.FirstOrDefault(d => d.Id == definitionId); var requirements = new List<ProjectRequirement>(); foreach (var skill in definition.Skills) { anyHasRequirements = true; var targetValue = Utilities.GetRanged(skill.Value, 2); requirements.Add(new ProjectRequirement { SkillDefinition = skill.SkillDefinition, CurrentValue = 0, TargetValue = targetValue }); requirementInsert.Values() .Value("ProjectId", id) .Value("SkillDefinitionId", skill.SkillDefinition.Id) .Value("TargetValue", targetValue); } output.Add(new Project(requirements) { Id = id, Value = (decimal)item["Value"], Deadline = (DateTime)item["Deadline"], ReputationRequired = (StarCategory)(int)item["ReputationRequired"], Definition = definition }); } if (anyHasRequirements) { requirementInsert.Execute(); } return output; }
public static IEnumerable<Person> GeneratePeople(string connectionString, int gameId, int count = 1) { var personInsert = new SqlInsertStatement(connectionString) .InsertInto("dbo.BZ_Person") .Column("GameId", gameId) .Column("GenderId") .Column("FirstName") .Column("LastName") .Column("Birthday") .Column("RetirementDate") .Column("PersonalityId", 1); for (var index = 0; index < count; index++) { var gender = (int)Utilities.GetRandomValue(Gender.None); var first = Utilities.GetRandomString(16).Replace("'", "''"); var last = Utilities.GetRandomString(16).Replace("'", "''"); var birthday = Utilities.GetRandomDate(); var retirement = birthday.AddYears(Utilities.GetRandomInt(65, 85)); var intensity = Utilities.GetRandomDecimal(0, 1); personInsert.Values() .Value("GenderId", gender) .Value("FirstName", first) .Value("LastName", last) .Value("Birthday", birthday) .Value("RetirementDate", retirement); } personInsert.Execute(); var select = new SqlSelectStatement(connectionString); select.Select("Id") .Select("GenderId") .Select("FirstName") .Select("LastName") .Select("Birthday") .From("BZ_Person") .WhereEquals("GameId", gameId); var output = select.ExecuteComplex<Person>(); var skillIds = new SqlSelectStatement(connectionString) .Select("Id") .From("dbo.BZ_Skill_Definition") .Execute<int>(); var skillInsert = new SqlInsertStatement(connectionString) .InsertInto("dbo.BZ_Person_Skill") .Column("PersonId") .Column("SkillDefinitionId") .Column("Value") .Column("LearnRate") .Column("ForgetRate"); var skillsProperty = typeof(Person).GetProperty("Skills"); foreach (var person in output) { var remainingSkillIds = new List<int>(skillIds); var skills = new List<Skill>(); var skillCount = Utilities.GetRandomInt(1, remainingSkillIds.Count); while (skillCount-- > 0) { var skill = new Skill { ForgetRate = Utilities.GetRandomDecimal(0, 10), LearnRate = Utilities.GetRandomDecimal(0, 10), Value = Utilities.GetRandomDecimal(0, 255), SkillDefinition = new SkillDefinition { Id = (byte)remainingSkillIds.Random() } }; remainingSkillIds.Remove(skill.SkillDefinition.Id); skillInsert.Values() .Value("PersonId", person.Id) .Value("SkillDefinitionId", skill.SkillDefinition.Id) .Value("Value", skill.Value) .Value("LearnRate", skill.LearnRate) .Value("ForgetRate", skill.ForgetRate); skills.Add(skill); } skillsProperty.SetValue(person, skills); } skillInsert.Execute(); return output; }