public static uint Import(string file, AccessDatabase database) { using var stream = File.OpenRead(file); var specifications = new XmlSerializer(typeof(SkillXml)); var details = (SkillXml)specifications.Deserialize(stream); var skillTable = database["SkillBehavior"]; var entry = skillTable.Create(); var skill = new SkillBehaviorTable(entry); skill.imaginationcost = (int)details.Cost; skill.cooldown = details.Cooldown; skill.cooldowngroup = (int)details.CooldownGroup; skill.skillIcon = (int)details.Icon; skill.behaviorID = (int)ImportBehavior(details.Root, database); return((uint)entry.Key); }
private static async Task Main() { Sql = new List <string>(); await OpenConfig(); /* * await TerrainManager.AnalyseAsync(Configuration.Output); * * return; */ Database = await AccessDatabase.OpenAsync(Configuration.CdClient); Database.OnSql += Sql.Add; BuildSkill(); await FinalizeAsync(); await BuildZones(); await UpdateZones(); await InsertZones(); await BuildNpcs(); await BuildMissions(); await FinalizeAsync(); }
// Custom constructor to pass expense report data public ExpenseReportPage(object data) : this() { AccessDatabase adb = new AccessDatabase(); DataGrid.DataContext = adb.GetExpenses(ConnectionString.Text); this.DataContext = data; }
public static async Task ExportSqlAsync(this AccessDatabase @this, string connectionString) { await using var connection = new SqliteConnection(connectionString); await connection.OpenAsync(); foreach (var table in @this) { Console.WriteLine($"Writing: {table.Name} x {table.Count}"); await using (var query = new SqliteCommand(table.TableSegment(), connection)) { await query.ExecuteNonQueryAsync(); } var rows = new StringBuilder(); foreach (var row in table) { rows.AppendLine(row.SqlInsert()); } await using (var query = new SqliteCommand(rows.ToString(), connection)) { await query.ExecuteNonQueryAsync(); } Console.WriteLine($"Wrote: {table.Name}"); } await connection.CloseAsync(); }
private static uint ImportBehavior(BehaviorXml details, AccessDatabase database) { var behaviorTable = database["BehaviorTemplate"]; var entry = behaviorTable.Create(); var behavior = new BehaviorTemplateTable(entry); behavior.effectID = (int)details.Effect; behavior.templateID = (int)details.Type; foreach (var detailsParameter in details.Parameters) { var parameterTable = database["BehaviorParameter"]; var parameterEntry = parameterTable.Create(behavior.behaviorID); var parameter = new BehaviorParameterTable(parameterEntry); parameter.parameterID = detailsParameter.Name; if (detailsParameter.Behavior) { parameter.value = detailsParameter.Next == null ? 0 : ImportBehavior(detailsParameter.Next, database); } else { parameter.value = detailsParameter.Value; } } return((uint)behavior.behaviorID); }
public void FixHTTPMovieURL() { LOGGER.GenerateSilent("Fixing movies with http url."); DataTable dtMovies = AccessDatabase.Select(Queries.GetHTTPMovies); Movie[] movies = Movie.FetchAllMovie(dtMovies); foreach (Movie item in movies) { item.IMDBLink = item.IMDBLink.Replace("http:", "https:"); int r = AccessDatabase.Update(Queries.UpdateMovieIMDbLink, "@MovieID", item.MovieID, "@IMDbLink", item.IMDBLink); if (r == 0) { LOGGER.GenerateSilent("Could not find movie." + Environment.NewLine + item.FullTitle); } else if (r > 1) { LOGGER.GenerateSilent("There is more than one movie with the same IMDb " + "link. all of them have been updated." + Environment.NewLine + item.IMDBLink + Environment.NewLine + item.FullTitle); } } LOGGER.GenerateSilent("Finished fixing movies with http url."); }
/// <summary> /// Class thông số về đối tượng trên medisoft. /// </summary> /// <param name="cfg">Class cấu hình connect database.</param> public DoiTuong(Config cfg) { _ccf = cfg; _cacc = new AccessDatabase(_ccf); // // TODO: Add constructor logic here // }
public ExpenseItHome() { InitializeComponent(); AccessDatabase adb = new AccessDatabase(); People = adb.GetPersons(ConnectionString.Text); peopleListBox.ItemsSource = People; }
private void UpdateScreen() { AccessDatabase db = new AccessDatabase(); listPlayers.ItemsSource = db.SelectAllPlayers(); list = db.SelectAllPlayers(); lblCountPlayers.Text = list.Count.ToString(); }
protected override void ApplyChanges(AccessDatabase database) { SetParameter(database, "x_velocity", Velocity.X); SetParameter(database, "y_velocity", Velocity.Y); SetParameter(database, "z_velocity", Velocity.Z); }
protected override void ApplyChanges(AccessDatabase database) { for (var index = 0; index < Branches.Count; index++) { var branch = Branches[index]; SetParameter(database, $"behavior {index + 1}", branch.Id); } }
protected override void Load(AccessDatabase database) { Velocity = new Vector3 { X = GetParameter <float>(database, "x_velocity"), Y = GetParameter <float>(database, "y_velocity"), Z = GetParameter <float>(database, "z_velocity"), }; }
protected override void Load(AccessDatabase database) { foreach (var key in GetParameterKeys(database)) { if (key.StartsWith("behavior")) { Branch(database, key); } } }
public override void Context() { Database database = new SqlServerDatabase(); tsql_separator_regex_string = database.sql_statement_separator_regex_pattern; database = new AccessDatabase(); access_sql_separator_regex_string = database.sql_statement_separator_regex_pattern; database = new OracleDatabase(); plsql_separator_regex_string = database.sql_statement_separator_regex_pattern; }
public SelectPlayerPage() { InitializeComponent(); NavigationPage.SetHasNavigationBar(this, false); // Hide title bar AccessDatabase db = new AccessDatabase(); listPlayers.ItemsSource = db.SelectAllPlayers(); list = db.SelectAllPlayers(); lblCountPlayers.Text = list.Count.ToString(); }
public static Skill Create(AccessDatabase database) { var table = database["SkillBehavior"]; var skill = table.Create(); return(new Skill { Id = (uint)skill.Key }); }
/// <summary> /// Queries the database for all hub data /// </summary> /// <returns></returns> private DataTable GetHubData() { var db = new AccessDatabase(this.querySetup.DatabasePath); var factory = new LocalityHubsQuerySQLFactory(this.querySetup); var builder = new StandardQueryBuilder(factory); var data = db.ExecuteQuery(builder.BuildSQL()); return(data); }
public static TypedTable <T> Typed <T>(this AccessDatabase @this) where T : class { var type = typeof(T); var attribute = type.GetCustomAttribute <TableAttribute>(); var id = attribute?.Name ?? type.Name; var table = @this[id]; return(new TypedTable <T>(table.Info, table.Data, @this)); }
private DataTable GetData(string locality) { var db = new AccessDatabase(querySetup.DatabasePath); var factory = new VisitsByLocalityQuerySQLFactory(querySetup, locality); var builder = new StandardQueryBuilder(factory); Console.WriteLine("Retrieving data for {0}", locality); var data = db.ExecuteQuery(builder.BuildSQL()); return(data); }
public static LwoObject NewObject(this AccessDatabase @this, int id = -1) { var table = @this["Objects"]; if (id == -1) { id = table.ClaimKey(1); } var row = table.Create(id); return(LoadObject(@this, row.Key)); }
public void FixHTTPPersons() { LOGGER.GenerateSilent("Fixing persons with http url."); Person[] httpPersons = this.GetHTTPPersons(); foreach (Person item in httpPersons) { bool isActor = false; bool isDirector = false; Person_SP.GetTypeByID(item.PersonID, out isActor, out isDirector); string validIMDbLink = item.IMDBLink.Replace("http:", "https:"); Person[] validPersons = this.GetPersonByIMDbLink(validIMDbLink); int length = validPersons.Length; if (length == 0) { this.UpdatePersonIMDbLink(item.PersonID, validIMDbLink); } else if (length == 1) { Person validPerson = validPersons[0]; bool validIsActor = false; bool validIsDirector = false; Person_SP.GetTypeByID(validPerson.PersonID, out validIsActor, out validIsDirector); if (isActor && !validIsActor) { AccessDatabase.Insert(QueryRepository.Actor_Insert, "@PersonID", validPerson.PersonID); } if (isDirector && !validIsDirector) { AccessDatabase.Insert(QueryRepository.Director_Insert, "@PersonID", validPerson.PersonID); } this.UpdateMovieActors(item.PersonID, validPerson.PersonID); this.UpdateMovieDirectors(item.PersonID, validPerson.PersonID); this.DeletePerson(item.PersonID); } else { LOGGER.GenerateSilent("There is more than one match for person." + Environment.NewLine + item.FullName + Environment.NewLine + item.PersonID + Environment.NewLine + item.IMDBLink); } } LOGGER.GenerateSilent("Finished fixing persons with http url."); }
protected override void ApplyChanges(AccessDatabase database) { SetParameter(database, "lookat_x", LookAt.X); SetParameter(database, "lookat_y", LookAt.Y); SetParameter(database, "lookat_z", LookAt.Z); SetParameter(database, "pos_x", Position.X); SetParameter(database, "pos_y", Position.Y); SetParameter(database, "pos_z", Position.Z); }
public static DataTable GetAllTableData(string tableName) { var database = new AccessDatabase(ConfigurationManager.AppSettings["PROVIDER"], ConfigurationManager.AppSettings["DSN"]); if (!database.LoadAllTableData(tableName)) { return(database.DbDataSet.Tables[tableName]); } return(new DataTable { TableName = tableName }); }
public T GetParameter <T>(AccessDatabase database, string name) where T : struct { var table = database["BehaviorParameter"]; foreach (var column in table.SeekMultiple((int)Id)) { var entry = new BehaviorParameterTable(column); if (entry.parameterID == name) { return((T)Convert.ChangeType(entry.value, typeof(T))); } } return(default);
protected override void Load(AccessDatabase database) { LookAt = new Vector3 { X = GetParameter <float>(database, "lookat_x"), Y = GetParameter <float>(database, "lookat_y"), Z = GetParameter <float>(database, "lookat_z"), }; Position = new Vector3 { X = GetParameter <float>(database, "pos_x"), Y = GetParameter <float>(database, "pos_y"), Z = GetParameter <float>(database, "pos_z"), }; }
public static LwoObject CopyObject(this AccessDatabase @this, int lot, int id = -1) { var source = @this.LoadObject(lot); var destination = @this.NewObject(id); foreach (var column in source.Row) { if (column.Name == "id") { continue; } destination.Row[column.Name].Value = column.Value; destination.Row[column.Name].Type = column.Type; } foreach (var component in source) { var destinationComponent = new LwoComponent(component.Id); destination.Add(destinationComponent); var sourceRow = component.Row; if (sourceRow == default) { continue; } var destinationRow = destinationComponent.Row; foreach (var column in sourceRow) { if (column.Name == "id") { continue; } destinationRow[column.Name].Value = column.Value; destinationRow[column.Name].Type = column.Type; } } return(destination); }
public Object authenticate(String username, String password, Object context) { String ticket = null; db = (AccessDatabase)context; try { ticket = db.getTicket(username, password); } catch (AccessDatabaseError e) { throw new AuthenticateExceptionInvalidCredentials(); } catch (Exception e2) { // A temporary exception, retry later throw new AuthenticateException(e2.ToString()); } return(ticket); }
public static async Task LoadSqlAsync(this AccessDatabase @this, string connectionString) { await using var connection = new SqliteConnection(connectionString); await connection.OpenAsync(); foreach (var table in @this) { table.Clear(); await using (var query = new SqliteCommand("SELECT * FROM ?", connection)) { query.Parameters.Add(table.Name); await using var reader = await query.ExecuteReaderAsync(); while (await reader.ReadAsync()) { var entry = table.Create(); foreach (var field in entry) { entry[field.Name].Value = field.Type switch { DataType.Nothing => (object)reader.GetInt32(field.Index), DataType.Integer => reader.GetInt32(field.Index), DataType.Unknown1 => reader.GetInt32(field.Index), DataType.Unknown2 => reader.GetInt32(field.Index), DataType.Float => reader.GetFloat(field.Index), DataType.Text => reader.GetString(field.Index), DataType.Varchar => reader.GetString(field.Index), DataType.Boolean => reader.GetBoolean(field.Index), DataType.Bigint => reader.GetInt64(field.Index), _ => throw new ArgumentOutOfRangeException() }; } } } table.Recalculate(); } await connection.CloseAsync(); }
public async void DeletePlayer(object sender, EventArgs args) { var awnser = await DisplayAlert("Delete player", "Are you sure you do want delete this player?", "Yes", "No"); if (awnser == false) { await DisplayAlert("Delete action", "Delete canceled", "Ok"); } else { Label lblDelete = (Label)sender; TapGestureRecognizer tapGest = (TapGestureRecognizer)lblDelete.GestureRecognizers[0]; var player = tapGest.CommandParameter as Player; AccessDatabase db = new AccessDatabase(); db.DeletePlayer(player); UpdateScreen(); btnHome.IsVisible = true; } }
public void UpdatePlayer(object sender, EventArgs args) { player.Name = playerName.Text; player.PreviousTeam = lastTeam.Text; player.Age = short.Parse(age.Text); player.College = cityBirth.Text; player.Salary = double.Parse(salary.Text); player.Description = description.Text; player.ThreePointShooter = shootThrees.IsToggled; player.PhoneNumber = phone.Text; player.Email = email.Text; //TODO - Update in the database AccessDatabase db = new AccessDatabase(); db.UpdateList(player); //TODO - Go back to Previous Page App.Current.MainPage = new NavigationPage(new PlayersPage()); }