/* ******************************************************************************************************************************************************************************************************************** */ /// <summary> /// Gets StoredProcedure /// </summary> /// <returns></returns> /// Se cargan y obtienen los StoredProcedure que se encuentran en la Clase "StoredProcedure" #region De la Clase "StoredProcedure" se cargan en el dblClient los StoredProcedure almacenados en ella. internal void LoadDatabaseCommands(DbClient dbClient) { //Leerlas desde la Clase StoredProcedure FieldInfo[] SPFieldsInfo = typeof(StoredProcedures).GetFields(); foreach (var SPField in SPFieldsInfo) { dbClient.AddCommand((string)SPField.GetValue(null)); } }
/// <summary> /// /// </summary> public void LoadCharacter() { var args = new DictionaryAtom(); args.Set("CharacterID", ID); DbClient.BeginTransaction(); DbClient.AddCommand("live", "game_GetCharacterAbilities", args, OnCharacterAbilitiesLoaded); DbClient.AddCommand("live", "game_GetCharacterChannels", args, OnCharacterChannelsLoaded); DbClient.AddCommand("live", "game_GetCharacterFactions", args, OnCharacterFactionsLoaded); DbClient.AddCommand("live", "game_GetCharacterItems", args, OnCharacterItemsLoaded); DbClient.AddCommand("live", "game_GetCharacterProperties", args, OnCharacterPropertiesLoaded); DbClient.AddCommand("live", "game_GetCharacterStatistics", args, OnCharacterStatisticsLoaded); DbClient.AddCommand("live", "game_GetCharacterMail", args, OnCharacterMailLoaded); DbClient.PerformTransaction(null, null); }
/// <summary> /// /// </summary> /// <param name="loadGuildbank"></param> public void LoadBank(bool loadGuildbank = false) { var args = new DictionaryAtom(); if (loadGuildbank) { args.Set("GuildID", 0); // TODO: Insert GuildID here } else { args.Set("UserID", User.ID); } var data = new DictionaryAtom(); data.Set("IsGuildBank", loadGuildbank); DbClient.BeginTransaction(); DbClient.AddCommand("live", "game_GetBank", args, OnBankLoaded, data); }