db.Database.SaveBackpacks C# (CSharp) Method

SaveBackpacks() public method

public SaveBackpacks ( Char chr, Account acc ) : void
chr Char
acc Account
return void
        public void SaveBackpacks(Char chr, Account acc)
        {
            if (chr.Backpacks.Count > 0)
            {
                foreach (var i in chr.Backpacks)
                {
                    MySqlCommand cmd = CreateQuery();
                    cmd.CommandText = @"INSERT INTO backpacks(accId, charId, num, items)
            VALUES(@accId, @charId, @num, @items)
            ON DUPLICATE KEY UPDATE
            items = @items;";
                    cmd.Parameters.AddWithValue("@charId", chr.CharacterId);
                    cmd.Parameters.AddWithValue("@accId", acc.AccountId);
                    cmd.Parameters.AddWithValue("@num", i.Key);
                    cmd.Parameters.AddWithValue("@items", Utils.GetCommaSepString(i.Value));
                    cmd.ExecuteNonQuery();
                }
            }
        }