private void btnSave_Click(object sender, RoutedEventArgs e) { //fer validacions..... //@TODO if (EstatForm != Estat.NOU) { // estic modificant ActorDB aDB = (ActorDB)dtgActors.SelectedItem; if (aDB != null) { aDB.First_name = Actor.First_name; aDB.Last_name = Actor.Last_name; aDB.Last_update = Actor.Last_update.DateTime; aDB.Update(); } } else { // estic en el cas de Nou actor ActorDB aBD = new ActorDB(-1, Actor.First_name, Actor.Last_name, Actor.Last_update.DateTime, 0); aBD.Insert(); //this.llistaActors.Add(aBD); actualitzaPaginacioDesDelFormulari(); } EstatForm = Estat.SENSE_CANVIS; }
/// <summary> /// Connect to the interserver to access the remote database objects. /// </summary> public static bool StartDatabase() { switch (lcfg.ifSQL) { case 0: charDB = new db4oCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBUser, lcfg.DBPass); break; case 1: charDB = new MySQLCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBName, lcfg.DBUser, lcfg.DBPass); break; case 2: charDB = new DatCharacterDB(lcfg.WorldName, lcfg.DBHost); break; case 3: charDB = new MSSQLCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBName, lcfg.DBUser, lcfg.DBPass); break; } try { charDB.Connect(); } catch (Exception) { return(false); } return(true); }
public ActorViewModel(ActorDB actor) { this.Actor_id = actor.Actor_id; this.Last_name = actor.Last_name; this.First_name = actor.First_name; this.Last_update = actor.Last_update; }
/// <summary> /// Connect to the interserver to access the remote database objects. /// </summary> public static bool StartDatabase() { switch (lcfg.ifSQL) { case 0: charDB = new db4oCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBUser, lcfg.DBPass); break; case 1: charDB = new MySQLCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBName, lcfg.DBUser, lcfg.DBPass); break; case 2: charDB = new DatCharacterDB(lcfg.WorldName, lcfg.DBHost); break; case 3: charDB = new MSSQLCharacterDB(lcfg.DBHost, lcfg.DBPort, lcfg.DBName, lcfg.DBUser, lcfg.DBPass); break; } try { charDB.Connect(); } catch (Exception) { return false; } return true; }
public static bool StartWorldDatabase() { wcfg = new WorldConfig(); foreach (WorldConfig.World world in wcfg.Worlds.Values) { if (!LoginServer.charServerList.ContainsKey(world.ID)) { ActorDB newCharDB = null;; switch (world.ifSQL) { case 0: newCharDB = new db4oCharacterDB(world.DBHost, world.DBPort, world.DBUser, world.DBPass); break; case 1: newCharDB = new MySQLCharacterDB(world.DBHost, world.DBPort, world.DBName, world.DBUser, world.DBPass); break; case 2: newCharDB = new DatCharacterDB(world.Name, world.DBHost); break; case 3: newCharDB = new MSSQLCharacterDB(world.DBHost, world.DBPort, world.DBName, world.DBUser, world.DBPass); break; } try { newCharDB.Connect(); } catch (Exception ex) { switch (world.ifSQL) { case 0: Console.WriteLine("Error: No se puede conectar a la base de datos " + world.DBHost + ":" + world.DBPort + " con el username: "******" y pass: "******"Error: No se puede conectar a la base de datos " + world.DBHost + ":" + world.DBPort + " con el username: "******" y pass: "******"ERROR, no se puede anadir el mundo: " + world.Name + " con la ID: " + world.ID + " razon: ya hay una ID igual"); return(false); } } return(true); }
public static bool StartWorldDatabase() { wcfg = new WorldConfig(); foreach (WorldConfig.World world in wcfg.Worlds.Values) { if (!LoginServer.charServerList.ContainsKey(world.ID)) { ActorDB newCharDB = null;; switch (world.ifSQL) { case 0: newCharDB = new db4oCharacterDB(world.DBHost, world.DBPort, world.DBUser, world.DBPass); break; case 1: newCharDB = new MySQLCharacterDB(world.DBHost, world.DBPort, world.DBName, world.DBUser, world.DBPass); break; case 2: newCharDB = new DatCharacterDB(world.Name, world.DBHost); break; case 3: newCharDB = new MSSQLCharacterDB(world.DBHost, world.DBPort, world.DBName, world.DBUser, world.DBPass); break; } try { newCharDB.Connect(); } catch (Exception ex) { switch (world.ifSQL) { case 0: Console.WriteLine("Error: Cannot connect to world db server " + world.DBHost + ":" + world.DBPort + " with username: "******" and pass: "******"Error: Cannot connect to world db server " + world.DBHost + ":" + world.DBPort + " with username: "******" and pass: "******"ERROR, cannot add world: " + world.Name + " with ID: " + world.ID + " reason: worldID is already taken"); return(false); } } return(true); }
//int serverID; public CharServer(string worldName, byte mPing, byte mPlayerCount, byte worldID, ActorDB charDB) { this.worldname = worldName; this.ping = (Status)mPing; this.playerCount = mPlayerCount; this.worldID = worldID; this.charDB = charDB; this.mapServers = new List<MapServer>(); }
//int serverID; public CharServer(string worldName, byte mPing, byte mPlayerCount, byte worldID, ActorDB charDB) { this.worldname = worldName; this.ping = (Status)mPing; this.playerCount = mPlayerCount; this.worldID = worldID; this.charDB = charDB; this.mapServers = new List <MapServer>(); }
// Use this for initialization void Awake() { photonView = GetComponent <PhotonView>(); _actionDB = ActionDB.Instance; _actorDB = ActorDB.Instance; _trendingDB = TrendingDB.Instance; Instance = this; Debug.Log("DB ready"); }
public void Reveal(Hero hero) { bool found = hero.RevealedWorlds.Contains(this); if (!found) { //reveal world to player hero.InGameClient.SendMessage(new RevealWorldMessage() { Id = 0x0037, Field0 = WorldID, Field1 = WorldSNO, }); hero.RevealedWorlds.Add(this); } //player enters world hero.InGameClient.SendMessage(new EnterWorldMessage() { Id = 0x0033, Field0 = hero.Position, Field1 = WorldID, Field2 = WorldSNO, }); //just reveal the whole thing to the player for now foreach (var scene in Scenes) { scene.Reveal(hero); } if (!found) { //reveal actors foreach (var actor in Actors) { if (ActorDB.isBlackListed(actor.SnoId)) { continue; } if (ActorDB.isNPC(actor.SnoId)) { continue; } //actor.Reveal(hero); } //reveal portals Logger.Info("Revealing portals for world " + WorldID); foreach (Portal portal in Portals) { portal.Reveal(hero); } } }
private void dtgActors_SelectionChanged(object sender, SelectionChangedEventArgs e) { crearActorViewModel((ActorDB)dtgActors.SelectedItem); btnDelete.IsEnabled = dtgActors.SelectedItem != null; if (dtgActors.SelectedItem != null) { ActorDB a = (ActorDB)dtgActors.SelectedItem; ObservableCollection <FilmDB> films = FilmDB.getFilms(a.Actor_id); dtgFilms.ItemsSource = films; } }
private void actualitzaPaginacio(string v1, string v2, DateTime dateTime, int itemsPerPagina, int numPagina) { int numeroActors = ActorDB.getNumeroActors(v1, v2, dateTime); this.totalPagines = (int)(Math.Ceiling((double)numeroActors / itemsPerPagina)); llistaActors = ActorDB.getActors(v1, v2, dateTime, itemsPerPagina, numPagina); dtgActors.ItemsSource = llistaActors; }
private void crearActorViewModel(ActorDB lactor) { if (lactor != null) { Actor = new ActorViewModel(lactor); } else { Actor = new ActorViewModel(); } // Ens registrem a l'event property changed // Si l'objecte Actor és modificat (via binding de la interfície // gràfica ), ens avisarà. Actor.PropertyChanged += Actor_PropertyChanged; }
public static bool StartDatabase() { try { charDB = new MySQLActorDB(Configuration.Instance.DBHost, Configuration.Instance.DBPort, Configuration.Instance.DBName, Configuration.Instance.DBUser, Configuration.Instance.DBPass); accountDB = new MySQLAccountDB(Configuration.Instance.DBHost, Configuration.Instance.DBPort, Configuration.Instance.DBName, Configuration.Instance.DBUser, Configuration.Instance.DBPass); charDB.Connect(); accountDB.Connect(); return(true); } catch (Exception) { return(false); } }
private async void btnDelete_Click(object sender, RoutedEventArgs e) { if (dtgActors.SelectedItem != null) { ActorDB a = (ActorDB)dtgActors.SelectedItem; int numeroPelisActor = a.getNumeroDePelis(); Boolean esborra = false; if (numeroPelisActor > 0) { ContentDialog deleteActorDialog = new ContentDialog { Title = "Aquest actor té pel·lícules registrades al seu nom. ", Content = "Vol esborrar l'actor i totes les seves referències?", PrimaryButtonText = "Esborrar", CloseButtonText = "Cancel·lar" }; ContentDialogResult result = await deleteActorDialog.ShowAsync(); // Delete the file if the user clicked the primary button. /// Otherwise, do nothing. if (result == ContentDialogResult.Primary) { esborra = true; } } else { // 0 pelis esborra = true; } if (esborra) { if (a.deleteStoredProcedure())//delete()) { actualitzaPaginacioDesDelFormulari(); } } } }
public static bool StartDatabase() { try { charDB = new MySQLActorDB(Configuration.Instance.DBHost, Configuration.Instance.DBPort, Configuration.Instance.DBName, Configuration.Instance.DBUser, Configuration.Instance.DBPass); accountDB = new MySQLAccountDB(Configuration.Instance.DBHost, Configuration.Instance.DBPort, Configuration.Instance.DBName, Configuration.Instance.DBUser, Configuration.Instance.DBPass); charDB.Connect(); accountDB.Connect(); return true; } catch (Exception) { return false; } }