/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAllianceTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = (Byte)source.ID; break; case "name": paramValues[i] = source.Name; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IActiveTradeCashTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "cash": paramValues[i] = source.Cash; break; case "character_id": paramValues[i] = (Int32)source.CharacterID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAllianceAttackableTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "alliance_id": paramValues[i] = (Byte)source.AllianceID; break; case "attackable_id": paramValues[i] = (Byte)source.AttackableID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IShopItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterTemplateSkillTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "skill_id": paramValues[i] = (Byte)source.SkillID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestRequireFinishQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; case "req_quest_id": paramValues[i] = (UInt16)source.ReqQuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "creator_ip": paramValues[i] = source.CreatorIp; break; case "current_ip": paramValues[i] = source.CurrentIp; break; case "email": paramValues[i] = source.Email; break; case "id": paramValues[i] = (Int32)source.ID; break; case "name": paramValues[i] = source.Name; break; case "password": paramValues[i] = source.Password; break; case "permissions": paramValues[i] = (Byte)source.Permissions; break; case "time_created": paramValues[i] = source.TimeCreated; break; case "time_last_login": paramValues[i] = source.TimeLastLogin; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsNetworkTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "connections": paramValues[i] = source.Connections; break; case "id": paramValues[i] = source.ID; break; case "recv_bytes": paramValues[i] = source.RecvBytes; break; case "recv_messages": paramValues[i] = source.RecvMessages; break; case "recv_packets": paramValues[i] = source.RecvPackets; break; case "sent_bytes": paramValues[i] = source.SentBytes; break; case "sent_messages": paramValues[i] = source.SentMessages; break; case "sent_packets": paramValues[i] = source.SentPackets; break; case "when": paramValues[i] = source.When; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IGuildEventTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "arg0": paramValues[i] = source.Arg0; break; case "arg1": paramValues[i] = source.Arg1; break; case "arg2": paramValues[i] = source.Arg2; break; case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "created": paramValues[i] = source.Created; break; case "event_id": paramValues[i] = source.EventID; break; case "guild_id": paramValues[i] = (UInt16)source.GuildID; break; case "id": paramValues[i] = source.ID; break; case "target_character_id": paramValues[i] = (int?)source.TargetCharacterID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterSkillTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "skill_id": paramValues[i] = (Byte)source.SkillID; break; case "time_added": paramValues[i] = source.TimeAdded; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IShopTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "can_buy": paramValues[i] = source.CanBuy; break; case "id": paramValues[i] = (UInt16)source.ID; break; case "name": paramValues[i] = source.Name; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountShopSellTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "last_update": paramValues[i] = source.LastUpdate; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IEventCountersQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "counter": paramValues[i] = source.Counter; break; case "quest_event_counter_id": paramValues[i] = source.QuestEventCounterId; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IEventCountersUserTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "counter": paramValues[i] = source.Counter; break; case "user_event_counter_id": paramValues[i] = source.UserEventCounterId; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IEventCountersItemTemplateTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "counter": paramValues[i] = source.Counter; break; case "item_template_event_counter_id": paramValues[i] = source.ItemTemplateEventCounterId; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterInventoryTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "item_id": paramValues[i] = (Int32)source.ItemID; break; case "slot": paramValues[i] = (Byte)source.Slot; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountConsumeItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "last_update": paramValues[i] = source.LastUpdate; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountCharacterTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "account_id": paramValues[i] = (Int32)source.AccountID; break; case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "time_deleted": paramValues[i] = source.TimeDeleted; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestRequireStartItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IMapSpawnTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "height": paramValues[i] = source.Height; break; case "id": paramValues[i] = (Int32)source.ID; break; case "map_id": paramValues[i] = (UInt16)source.MapID; break; case "width": paramValues[i] = source.Width; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountNpcKillUserTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "last_update": paramValues[i] = source.LastUpdate; break; case "npc_template_id": paramValues[i] = (UInt16)source.NPCTemplateID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountIpsTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "account_id": paramValues[i] = (Int32)source.AccountID; break; case "id": paramValues[i] = source.ID; break; case "ip": paramValues[i] = source.Ip; break; case "time": paramValues[i] = source.Time; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = (UInt16)source.ID; break; case "repeatable": paramValues[i] = source.Repeatable; break; case "reward_cash": paramValues[i] = source.RewardCash; break; case "reward_exp": paramValues[i] = source.RewardExp; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsUserLevelTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "id": paramValues[i] = source.ID; break; case "level": paramValues[i] = source.Level; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IGuildMemberTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "guild_id": paramValues[i] = (UInt16)source.GuildID; break; case "joined": paramValues[i] = source.Joined; break; case "rank": paramValues[i] = (Byte)source.Rank; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountBanTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "account_id": paramValues[i] = (Int32)source.AccountID; break; case "end_time": paramValues[i] = source.EndTime; break; case "expired": paramValues[i] = source.Expired; break; case "id": paramValues[i] = source.ID; break; case "issued_by": paramValues[i] = source.IssuedBy; break; case "reason": paramValues[i] = source.Reason; break; case "start_time": paramValues[i] = source.StartTime; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsQuestCancelTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = source.ID; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IGuildTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "created": paramValues[i] = source.Created; break; case "id": paramValues[i] = (UInt16)source.ID; break; case "name": paramValues[i] = source.Name; break; case "tag": paramValues[i] = source.Tag; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsGuildUserChangeTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "guild_id": paramValues[i] = (ushort?)source.GuildID; break; case "id": paramValues[i] = source.ID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; case "when": paramValues[i] = source.When; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterQuestStatusKillsTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "count": paramValues[i] = source.Count; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IServerTimeTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "server_time": paramValues[i] = source.ServerTime; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsUserShoppingTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "cost": paramValues[i] = source.Cost; break; case "id": paramValues[i] = source.ID; break; case "item_template_id": paramValues[i] = (ushort?)source.ItemTemplateID; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "sale_type": paramValues[i] = source.SaleType; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IActiveTradeItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "item_id": paramValues[i] = (Int32)source.ItemID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountBanTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "account_id": paramValues[i] = (Int32)source.AccountID; break; case "end_time": paramValues[i] = source.EndTime; break; case "expired": paramValues[i] = source.Expired; break; case "id": paramValues[i] = source.ID; break; case "issued_by": paramValues[i] = source.IssuedBy; break; case "reason": paramValues[i] = source.Reason; break; case "start_time": paramValues[i] = source.StartTime; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountUserKillNpcTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "last_update": paramValues[i] = source.LastUpdate; break; case "npc_template_id": paramValues[i] = (UInt16)source.NPCTemplateID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IMapSpawnTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "height": paramValues[i] = source.Height; break; case "id": paramValues[i] = (Int32)source.ID; break; case "map_id": paramValues[i] = (UInt16)source.MapID; break; case "width": paramValues[i] = source.Width; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAllianceAttackableTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "alliance_id": paramValues[i] = (Byte)source.AllianceID; break; case "attackable_id": paramValues[i] = (Byte)source.AttackableID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsGuildUserChangeTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "guild_id": paramValues[i] = (ushort?)source.GuildID; break; case "id": paramValues[i] = source.ID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; case "when": paramValues[i] = source.When; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IShopItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsUserKillNpcTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = source.ID; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "npc_template_id": paramValues[i] = (ushort?)source.NPCTemplateID; break; case "npc_x": paramValues[i] = source.NpcX; break; case "npc_y": paramValues[i] = source.NpcY; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; case "user_level": paramValues[i] = source.UserLevel; break; case "user_x": paramValues[i] = source.UserX; break; case "user_y": paramValues[i] = source.UserY; break; case "when": paramValues[i] = source.When; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterSkillTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "skill_id": paramValues[i] = (Byte)source.SkillID; break; case "time_added": paramValues[i] = source.TimeAdded; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IGuildTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "created": paramValues[i] = source.Created; break; case "id": paramValues[i] = (UInt16)source.ID; break; case "name": paramValues[i] = source.Name; break; case "tag": paramValues[i] = source.Tag; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterTemplateEquippedTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "chance": paramValues[i] = (UInt16)source.Chance; break; case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "id": paramValues[i] = source.ID; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = (UInt16)source.ID; break; case "repeatable": paramValues[i] = source.Repeatable; break; case "reward_cash": paramValues[i] = source.RewardCash; break; case "reward_exp": paramValues[i] = source.RewardExp; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsUserLevelTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "id": paramValues[i] = source.ID; break; case "level": paramValues[i] = source.Level; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IEventCountersQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "counter": paramValues[i] = source.Counter; break; case "quest_event_counter_id": paramValues[i] = source.QuestEventCounterId; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IItemTemplateTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "action_display_id": paramValues[i] = (ushort?)source.ActionDisplayID; break; case "description": paramValues[i] = source.Description; break; case "equipped_body": paramValues[i] = source.EquippedBody; break; case "graphic": paramValues[i] = (UInt16)source.Graphic; break; case "height": paramValues[i] = source.Height; break; case "hp": paramValues[i] = (Int16)source.HP; break; case "id": paramValues[i] = (UInt16)source.ID; break; case "mp": paramValues[i] = (Int16)source.MP; break; case "name": paramValues[i] = source.Name; break; case "range": paramValues[i] = source.Range; break; case "stat_agi": paramValues[i] = (Int16)source.GetStat(StatType.Agi); break; case "stat_defence": paramValues[i] = (Int16)source.GetStat(StatType.Defence); break; case "stat_int": paramValues[i] = (Int16)source.GetStat(StatType.Int); break; case "stat_maxhit": paramValues[i] = (Int16)source.GetStat(StatType.MaxHit); break; case "stat_maxhp": paramValues[i] = (Int16)source.GetStat(StatType.MaxHP); break; case "stat_maxmp": paramValues[i] = (Int16)source.GetStat(StatType.MaxMP); break; case "stat_minhit": paramValues[i] = (Int16)source.GetStat(StatType.MinHit); break; case "stat_req_agi": paramValues[i] = (Int16)source.GetReqStat(StatType.Agi); break; case "stat_req_int": paramValues[i] = (Int16)source.GetReqStat(StatType.Int); break; case "stat_req_str": paramValues[i] = (Int16)source.GetReqStat(StatType.Str); break; case "stat_str": paramValues[i] = (Int16)source.GetStat(StatType.Str); break; case "type": paramValues[i] = (Byte)source.Type; break; case "value": paramValues[i] = source.Value; break; case "weapon_type": paramValues[i] = (Byte)source.WeaponType; break; case "width": paramValues[i] = source.Width; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IGuildMemberTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "guild_id": paramValues[i] = (UInt16)source.GuildID; break; case "joined": paramValues[i] = source.Joined; break; case "rank": paramValues[i] = (Byte)source.Rank; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestRequireFinishItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterStatusEffectTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "id": paramValues[i] = (Int32)source.ID; break; case "power": paramValues[i] = source.Power; break; case "status_effect_id": paramValues[i] = (Byte)source.StatusEffect; break; case "time_left_secs": paramValues[i] = source.TimeLeftSecs; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterQuestStatusTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "completed_on": paramValues[i] = source.CompletedOn; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; case "started_on": paramValues[i] = source.StartedOn; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsQuestCancelTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "id": paramValues[i] = source.ID; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; case "user_id": paramValues[i] = (Int32)source.UserID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IQuestRequireFinishQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; case "req_quest_id": paramValues[i] = (UInt16)source.ReqQuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountIpsTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "account_id": paramValues[i] = (Int32)source.AccountID; break; case "id": paramValues[i] = source.ID; break; case "ip": paramValues[i] = source.Ip; break; case "time": paramValues[i] = source.Time; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountConsumeItemTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "item_template_id": paramValues[i] = (UInt16)source.ItemTemplateID; break; case "last_update": paramValues[i] = source.LastUpdate; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IAccountTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "creator_ip": paramValues[i] = source.CreatorIp; break; case "current_ip": paramValues[i] = source.CurrentIp; break; case "email": paramValues[i] = source.Email; break; case "id": paramValues[i] = (Int32)source.ID; break; case "name": paramValues[i] = source.Name; break; case "password": paramValues[i] = source.Password; break; case "permissions": paramValues[i] = (Byte)source.Permissions; break; case "time_created": paramValues[i] = source.TimeCreated; break; case "time_last_login": paramValues[i] = source.TimeLastLogin; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterEquippedTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "item_id": paramValues[i] = (Int32)source.ItemID; break; case "slot": paramValues[i] = (Byte)source.Slot; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsCountShopBuyTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "count": paramValues[i] = source.Count; break; case "last_update": paramValues[i] = source.LastUpdate; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterTemplateSkillTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "skill_id": paramValues[i] = (Byte)source.SkillID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "ai_id": paramValues[i] = (ushort?)source.AIID; break; case "body_id": paramValues[i] = (UInt16)source.BodyID; break; case "cash": paramValues[i] = source.Cash; break; case "character_template_id": paramValues[i] = (ushort?)source.CharacterTemplateID; break; case "chat_dialog": paramValues[i] = (ushort?)source.ChatDialog; break; case "exp": paramValues[i] = source.Exp; break; case "hp": paramValues[i] = (Int16)source.HP; break; case "id": paramValues[i] = (Int32)source.ID; break; case "level": paramValues[i] = source.Level; break; case "load_map_id": paramValues[i] = (UInt16)source.LoadMapID; break; case "load_x": paramValues[i] = source.LoadX; break; case "load_y": paramValues[i] = source.LoadY; break; case "move_speed": paramValues[i] = source.MoveSpeed; break; case "mp": paramValues[i] = (Int16)source.MP; break; case "name": paramValues[i] = source.Name; break; case "respawn_map_id": paramValues[i] = (ushort?)source.RespawnMapID; break; case "respawn_x": paramValues[i] = source.RespawnX; break; case "respawn_y": paramValues[i] = source.RespawnY; break; case "shop_id": paramValues[i] = (ushort?)source.ShopID; break; case "statpoints": paramValues[i] = source.StatPoints; break; case "stat_agi": paramValues[i] = (Int16)source.GetStat(StatType.Agi); break; case "stat_defence": paramValues[i] = (Int16)source.GetStat(StatType.Defence); break; case "stat_int": paramValues[i] = (Int16)source.GetStat(StatType.Int); break; case "stat_maxhit": paramValues[i] = (Int16)source.GetStat(StatType.MaxHit); break; case "stat_maxhp": paramValues[i] = (Int16)source.GetStat(StatType.MaxHP); break; case "stat_maxmp": paramValues[i] = (Int16)source.GetStat(StatType.MaxMP); break; case "stat_minhit": paramValues[i] = (Int16)source.GetStat(StatType.MinHit); break; case "stat_str": paramValues[i] = (Int16)source.GetStat(StatType.Str); break; } } }