/* ******************************************************************************************************************************************************************************************************************** */
/// <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>
/// 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);
}